ranjithjk
asked on
Visual Basic & DTS
I have got a table called MSQ_TSR. i have got a text file from which i read the data using VB. Now i need to insert the records into the table MSQ_TSR using DTS in SQL Server 7.0 or SQL Server 2000. CAn anyone help me in doing this.I need to run the DTS from Visual Basic. The text file is too big so i read line by line and split them (some records) and update the records into the table using DTS. Also i need to convert the data's in the Table into flat file. how to do these things. Reply me ASAP.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi ranjithjk,
This old question (QID 20566336) needs to be finalized -- accept an answer, split points, or get a refund. Please see http://www.cityofangels.com/Experts/Closing.htm for information and options.
This old question (QID 20566336) needs to be finalized -- accept an answer, split points, or get a refund. Please see http://www.cityofangels.com/Experts/Closing.htm for information and options.
ASKER