June 17, 2008 at 6:36 am
Can you please tell me the steps to convert my DTS package
to Sql server 2005 & to schdule that?
June 17, 2008 at 7:15 am
There's an upgrade wizard that can handle some DTS packages. MSDN has data on that. If it can't be done by the wizard, you'll need to rebuild it in SSIS yourself. Scheduling it is just a matter of building a job for it in SQL Server Agent.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 17, 2008 at 7:17 am
[font="Verdana"]You can import the dts package under the legacy node and from then on you can schedule it using dtsrun utility. Have a look at this http://msdn.microsoft.com/en-us/library/aa224467(SQL.80).aspx
[/font]
[font="Verdana"]- Deepak[/font]
June 17, 2008 at 9:52 am
Importing DTS packages and running them as legacy packages is a good choice if you want to take your time migrating them to SSIS. That's the route we've chosen because we had our hands full just upgrading our SQL Servers to SQL 2005.
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply