SSIS -> Flat File Connection Manager -> Preview -> Data Rows To Skip should only be evaluated at design time. - by WickedProgrammer

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


4
1
Sign in
to vote
ID 559451 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 5/16/2010 8:09:28 AM
Access Restriction Public

Description

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.

Sign in to post a comment.
Posted by Microsoft on 12/15/2010 at 5:37 PM
Hello,

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.

Best regards,
Bob Bojanic, SSIS Team
Posted by Jamie Thomson 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.