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 to SSIS 2005 migration - password encryption - DTEXEC Expand / Collapse
Author
Message
Posted Friday, May 01, 2009 9:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 13, 2012 5:26 AM
Points: 3, Visits: 59
Hi,

we are migrating DTS to SSIS 2005,

In the DTS package, there are variables for passwords and those variable will be used for connections.

so the values will be passed thru command line...DTSRUN
eg. DTSRUN /F packagename /A variablename:=value....

and for the production environment we will encrypt the command line parameter and pass it.
eg. DTSRUN [encrypted parameters]


so the person who runs the above command dont know the information thar are passed in the DTSRun command.


In SSIS, DTEXEC does not spport the encryption option. how do we get the same kind of approach here?

can anyone help me out on this?


Thanks in advance.
Sasi.
Post #708520
Posted Monday, March 01, 2010 5:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 02, 2010 10:23 PM
Points: 1, Visits: 9
Hello all, i am a newbie and this is my first post.

Perhaps my problem is related.
When I execute a DTS 2000 as a legacy, it executes successfully.
When I migrate it, it appears under MSDB and with what I'd been reading, package migration also converts it into a new format in 2005.
When I execute it though, one task in the package fails, and the package run log says 'package or DB password encryption eror'. The DTS package task simply insert rows from an Excel spreadsheet after some basic transformation (column mappings). I also get prior warnings on truncation and varying column sizes.

Raul



Post #874372
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse