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

SSIS package droppping row on import Expand / Collapse
Author
Message
Posted Wednesday, June 19, 2013 10:19 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
I have a SSIS package which is meant to import 11331 rows into a database table.

In my execution results, its showing that all the rows are being processed:

The total number of data rows processed for file "C:\Data\Imports\supp*.txt" is 11331.

"Suppliers Table" wrote 11330 rows.


I have unchecked: Column names in the first data row. I can't understand why one row is being dropped.

Anyone have any ideas?

Post #1465282
Posted Wednesday, June 19, 2013 1:52 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:05 PM
Points: 287, Visits: 810
if you ever had the Column Names thing checked, and later unchecked it, I'd replace the component with a new one from the toolbox and make sure to not check that box. ever.

I have had situations where past status of a component "stuck" despite what its current status showed. Replacing the component has almost always solved the problem.
Post #1465363
Posted Thursday, June 20, 2013 7:07 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
Hi Thanks for your suggestion. I carried that out and I have even developed a new package, however I am still missing the one row on import.Very Strange.


Post #1465671
Posted Thursday, June 20, 2013 7:35 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 7:35 AM
Points: 2,817, Visits: 2,563
Is there a header row that you are counting that does not contain actual data?

Look at your target table and try to determine if it is the first or last row that is missing, or some row in between. First or last row missing is usually indicative of a problem with the record delimiter in the source file that you will have to code around. If all the data for the missing row crammed into the last column (or other column) on another row you will frequently find a column delimiter in the data. For example if your text file is comma delimited and there is a column with a number that has a thousands separator like 1,589.
Post #1465696
Posted Thursday, June 20, 2013 8:17 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
Totally lost!

My Header row delimeter is set to: Vertical bar |

Header rows to skip is 0.

When i go to the preview the import i can see the top row from my file. I think its some row in between.

The last show is contained in the table after the import.
Post #1465727
Posted Friday, June 21, 2013 12:22 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:39 AM
Points: 5,100, Visits: 11,900
You need to find out which row it is - possibly by exporting the imported table to Excel and then doing some sort of VLOOKUP comparison - and then work out what is different about the excluded row. I would expect it to be either an unexpected NULL value or an invalid data type.


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 #1466059
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse