Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How can I run an SSIS package on a remote web hosting SQL SERVER 2005
The problem with staying with DTS is that DTS came with SQL Server 2000. I believe they are not going to be supporting it much longer with SQLServer 2008 comming out. Also, I don't know if you can update DTS packages with SSIS, which basically means, I'd need to stay with all the old SQLServer...- idea4
- Post #5
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
How can I run an SSIS package on a remote web hosting SQL SERVER 2005
My understanding is that to use dtexec, you need SSIS installed on the client computer. My users don't have SSIS installed. I was previously running DTS from the local machine and connecting to the server of the hosting company. I just can't figure out how to do it with SSIS. here's the VB...- idea4
- Post #3
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
How can I run an SSIS package on a remote web hosting SQL SERVER 2005
Goal: transform and move data from an MS Access database to a shared SQLServer 2005 database located on a web hosting site whenever the MS Access database is updated. background: I have a shared SQLServer 2000 and SQLServer2005 database on a web hosting server. I have been running DTS from...- idea4
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Integration Services (SSIS)
