DTSExecSQLTask

This Microsoft® Visual Basic® sample demonstrates how to execute an SQL statement while running a Data Transformation Services (DTS) package.

This sample:

• Creates a package.
  
  
• Opens a connection to the pubs2 database.
  
  
• Creates a custom task, which executes an SQL statement to INSERT a record into the Sales table.

Default Location

C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\Dtstasks\DTSExecSQLTask

Running the Sample

1. Create the pubs2 database that is a copy of the pubs database on the local server.
   
   
2. Open the DTSExecuteSQLTask.vbp project.
   
   
3. Run the application.

See Also

DTS Programming Samples