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

Status
Not open for further replies.

goman

Programmer
Feb 18, 2005
2
ZA
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??
 
Not that I have come across.

The DTS script files that are generated by DTS are not readable in a text editor.

If you do find a tool that reads the DTS script files could you post it.

JB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top