Post reply

Scripting In DTS

  • June 15, 2003 at 5:26 pm

    #151857

    I'm new to SQL. I'm trying to find a way to import a file (text) using VB Script, and or FileSystemObject. I'm not sure where I place the script and how to get it called/or started. The file I'm importing has many different record types in it. Each line is started with a 0001, 0002, 0003, ect. I would like to read a line and send the row to tbl0001, tbl0002, tbl0003, ect. Can someone please point me in the rigth direct?

    Thanks,

    rwiethorn

  • June 17, 2003 at 6:56 am

    #461725

    I would use the vbscript task in dts to format your source file into as many different files as you have tables. Then do a simple transform task into your tables.

  • June 17, 2003 at 7:41 am

    #461740

    Hi,

    You can use DTS package to perform this task.

    Here is an example.

    http://www.sqldts.com/default.aspx?6,107,276,7,1

    JFB

  • June 18, 2003 at 11:21 am

    #461963

    Everybody thanks for your replies, I'll give it a try.

    Thanks

    rwiethorn

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply