DTS Global Variable - How pass a datetime, compliant to Iso 8601, as global variable? -
11-12-2009
, 05:22 AM
Hi all,
I have a global variable G1 of string type, and i would to set it as
datetime Iso 8601 compliant ( yyyy-MM-ddT00:00:00 ).
When i try to pass this global variable to a stored procedure in an
"Execute SQL Task", which has only a input parameter (of datetime type), i
receive an error of "invalid char for the cast"...
I have tried to do the same thing in a simple sql query and it works fine.
I don't understand why it doesn't work.
Any ideas?
Thanks
Niki |