thxmike


OK, I came across a problem with the SS Integration Services Designer and I was wondering if anyone else can recreate it.
I create a bulk insert task that inserts from a tab delimited file. In the properties of the bulk insert task I set the last row = 1 (since I only want one row for this task)
When I execute the task it appears to the ignore the last row switch for the bulk insert and attempts to bulk insert all the rows.
This can be verified by looking at the execution results and seeing what statement it tried to run.
Notice in the statement below the bulk insert statement does not have a LastRow set even though I set it to 1 in the Tasks properties.
Progress: Preparing the following SQL statement: BULK INSERT [Sandbox].[dbo].[StatementImportHeader] FROM 'C:\Users\mrivera\Documents\AMLI.BILL.05302007.01.tsv' WITH(BATCHSIZE=1,CODEPAGE='RAW',DATAFILETYPE='char',FIELDTERMINATOR='\t',ROWTERMINATOR='\n') - 100 percent complete
SSIS 2005 with SP2
Any assistance would be appreciated.