Getting SSIS error while passing 01/01/2012 date in ssis variable of datetime data type
Why Getting SSIS error while passing 01/01/2012 date in ssis variable of datetime data type?
January 3rd, 2013 1:55pm
As the data type is datetime it is looking for datetime value. For eg 01/01/2012 10:12:23 etc
If you want to use 01/01/2012 only, then convert the variable data type to string and proceed.
Thanks,hsbal
Free Windows Admin Tool Kit Click here and download it now
January 3rd, 2013 2:08pm
Out of curiosity, what happens if you pass it a value of 2012/01/01 ?Chuck Pedretti | Magenic North Region | magenic.com
January 3rd, 2013 2:30pm