Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to Import Null rows Expand / Collapse
Author
Message
Posted Tuesday, June 11, 2013 4:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 4:59 PM
Points: 112, Visits: 1,478
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.


Post #1461986
Posted Tuesday, June 11, 2013 5:07 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:02 AM
Points: 4,983, Visits: 11,678
How does the NULL appear in the flat file? Presumably one of

,"",
,,
,NULL,




Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1462000
Posted Tuesday, June 11, 2013 5:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 4:59 PM
Points: 112, Visits: 1,478
Hello,


Appears as:

NLD|Y7744||1315.53|10/06/2013

Post #1462015
Posted Wednesday, June 12, 2013 5:31 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 4:59 PM
Points: 112, Visits: 1,478
Anyone any idea?
Post #1462566
Posted Tuesday, June 18, 2013 4:52 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 4:59 PM
Points: 112, Visits: 1,478
Fixed!
Post #1464562
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse