Is there any way of creating a DTS script in a text editor and then importing it into DTS?? For example, I am importing from multiple Fixed Width files, each having 100+ columns in each table/file. I have the field width information in a separate table and would rather not have to retype in the field spec information if possible. In the past, I could use bcp and create a format file in a matter of seconds. Can I do the same for DTS scripts??
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DTS Scripts
- Thread starter goman
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question