May 1, 2009 at 9:14 am
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.
March 1, 2010 at 5:42 am
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:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply