January 9, 2009 at 6:57 pm
hello,
i migrated the dbs from 2000-2005..we also copied DTS to DTS(not SSIS)..packages are still in legacy components(dnt ask why not SSIS..long story)...migrated the jobs to 2005..now for a job to run the way it is in previous server how should i make it work especially jobs dealing with packages..in new server will the jobs have the same package id or do i need to change the packaage id...if yes how do i get thje package id..please someone suggest me..very simple..my intension is to make the jobs work like they did in previous server...thansk..
January 9, 2009 at 7:33 pm
not sure, but you can create an SSIS package to execute a DTS package. i have to create new DTS packages on a sql 2005 machine and this is how i run them
January 9, 2009 at 9:51 pm
iqtedar (1/9/2009)
hello,i migrated the dbs from 2000-2005..we also copied DTS to DTS(not SSIS)..packages are still in legacy components(dnt ask why not SSIS..long story)...migrated the jobs to 2005..now for a job to run the way it is in previous server how should i make it work especially jobs dealing with packages..in new server will the jobs have the same package id or do i need to change the packaage id...if yes how do i get thje package id..please someone suggest me..very simple..my intension is to make the jobs work like they did in previous server...thansk..
U have to import DTSpackage and edit into sql server 2000 DTS designer and save into sql server 2005.
January 10, 2009 at 8:13 am
thanks for your reply......i think you mistook my question....jobs are mgrated from 2000 - 2005..the packages are copied not migrated..so they are still legacy components...the migrated jobs will run using legacy DTS packages...i do not think editing each DTS package and saving as SSIS is practical..i was trying to find a way to re-sync the migrated jobs with the legacy DTS packages..thx
January 10, 2009 at 4:30 pm
i found it out from one of the posts in this forum..i knew that i have to select Operating Cmd option in order to execute a DTS package as a job in sql server 2005..but was looking for the DTS run command..here it is:
dtsrun /S "servername" /E /N "package name"
thats it!!..it worked for me..thanks again..
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy