Share via


SQL Destination Editor (Connection Manager Page)

Use the Connection Manager page of the SQL Destination Editor dialog box to specify data source information, and to preview the results. The SQL Server destination loads data into tables or views in a Microsoft SQL Server 2005 database.

To learn more about the SQL Server destination, see SQL Server Destination.

Options

  • OLE DB connection manager
    Select an existing connection from the list, or create a new connection by clicking New.
  • New
    Create a new connection by using the Configure OLE DB Connection Manager dialog box.
  • Use a table or view
    Select an existing table or view from the list, or create a new connection by clicking New.
  • New
    Create a new table by using the Create Table dialog box.
  • Preview
    Preview results by using the Preview Query Results dialog box. Preview can display up to 200 rows.

See Also

Reference

SQL Destination Editor (Mappings Page)
SQL Destination Editor (Advanced Page)

Other Resources

Integration Services Error and Message Reference
How to: Bulk Load Data Using the SQL Server Destination

Help and Information

Getting SQL Server 2005 Assistance