February 8, 2018 at 5:31 am
Dear Friends
im have a sql 2000 database
im backuped and restore this database with sucess in sql 2008
How im can backup DTS to restore in sql 2008?
obs : after this im can restore DTS in SQL 2012?
Thanks
Almir
February 8, 2018 at 9:34 am
You can't. You have to rebuild your DTS as SSIS. Here's some documentation to help out. In some cases, you can run a DTS package inside an SSIS package, but I always found that to be extremely problematic. Best to rebuild them as SSIS.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 9, 2018 at 6:03 am
Grant Fritchey - Thursday, February 8, 2018 9:34 AMSou can't. You have to rebuild your DTS as SSIS. Here's some documentation to help out. In some cases, you can run a DTS package inside an SSIS package, but I always found that to be extremely problematic. Best to rebuild them as SSIS.
im export DTS in SQL 2000 and import in SQL 2008
but how im can build export to SQL 2012 ?
February 9, 2018 at 6:10 am
You can't. You'll have to rewrite it as an SSIS package.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply