June 11, 2013 at 4:37 am
Hello,
I am importing the following data into a table.
Country Acno ContCode SalesValue SalesDate
FRA S000 6030 151.64 2013-06-10
NLD S001 NULL 1315.53 2013-06-10
FRA S003 6027 29.39 2013-06-10
If i run the package manually in Visual Studio the fields/rows with Null import ok. However if i set a job to run from SQL Server Agent it doesnt import the Null row.
In the flat file source editor I have selected Retain Null values from the source as null values in the data flow.
In the OLE DB Destination Editor I have selected 'Keep Nulls'.
Anyone have any ideas?
Thanks.
June 11, 2013 at 5:07 am
How does the NULL appear in the flat file? Presumably one of
,"",
,,
,NULL,
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
June 11, 2013 at 5:56 am
Hello,
Appears as:
NLD|Y7744||1315.53|10/06/2013
June 12, 2013 at 5:31 am
Anyone any idea?
June 18, 2013 at 4:52 am
Fixed!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply