July 31, 2008 at 4:12 pm
I have tried to EncryptAllWithPassword and use a password for my packages before deploying them to either the File System or SQlServer.
I use the CycleProcess.SSISDeploymentManifest to deploy my files and enter a password when asked to.
When I schedule the job as using Integration Services package either SQL Server or File System or use the command option
with
C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTExec.exe /DTS
"C:\Program Files\Microsoft SQL Server\90\DTS\Packages\cycleprocess.dtsx" /SERVER "localhost" /DECRYPT "mypassword"
/MAXCONCURRENT
" -1 " /CHECKPOINTING OFF /REPORTING V
I still get an error which by the way is just showing a failure ( no real error message). I know the package is running under the SQl Agent which is defined as a local account of some sort. Can someone help this is the first time I have deployed to a job with a package..
Thanks
August 3, 2008 at 10:10 pm
Your step type on the SQL job should be SSIS Package. On the general tab, select your Package Source (being SQL or File System). Set/select the location of the package. When you select the Command Line tab it should prompt you to enter the password. Then when you look at the command line it should show you something like...
if your Package Source is SQL
/SQL "\MyPackageName" /SERVER MyServerName /MAXCONCURRENT "-1" /DECRYPT MyPassword
if your Package Source is File System
/FILE "MyDrive:\MyPath\MyPackageName" /SERVER MyServerName /MAXCONCURRENT "-1" /DECRYPT MyPassword
Kristen Hodges
b. http://bi-tch.blogspot.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply