TechNet
Export (0) Print
Expand All

Flat File Connection Manager Editor (Preview Page)

 

Applies To: SQL Server 2016

Use the Preview node of the Flat File Connection Manager Editor dialog box to view the contents of the source file in a tabular format.

To learn more about the Flat File connection manager, see Flat File Connection Manager.

Connection manager name
Provide a unique name for the Flat File connection in the workflow. The name provided will be displayed within SSIS Designer.

Description
Describe the connection. As a best practice, describe the connection in terms of its purpose, to make packages self-documenting and easier to maintain.

Data rows to skip
Specify how many rows to skip at the beginning of the flat file.

Refresh
View the effect of changing the number of rows to skip by clicking Refresh. This button only becomes visible after you have changed other connection options.

Preview rows
View sample data in the flat file, divided into columns and rows according to the options you have selected.

Integration Services Error and Message Reference
Flat File Connection Manager Editor (General Page)
Flat File Connection Manager Editor (Columns Page)
Flat File Connection Manager Editor (Advanced Page)

Community Additions

ADD
Show:
© 2016 Microsoft