Groups | Blog | Home
all groups > sql server dts > october 2007 >

sql server dts : Schedule DTS



¤j¬Ó
10/30/2007 12:00:00 AM
Hi,

I have migrated some DTS from SQL2000 to SQL2005, how can I schedule a DTS
under SQL 2005?

Francisco A. Gonzalez
10/30/2007 12:00:00 AM
Hi
Goog question!!
You have to use DTSRUN as a xp_cmdshell in a SQL Agent step to execute the
package. from there you can also execute packages that are store in the
msdb.
In order to use DTSRUN you have to install the compatibility pack.

cheers
--

Francisco A. Gonzalez
fgonzalez@solidq.com



[quoted text, click to view]

jhofmeyr NO[at]SPAM googlemail.com
10/30/2007 11:51:44 PM
On Oct 30, 10:32 am, "Francisco A. Gonzalez" <fgonza...@solidq.com>
[quoted text, click to view]

Hmm,

I usually leave this to the DB Admins, but I was under the impression
you could just create a schedule for the packages and SQL Server would
sort out creating the SQL Agent job and stuff for you :)

Will have to check.
J
AddThis Social Bookmark Button