asked
SSIS Package fails to execute using DTEXEC
I am executing a SSIS package deployed to file system using DTEXEC but it fails finish ,it smoothly runs in BIDS. The log doesn't show any errors but package never completes when running using DTEXEC. Background:- -I have a child package with the parent which connects to ORACLE to load data. -Project has a XML configuration file. -Connection managers properties are set using the config file - Last Few Lines From Log :- OnInformation,,,EXTR,{E520C1ED-58F8-41C0-A0A2-D139CCC5817E},,12/22/2013 12:42:18 PM,12/22/2013 12:42:18 PM,1074016265,0x,Cleanup phase is beginning. User:OnInformation,,,Load Data into TBL_PR_HS,{F924E0C5-5579-4A43-A8E6-7D0B5B559D9C},,12/22/2013 12:42:18 PM,12/22/2013 12:42:18 PM,1074016266,0x,Validation phase is beginning. User:OnInformation,,,Sequence Container phd,{F4E3A88C-B94D-4F8C-8CB0-24D54CCCE35A},,12/22/2013 12:42:18 PM,12/22/2013 12:42:18 PM,1074016266,0x,Validation phase is beginning. User:OnInformation,,,ldp,{413EAB39-5A63-4A4E-9CCF-73E13A09898C},,12/22/2013 12:42:18 PM,12/22/2013 12:42:18 PM,1074016266,0x,Validation phase is beginning. OnInformation,,,Execute ldp package,{7f9c1651-fab6-4f41-8734-2c54c43c50f4},,12/22/2013 12:42:18 PM,12/22/2013 12:42:18 PM,1074016266,0x,Validation phase is beginning. OnInformation,,,extr,{E520C1ED-58F8-41C0-A0A2-D139CCC5817E},,12/22/2013 12:42:18 PM,12/22/2013 12:42:18 PM,1074016266,0x,Validation phase is beginning.
Are you using the correct version of DTExec? There are 32 and 64-bit on a 64-bit OS. Double check you are using the correct one? > **dtexec Utility (SSIS Tool)** >
http://technet.microsoft.com/en-us/library/ms162810(v=sql.105).aspx
Thank you for your reply.I have deployed the package using 32 bit dtinstall utility.I will make sure its using 32 bit dtexec and try. Thanks again.
I have a SSIS package that goes out to a sql database reads a table, creates an excel spreadsheet and emails the spreadsheet out. Pretty straight forward nothing fancy. My problem is that it works fine in when running in visual studio debug, it also works fine if I run it in 32bit from the dtexecui utility, however it fails when running in dtexec. Note, I do have Run64BitRuntime set to False from the miscellaneous properties pages screen and I have EncryptSensitiveWithUserKey set for the protection level in the properties window. This is how I am running the package from a bat file - "C:Program Files (x86)Microsoft SQL Server100DTSBinndtexec.exe" /f "\servernamefolder pathpackage name.dtsx" > "C:Scheduler_JobsLogsSSIS_log_TODAY%.txt" When I look at the log it shows it running in 32bit mode however the job fails Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 11:22:32 AM Error: 2014-09-05 11:22:39.08 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Any ideas on how to get this to run from my .bat file? I need to execute this bat file from the native Windows scheduler. Thanks in advance.
16 People are following this question.
