Integer in DTSRUN

• Adam Campbell

  SSC Eights!

  Points: 982

  More actions

  October 13, 2005 at 8:00 am

  #169177

  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

• mike gercevich

  SSCrazy

  Points: 2961

  More actions

  October 14, 2005 at 6:15 am

  #597319

  Change both "22" type values with a "3" for a type Integer.

  -Mike Gercevich