DTS to SSIS 2005 migration - password encryption

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » DTS to SSIS 2005 migration - password...

DTS to SSIS 2005 migration - password encryption - DTEXEC

Rate Topic

Display Mode

Topic Options

Author

Message

sas-473105

Posted Friday, May 01, 2009 9:14 AM

Forum 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

raul.manongdo

Posted Monday, March 01, 2010 5:42 AM

Forum 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 Hehe

Post #874372

« Prev Topic | Next Topic »

Permissions