Deploying To Subfolders From VS
Jun 29, 2006
I've got a report project with a few reports in I want in the root target directory. I also want to create several folders and put reports in those. The problem is I don't see any way to create a report folder in VS. I also don't see any way to pick the deployment path of a single reprot in VS. This makes me think I'll have to create a different Report Project in VS for each folder!! (this sucks). Does anyone have an idea or suggestion here?
View 9 Replies
ADVERTISEMENT
Apr 22, 2015
Is there any way to read the subfolders? I'm going to explain. I used to read several csv file from one folder using ForEach Loop Container, just set up the variable and passing the variable to the Flat File Connection Propriety. Now I must read several file from several folders (all subfolder by a main folder). How can I do?
View 10 Replies
View Related
Feb 8, 2008
I seem to be missing something rather obvious... I cannot find a way to create subfolder in my reports project in Visual Studio (2005).
Can someone help me out here?
View 11 Replies
View Related
Dec 17, 2007
Hello,
When you create a Reporting Services project it by default creates two folders: Shared Data Sources & Reports. When I right click on the Reports folder in solution explorer in Visual Studio 2005 there is no option to add subfolders, I am simply left with handful of options adding report files. Is there a way to add subfolders to the Reports folder? I am going to be migrating over 40-50+ reports and it would be helpful to organize them into their own folders.
Thanks,
Flea
View 3 Replies
View Related
Aug 20, 2015
how can I copy the content of the folder (including sub folders) from FTP location using ssis.
View 4 Replies
View Related
Apr 26, 2007
Hi All,
I am adding a reporting suite to our application based upon SSRS 2005 and I am looking for a comprehensive example of how I go about deploying this.
Essentially I want to automate the entire process:
Create the DB, Create the Virtual Dirs, add my reports etc.
I have looked at the documentation and it is limited to say the least. I went down the route of attempting to script the whole thing and after 3 days of it I was still stuck on a few problems so I was hoping that someone knows of an example of how to go through all of these processes.
An example of the problems I ran into is that the "CreateVirtualDir" method on the reporting services WMI objects simply didn't work. It didn't return an error but it didn't create the Dir either!
The documentation around this method and most others is ambiguous and contains no examples.
I then went down the route of using IIS WMI to create the dirs which worked but then I was unable to update the Reporting Services configuration to pick this up without resorting to changing the config files directly - and even when I did this they didn't always seem to be picked up.
So at present instead of giving our guys in deployment a 1 click install they have a 9 page document explaining the install and set up of Reporting services from start to finish.
Any help or more thorough documentation would be greatly appreciated.
thanks,
Dhugal.
PS: Just to add I have already altered our install to install the RS module along with SQL Server so that bit is covered. I just want to script the entire configuration process.
View 1 Replies
View Related
Nov 7, 2006
what is the easiest way to deploy a database for a webapp? i have create table scripts but waht is the easiest way to go about inserting data into lookup tables? would i have to write insert statements or is there some other way to do it
View 2 Replies
View Related
Apr 9, 2004
We're about to ship a product, and we've used access to develop it to make things easier, but we want to use MSDE.
I've never had any luck with MSDE -
1. I can import the database into a sql server database in enterprise manager, is there a way to import a database into a msde database in interprise manager?
2. what would I do in the installer? I need to install the msde engine right? and then run sql scripts on the engine?
Thanks in advance!
View 2 Replies
View Related
Dec 19, 2000
I am looking for an effective technique for this scenario:
We have a program that generates 200 custom Paradox databases every night, and these are shipped to 200 sales offices (on Win98 machines). We would like to convert from Paradox to MSDE (baby SQL).
The data is relatively large (some offices > 100 MB) so efficiency is important, both for data generation, data transmission and/or data loading. Currently we zip files so the large 100MB ones are <20MB during transmission.
Is it best to: 1) output flat files, zip them, transmit, and then have an automatic load procedure (using bcp) on the Win98 clients; or 2) create the MSDE databases locally, zip them, transmit, and then db_attach the database file on the Win98?
Has anyone a successful experience doing this sort of thing?
View 1 Replies
View Related
Sep 2, 2005
Hi Well this is my first post on this forum, in fact I have not even used SQL Server yet!
My question is.... I have been asked to produce an application which will be a VB6 application with an SQL Server database behind it. I would like to be able to put the application along with the database on to a CD and run them directly from the CD once it is distributed. So the question I guess is can this be done with SQL Server i.e. can a table be exported in a format which will allow it to be queried in a standalone fashion? Maybe I have not explained myself properly but I welcome any questions which will help clarify my problem.
Thanks Red
View 1 Replies
View Related
Jun 14, 2006
I am having problems deploying my web site from my machine to the hosting server.
Does any know of any special configurations that have to be perfomed before copying your web site to a server? All I have is a login in page that loads another page. The login page is launching okay but it does not load the second page.
View 2 Replies
View Related
Feb 7, 2008
Hi I've not done much work on reporting services before.
I've made a change on my page and i can see the change on the preview its just a drop down list containing the week number.
But i can see to get to deploy these changes when i build my package it builds fine but when i go to deploy it am getting this error message
The item '/Data sources' already exist
View 3 Replies
View Related
Feb 23, 2007
Hi
We are storing our packages in File System.
Process:
BIDS->Right Click on soln file ->properties->Deployment Utility->DeploymentOutputPath--BinDeployment
So it creates a folder with the project name and all the packages in C:Program FilesMicrosoft SQL Server90DTSPackagesProject
While executing the package on Server what should be thesource of the Package? I mean should it refer to the solution file->..dtsx
or
BinDeployment->packages
or
C:Program FilesMicrosoft SQL Server90DTSPackagesProject
View 3 Replies
View Related
Feb 15, 2008
Hi,
we are working with Sql Server Reporting services for creating reports. what is my question is , how we can create a setup for deploying the reports in the report server. please advise
Thanks
View 4 Replies
View Related
May 19, 2007
I'm having a little bit of trouble deploying the report project I have set up. In fact, I'm not even sure that deploying the project is what I want to do. All I want is to have something so I can view the report I've created in HTML or PDF form, something that was advertised when I downloaded the reporting services. Any help with what I would need with this would be appreciated.
View 5 Replies
View Related
May 7, 2007
I am new to Reporting services and have created just a layout page.
no datasets or data sources are present. This is just a cover page.
I need to show this page through a url. Can i deploy this on my local machine rather than showing some-one through the preview mode.
What would be the local host configuration settings.
Thanks.
View 11 Replies
View Related
Mar 12, 2008
I am having troubles with deploying reports to http://localhost/reportserver. A dialogue box pops up asking for username and password. I have been investigating Reporting Services Configuration trying to find out more about what username and password they are after, but with no luck. Can somebody please help. I am using SQLExpress 2005 and IIS 5.1
OR
View 7 Replies
View Related
Sep 11, 2007
Hi,
How do i deploy IS package properly? can i just copy the .dtsx and assign that in an sql jobs?
thanks a lot
cherriesh
View 3 Replies
View Related
Jan 30, 2008
Newbie question for which I ask your patience:
I had set my ProjectpropertiesTarget Server URL some time ago and now need to deploy additional files in specific folders and cannot remember how to map a url back to a file location. I have searched for the deployed files on target server and have not found them.
Can someone explain how SSRS deploys; does it physically place files on the target server (.pdfs)? Suggest how I can map the URL back to a directory location on some server?
thanks, MDM
View 3 Replies
View Related
Jul 3, 2007
Just wondering what people do when they deploy sub reports and what is the 'best practise' for this. I'm just deploying them to the same folder as the main report and hiding them.
This is, to say the least, messy. As a user has to click 'Show Details' and they can see the sub report.
Is there a better way?
Thanks
View 4 Replies
View Related
May 1, 2006
Error: 0xC0202009 at Package, Connection manager "Presup Dev sql_prov": An OLE DB error has occurred. Error code: 0x80040E4D.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "TCP Provider: Se ha forzado la interrupción de una conexión existente por el host remoto.
WTF????????? �%$�&$%%& i`m sure my connections are ok,, cause i prevoiusly checked them, the problem occurs when deploying the package.. it seems to be an error when connecting to the source but whyy?????, and what about the package configurations ?? should i use them,, and how????
View 4 Replies
View Related
Feb 21, 2008
hi all
using sqlserver 2005 Reporting Services
When I go to deploy
my main folder = Reports
my sub folder = reAct or Managers Reports or Onboarding etc
how do I deploy directly to the sub-folders?
thanks
jewel
View 13 Replies
View Related
Feb 10, 2006
I have a report model that I'm trying to deploy to a report server. When I deploy it I get an error that says
Maximum request length exceeded. How do I fix this error and get the model deployed
View 4 Replies
View Related
Aug 21, 2006
I used VWD 2005 Express to create my web application (that uses a sql 2005 database), and now I'm trying to deploy it. I was to understand that all I had to do was to upload all my files to the root folder and the web host's server (webhost4life.com). However, they require me to upload the sql 2005 db to a seperate sql server using a control panel that is very clunky. Does anyone know how to upload the sql 2005 db to the host server or an online tutorial where I could go to learn? Thanks for the help!
View 1 Replies
View Related
May 15, 2007
Rank newbie to ASP.NET here, so I'm totally "at sea" as to finding a "cookbook" for "how to deploy" a slightly customized version of the "Personal Web Site" project.
My hosting service has an ASP.NET database installed. I can verify from their "SQL Server Web Admin" package that there are 11 "aspnet_" table names present. I have run the "personal-add.sql" script which has defined two (empty) tables -- "Albums" and "Photos".
CONFUSION 1: The hosting service includes a Help fille for "Connecting to a SQL Server Database Using ASP.NET 2.0" which details the way to add 'connectionStrings' for "Personal" and "LocalSqlServer". I have made a "remote" copy of the "web.config" file and supplied the ostensively correct info for my Server, Database, User ID and Password. QUESTION: Why are there TWO names -- "Personal" and "LocalSqlServer"? Since all of the tables are contained now within the ASP.NET database are the details for both of these to be the same?
CONFUSION 2: Error handling. I'm getting "An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine." Huh!? That page then goes on to mention "<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>". I've not a clue as to what "mycustompage.htm" should contain in order to field the error[s] erupting.
POINTERS, anyone? Have I missed some basic part of the manual[s] someplace? I was sort of hoping that there would be a simple "cookbook" around someplace for how to "deploy" a relatively tested group of pages (application) in a relatively idiot-proof manner. I'm not finding it, so ANY pointers, hints, URLs will be greatly appreciated.
Color me "confused in Kauai" ... :) KevInKauai
View 2 Replies
View Related
Jun 25, 2007
Since from using my local host to view my website, I am assuming I already have SQL Server installed on my computer? Is it possible to have users access my website files directly onto there own computer, say if they type my ip address or domain name into their address bar? What I am actually wanting to do is to host my website from my home computer... Any ideas, or good slash easy to understand articles on how to do this?
View 8 Replies
View Related
Nov 24, 2004
I'm working on a web application that uses SQL Server 2000. Once I'm ready to upload my website to a production server, I need to know how to upload my SQL Server database files to the server. Are there actual files that can be uploaded? I've only deployed a website that works with MySQL to a production server, and there were no files to upload... the database had to be created on the server, and then the data itself had to be exported to text files (on my computer), then imported/uploaded to the production server using SQL statements...
How do I do this?
Thanks~
View 2 Replies
View Related
Apr 13, 2006
My ASP.NET application runs fine within the VS2005 IDE; but, when I deploy to my local machine to try to run it under IIS and calling it up in a browser, I'm getting the following exception:
Exception Details: System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734979 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770 System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +92 System.Web.UI.WebControls.ListControl.PerformSelect() +31 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +26 System.Web.UI.Control.PreRenderRecursiveInternal() +77 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
I'm a novice at this and really need some help. What stupid newbie mistake am I making here? Thanks in advance for any guidance/assistance rendered.
View 2 Replies
View Related
Oct 14, 2014
Was wondering, when performance changes have been made to existing code and deployed to a production environment, should anything be done regarding clearing old cache?
Is there a risk of the new code picking up cold or wrong cached query plans etc?
I know you can't clear the cache for the full system as it will affect everything else. But are the ways to target the changes? I.E run the new code with an OPTION (RECOMPILE) few times to build up new clean plans for it to use?
Or will the update stats see it is using bad plans and then start creating new clean ones over time?
View 5 Replies
View Related
Jun 11, 2008
Sir,
I have created reports in SQL Server reporting services(SSRS)and when i publish the report in the Localhost server it can be viewed in browser only in the INTRANET network but my intention is to generate the INTERNET URL of the report such that report published can be viewed in INTERNET outside this network..
Can u suggest any solution to do the same..
Looking Forward to an early reply..
Thank You!!!
View 1 Replies
View Related
May 4, 2006
Hi,
We are using SQL-Server (2005) for the first time and have developed an app that uses 2 dozen tables and a bunch of SP, triggers, etc.
How do we get our entities to our client site without a lot of copying and pasting? How about the data we want to upload for lookup tables - how would we get the data there?
Moreover, how do we sync stored procedures with the live database as we make changes during development?
Thanks,
Mark
View 1 Replies
View Related
Jul 13, 2007
Guys,
Let me first give you a little bit of background...
One of my goals for this year is to migrate all DTS packages to SSIS, those DTS packages are used across the company by different groups/users.
Since I'm still not that familiar with SSIS and like many here, was well used to the enterprise manager view (all DTS packages on 1 single place), I'm unsure on how to structure my SSIS packages in a way that I could break it down by group let's say.
The way that I'm doing right now is: I'm creating a solution for each group and creating the SSIS packages (.dtsx) relative to that group inside each solution, that's pretty easy. Now, the next thing that I'll have to figure out (and hope you guys can help) is how to deploy them structured this way and how to handle these packages to my end users. Basically, how do I handle "Group A" all of their SSIS packages? Will they have to open the package in debug mode on VS every time they need to execute a package?
Thoughts on this?
View 3 Replies
View Related
Sep 7, 2007
Hi,
I am very new to SQL 2005. I have built a DTS package in SSIS (package.dtsx). How do I get this onto my database server?
simplest things are often the hardest!!
Thanks
David
View 1 Replies
View Related
