Sent: Thursday, October 04, 2001 11:54 PM
Subject: DTS fails using Transactions
I have to transfer the data from SQL Server 7.0 to TextQuote:> Hai
VB 6.0 programatically. I need your help because I can't
be able to complete
the task1 job. The DTS Example which is given in the SQL
Help will work only
From SQL to SQL but I can't be able to complete my
first task. Basically I am unaware of the DSN settings for
file. So please help me in the strange situation. If you
possible send the
code for transfering the SQL data into Text in VB Programs
and how to
set the ODBC settings in the control panel.
Quote:> Any ideas?