October 8, 2007 at 4:23 am
I'm running SQL Server 2000 and Analysis Services 2005 on the same SQL Server. I've used SSIS (2005, obviously) to create a package which:
1. runs a bunch of sql scripts to update my data warehouse, stored in SQL Server 2000
2. Process my cube, written in AS2005
I'm trying to use SSMS 2005 to create and schedule the package. When I go to choose the job type, SQL Server Integration Services Package (or anything like that) is not there. I have another SQL Server on the network which is running SQL Server 2005 (though it doesn't store the data warehouse or the cube). I could possibly use this machine to schedule the job remotely.
What is the best way for me to schedule my SSIS package? Would scheduling the package on the remote server results in a significant performance hit? If so, what is the command line I need to run to execute my package?
October 10, 2007 at 1:45 pm
you can use DTutil /S " " /W "0"
October 10, 2007 at 1:47 pm
sorry i had used tags before
you can use DTutil /S "--your server name--" /E /N "--your package name--" /W "0"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply