Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 DTS Query (I think help for may guys)

Author  Topic 

kamalkishore_in
Yak Posting Veteran

76 Posts

Posted - 2001-09-27 : 23:15:20
Hi Guys,
I am having a ASCII txt file with the following format..

123,"abc",456,"def"
12323,"dfabc",456,"dsdfef"

I wants to import it into my sql table...
I found that DTS has a option of FormatFile.. But it couldnt help me much...

So I tried with DTS....
I made a DTS file for that TXT file and called from VB 6.

It is working fine....


I wants to know that.. can I see the query that DTS wizard is generating to import txt file...

any help is invited....
Thanks

   

- Advertisement -