SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Export Massive DTS to a structurated file storage
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

alejo46
Posting Yak Master

Colombia
148 Posts

Posted - 08/06/2014 :  21:17:13  Show Profile  Reply with Quote
Good night, i need your help pls

i know the DTS package were in older sql server vesrtions and slqver 2008 support ssis but initially in a Production server there was an upgrade from ss2000 to ss2008.

The problem is i was asked to export a masive DTS to a file, i know how to do it manually to a structured file storage.
Is there any way to export massive DTS packages because there are about 100 DTS ?

I really appreciate your help in advanced

gbritton
Flowing Fount of Yak Knowledge

1753 Posts

Posted - 08/07/2014 :  08:09:00  Show Profile  Reply with Quote
see here: http://msdn.microsoft.com/en-ca/library/bb500440(v=sql.105).aspx

and here: http://msdn.microsoft.com/en-ca/library/bb500440(v=sql.105).aspx#migrating_pkg
Go to Top of Page

tm
Posting Yak Master

160 Posts

Posted - 08/07/2014 :  14:16:42  Show Profile  Reply with Quote
Not sure if this is what is required, below link uses SQL script and batch file to extract DTS from msdb.

http://stackoverflow.com/questions/16309263/script-to-export-all-dts-packages-on-is-to-file-system
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000