<div>
I am running EXEC xp_cmdshell'dtexec /FILE &quot;\\Server\SSIS\package1.dt<wbr />sx&quot;'<br />
however I get the following error -<br />
<br />
&nbsp; &nbsp;Description: Failed to decrypt protected XML node &quot;PassWord&quot; with error 0x8009000B &quot;Key not valid for use in specified state.&quot;. You may not be authorized to access this information. This error occurs when there is a cryptographic error. &nbsp;<br />
<br />
This is a SQL 64 bit environment. 
</div>


<div>
<div class="content wysiwyg-content">
I recently upgraded our DTS packages to use SSIS I used to call the DTS packages like this <br />
EXEC master..xp_cmdshell 'DTSRun /S Server /U USER /P PASSWORD /N PACKAGE /A gv_destDB:8=DestinationDB'<wbr /><br />
<br />
I have the packages on the &nbsp;file system (E:\SSIS\PACKAGES.DTSX) currently how would I do the same thing i did previously but using DTSEXEC and the File system? I have used these packages to import data from some flat files for sometime<br />

</div>
</div>


I recently upgraded our DTS packages to use SSIS I used to call the DTS packages like this 
EXEC master..xp_cmdshell 'DTSRun /S Server /U USER /P PASSWORD /N PACKAGE /A gv_destDB:8=DestinationDB'

I have the packages on the  file system (E:\SSIS\PACKAGES.DTSX) currently how would I do the same thing i did previously but using DTSEXEC and the File system? I have used these packages to import data from some flat files for sometime


I am running EXEC xp_cmdshell&#39;dtexec /FILE &quot;\\Server\SSIS\package1.dtsx&quot;&#39;
however I get the following error -

   Description: Failed to decrypt protected XML node &quot;PassWord&quot; with error 0x8009000B &quot;Key not valid for use in specified state.&quot;. You may not be authorized to access this information. This error occurs when there is a cryptographic error.  

This is a SQL 64 bit environment. 

Calling DTSX from File system

I recently upgraded our DTS packages to use SSIS I used to call the DTS packages like this 
EXEC master..xp_cmdshell &#39;DTSRun /S Server /U USER /P PASSWORD /N PACKAGE /A gv_destDB:8=DestinationDB&#39;

I have the packages on the  file system (E:\SSIS\PACKAGES.DTSX) currently how would I do the same thing i did previously but using DTSEXEC and the File system? I have used these packages to import data from some flat files for sometime


Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.