Bandwidth Monitor
SQLDTS.comSQLIS.comSQLIS Wiki
Importing A Text File Using The DTS Wizard
By Allan Mitchell
Version 7.0/2000
Level Beginner

Figure 1.10 Customise The Transformation

Customise The Transformation

Although we are not going to be doing anything with this screen we thought we'd stop by and have a look. We have two choices when moving the data.

1. Copy the source columns directly to the destination colums

2. Transform information as it is copied to the destination

The first option simply means that we will pick up whatever is in the source and transfer it straight to the destination. The second option is where we start to get a little more clever and we can begin to validate the data and also reformat it into something suitable Like we said we're not doing anything on this page so when you're ready Click OK