Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Thursday, November 15, 2012 10:58 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 2:52 PM
Points: 14, Visits: 360
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