I am executing a DTS package with DTSRUN. It has Global Variables that are an Int type. In the DTSRUN command I am passing a month number for one variable and a year number for another. The problem is that I am getting the following error for the SQL Tasks in the package......Invalid character value for cast specification.
I am passing a valid number. Here is the syntax of the variable portion of the dtsrun command. Let me know if anyone has any ideas of what is wrong.
/A "month":"22"=5 /A "year":"22"=2005
I have also tried
/A "month":"22"="5" /A "year":"22"="2005"
both failed with the same error
Please help, Adam