Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

DTS Migration and DTS Runtime in 2008 R2 Expand / Collapse
Posted Thursday, November 15, 2012 10:58 AM


Group: General Forum Members
Last Login: Monday, December 5, 2016 11:44 AM
Points: 15, Visits: 456
I have about 300 DTS packages that need to be moved to a 2008 R2 environment.

While some of these are pretty straight forward and can be converted to simple SSIS packages, I have some that are rather complex to include quite a few with ActiveX Scripts.

Is it functional to use the DTS runtime under 2008 R2 to execute these packages from the scheduled jobs?
How can I incorporate Powershell scripts as replacements (if I can) for tose with ActiveX and VB Scripts

I appreciate any assistance with this topic.

Thank you
Post #1385276
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse