SQL Server Home
SSIS -> Flat File Connection Manager -> Preview -> Data Rows To Skip should only be evaluated at design time.
5/16/2010 8:09:28 AM
User(s) can reproduce this bug
SSIS -> Flat File Connection Manager -> Preview -> Data Rows To Skip gets evaluated at design time and at runtime. This is confusing since this feature refers to ‘Preview’ of the data and is not expected to be evaluated at runtime. Unfortunately this causes issues in production since data is skipped based on this setting at runtime.
Two potential resolutions:
1) (Preferred) Change the behavior so that it is only evaluated at design time.
2) Clarify in the user interface that this feature is evaluated at both design time and runtime.
There are two separate features which are potentially used to skip rows. The first feature is the ‘Column names in the first data row’ is shown on the SSIS -> Flat File Connection Manager -> General tab. The second feature ‘Header rows to skip’ is on the same tab. It would seems that these features meet the need for runtime skip of the data.
SQL Server 2008 R2 - Enterprise Edition
Integration Services (DTS)
Windows 7 Ultimate
Operating System Language
Steps to Reproduce
Create an SSIS package that imports data from a flat file. Change the SSIS -> Flat File Connection Manager -> Preview -> Data Rows to something greater than one or zero. For example try 50 or 100!
When the SSIS package runs, it will not import the first X records (X = the number you just set) in the 'Steps to Reproduce'.
This is a 'Preview' and therefore it is not expected that this be evaluted at runtime.
to post a comment.
Please enter a comment.
on 12/15/2010 at 5:37 PM
this property is actually used in both design-time and runtime. It allows for skipping some data rows at the beginning of the file. It is different from the one on the general page as taht one defines how many header rows there is. Header row delimiters can be different than the actual row delimiters. It was just handy to put the property on that page so there is no need to switch pages if playing with sliding a preview window.
This change updates the description on the preview page to better explain the purpose of this property.
Bob Bojanic, SSIS Team
on 5/16/2010 at 11:39 AM
"It would seems that these features meet the need for runtime skip of the data."
no they don't. there are perfectly valid exec-time use cases for these properties. if you don't want them there, turn them off.
to post a workaround.
Please enter a workaround.
© 2013 Microsoft