Friday, February 17, 2012

Created .dtsx file How do I schedule it?

How dow you schedule a file(.dtsx)(I think it is a package) that was created in the SQL Server BI Design Studio to run? I can locate the file I created in SQL Server Management Studio and see it in the right hand pane and even edit it. I can run it in the Design Studio, but cant see how to do that in Management Studio nor how to schedule it.

This is my first attempt at recreating a DTS package using SQL Server tools instead of the Legacy conversion wizard, and I think my brain has overheated. I just cant find it on the Management Screen or the Design. I am also not searching correctly anymore on books online because I cannot find it.

Thanks for pointing me to where I need to go or do.


Tracey


You can run it from a SQL Agent job, or from the command line with DTEXEC or DTEXECUI (which has a gui, and can be useful for getting the appropriate options to execute the package).|||You can schedule a package to execute by creating a SQL Agent job that calls the job. If you're familar with DTS, it's similar but better as all the features of DTEXECUI are available to you when you create the step.|||

Thank you so much. This is exactly what I needed. I think I had just gotten myself too flustered and you cleared it all up.

No comments:

Post a Comment