I'm trying to execute an SSIS package from an stored procedure, using xp_cmdshell.
When I execute the package, hard coding the value on the variable, I get rows inserted to my destination tables, which indicates my package pulled the correct data based on the TransactionID parameter.
When I execute the package from the stored procedure, the package executes without issues, but I get no rows inserted into my destination tables, which leads me to think it is a data type issue, between the package and the variables I'm using within the
The variable TransactionID on the SSIS package, is a string data type, therefore I'm passing it as a varchar from the stored procedure. Am I doing this correctly? Maybe I'm missing something, can you guys see anything wrong?
Also, I tried login into the server and executing these 2 commands on the cmd prompt:
One with "" quotes between the TransactionID value:
dtexec /FILE "D:\SSISPackages\MyOrderCheckProcess\MyOrderCheck_RenewalOrder.dtsx" /CONFIGFILE "D:\SSISPackages\MyOrderCheckProcess\MyOrderCheckProcess_Config.dtsConfig" /CHECKPOINTING OFF /REPORTING EWCDI /SET \Package.Variables[User::TransactionID].Properties[Value];"470219"
And also one without quotes between the TransactionID value:
dtexec /FILE "D:\SSISPackages\MyOrderCheckProcess\MyOrde
View Complete Post