SQLTeam.com | Weblogs | Forums

Losing Rows Importing from Excel to SQL Server using SSIS

sql2008

#1

I have developed a package on my workstation using SQL Server Integration Services 2008. It has an Excel 2007 Connection Manager as Source and a SQL Server 2012 database as OLEDB destination.

On my workstation 40133 rows from a xlsx spreadsheet are successfully copied to the SQL Server table in the Data Flow task both in Visual Studio designer and from the command line with DTexec.exe with an XML config file.

When I deploy to our DEV server and invoke the package using DTExec.exe and configure the package with an XML package configuration file, the package only loads 2 rows and does not generate any errors. Here's the section from the log:

Log:
     Name: OnPipelineRowsSent
     Message: Rows were provided to a data flow component as input. :  : 303 : Excel Source Output : 198 : Reference T_DestinationTable : 211 : OLE DB Destination Input : 2
     Start Time: 2016-04-14 10:17:46
     End Time: 2016-04-14 10:17:46
End Log

I've been looking at this for 2 days now, any suggestions on debugging or an explanation for the behaviour?