July 9, 2009 at 2:00 pm
Hi
Could anyone tell me how to create a job that can execute a legacy DTS package which is migrated from SQL Server 2000 instance (32-bit) to SQL Server 2005 (64 bit) instance sitting on a cluster?
Also the cluster has no default instance. It has only one Named instance.
Thank You,
Yours,
SQLBuddy
July 9, 2009 at 5:21 pm
I'll preface this with "I haven't had this exact issue myself", BUT, I think you can use the command line from your old job BUT you need to find the location of the DTSRUN executable and give the FULL path to it in your job. I would start your search in C:\Program Files(x86)
I *think* that will work..
CEWII
July 9, 2009 at 5:38 pm
Select job type as cmdexec from within a new job / job step properties.
Give it a command such as :
DTSRun /S"Servername" /E /N"DTSPackageName"
It should be able to do it without the exact path.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 9, 2009 at 5:42 pm
In 2005 64-bit.. Only if the directory that it is in is in the path.. I didn't think it did that..
CEWII
July 9, 2009 at 6:47 pm
Hi CirquedESQLeil ,
Thank you very much for your reply.
Actually I tried the method you mentioned.It worked well. But previously I was thinking that I have to specify the entire path for the DTSrun in the job step.
Still I don't understand why is it so. But I think specifying the path for DTS run also works. I think I have tried it in the morning and it worked similar to the method in which we don't mention the path.
Yours
SQLBuddy.
July 9, 2009 at 6:50 pm
Hi Elliott,
Thanks a lot for your help.
Yours
SQL Buddy
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply