September 20, 2010 at 11:38 am
Hi all ,
I have created an SSIS package which inserts date from csv file in a column having datatype
date .. Now when i execute this package in my environment , the empty value in .csv is inserted as null . But when i execute this package in server environment , the empty values are inserted as default date '1900-01-01'..
Can anybody tell what could be the reason for this indifferent behaviour ?
Thanks in advance
ASPG
September 21, 2010 at 4:39 am
What kind of transformation are you using...
Raunak J
September 21, 2010 at 7:40 am
Are you sure your environment and the server environment are 100% the same?
It seems to me that there is a default constraint on the table at the server.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply