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: Saturday, September 6, 2014 1:45 PM
Points: 112, Visits: 1,481
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:52 PM
Points: 5,317, Visits: 12,353
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.

It is better to keep your mouth shut and appear stupid than to open it and remove all doubt. (Mark Twain)
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: Saturday, September 6, 2014 1:45 PM
Points: 112, Visits: 1,481
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: Saturday, September 6, 2014 1:45 PM
Points: 112, Visits: 1,481
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: Saturday, September 6, 2014 1:45 PM
Points: 112, Visits: 1,481
Fixed!
Post #1464562
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse