This might be common knowledge but I spent a good 30 minutes trying to figure out why my Execute SQL task wasn't inserting a datetime variable value in to my database. Generally when working with SQL I know that the datetime data type can convert to DBTimestamp with no issue but for some reason it keeps failing whenever I set the data type in the parameter mapping settings of the SQL task to DBTimestamp... Setting it to varchar or long would make the task succeed however it would have inserted a wrong date and time.
The fix? Simple.... set the data type to Date instead of DBTimestamp! DOH!
/cry
No comments:
Post a Comment