Multiple Flat Files Connection Manager Editor (Preview Page)

Use the Preview page of the Multiple Flat Files ConnectionManager Editor dialog box to view the contents of the first selected source file divided into columns as you have defined them.

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

Options

  • Connection manager name
    Provide a unique name for the Multiple Flat Files connection in the workflow. The name provided will be displayed within the Connection Managers area of 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 first selected flat file, divided into columns and rows by using the options selected.

See Also

Reference

Multiple Flat Files Connection Manager Editor (General Page)
Multiple Flat Files Connection Manager Editor (Columns Page)
Multiple Flat Files Connection Manager Editor (Advanced Page)

Other Resources

Integration Services Error and Message Reference

Help and Information

Getting SQL Server 2005 Assistance