Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jp2code
Posting Yak Master
175 Posts |
 Posted - 2011-06-08 : 12:07:29
|
We have been running SQL Server 2000 for years.Finally, at long last, we have an SQL 2008 Server being shipped in.We have many DTS jobs on our 2000 Server that need to be migrated to the 2008 Server.Would I need to post the code from each DTS job to find out how to migrate it, or is there information somewhere on how to go about converting these?I am a WinForms C# developer that makes calls, builds stored procedures and occasionally creates a new table for our SQL Server, but I am not a Database Administrator by title.I want to make sure I do this right so that our company has minimal down time.~Joe
Avoid Sears Home Improvement (read why) |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-06-08 : 13:01:38
|
It depends on what each job is doing...Starting a dts package?Executing a stored procedure?...
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
jp2code
Posting Yak Master
175 Posts |
|
|
jp2code
Posting Yak Master
175 Posts |
Posted - 2011-06-08 : 14:41:01
|
From our SA:quote:
From what I am reading, I will have to do more research, we have to convert all the Data Transformation Services (DTS) packages to SQL Server Integration Services (SSIS). I do not know what this may take but from my understanding, the jobs are written in .Net. If we could migrate them, great, but if not we may have to write new ones for all, which would not be that hard once you have the first one written.
Does this help?~Joe
Avoid Sears Home Improvement (read why) |
|
|
|
|
|
|
|
|
Migrating DTS Jobs to 2008 Server