CODEWITHSUNDEEP
sqlsql-serverssis
pallox
pallox

Reputation: 127

Possible Reasons for SSIS Package to Process Every Second Row of Dataset

Firstly sorry that I can't get really specific, as SSIS packages may get very complicated and are awful to describe.

My sceanrio requires a CSV to be processed after validation against other tables and stored into several tables in a SQL database. My result is that only every second row of my CSV gets processed on the target system. The test and dev environments (which are equivalent set up) behave as expected and store all rows.

What are possible reasons for my target system to behave different? What are the most possible mistakes e.g. oversee/oversight?

Upvotes: 1

Views: 61

Answers (1)

Ajan Balakumaran
Ajan Balakumaran

Reputation: 1649

In the flat file connection manager check whether the header row to skip is zero.

enter image description here

Upvotes: 1

Related Questions