Bandwidth Monitor
SQLDTS.comSQLIS.comSQLIS Wiki
Building a Package in the DTS Designer
By Allan Mitchell
Version 7.0/2000
Level Beginner

Figure 1.10 Transform Path Defined.

Tform Def

Figure 1.10 shows that we now have a transformation defined between the text file and the SQl Server connection. You can tell the direction of the dataflow by the way the arrow is pointing. Double click on the black line.

Figure 1.11 Set Source.

Set Source

Here we need to set what we want to transfer to SQL Server. Normally we would be able to move a subset of the data by defining the Source as an SQL statement. The Text File provider does not allow us to do this so we have to make do with taking all the data across. The only option on this screen that we are able to choose is to preview the data.

Press Next