Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS package droppping row on import


SSIS package droppping row on import

Author
Message
dbman
dbman
SSC-Enthusiastic
SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)

Group: General Forum Members
Points: 127 Visits: 1537
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?
herladygeekedness
herladygeekedness
Old Hand
Old Hand (318 reputation)Old Hand (318 reputation)Old Hand (318 reputation)Old Hand (318 reputation)Old Hand (318 reputation)Old Hand (318 reputation)Old Hand (318 reputation)Old Hand (318 reputation)

Group: General Forum Members
Points: 318 Visits: 813
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.
dbman
dbman
SSC-Enthusiastic
SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)

Group: General Forum Members
Points: 127 Visits: 1537
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.
Daniel Bowlin
Daniel Bowlin
SSCrazy
SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)

Group: General Forum Members
Points: 2954 Visits: 2629
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.
dbman
dbman
SSC-Enthusiastic
SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)

Group: General Forum Members
Points: 127 Visits: 1537
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.
Phil Parkin
Phil Parkin
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8414 Visits: 19517
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.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search