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
 Transact-SQL (2000)
 How to DTS a .DAT extension file in the database?

Author  Topic 

zeeshan13
Constraint Violating Yak Guru

347 Posts

Posted - 2007-10-19 : 15:54:45
Hi all,

I have SQL Server 2000 datbase. I want to DTS a .DAT extension.
How can I do that?
I cannot load it as text file if I try to the format looks crazy.
Can some tell me how to DTS a .DAT extension file in the database?

Looking for a quick answere.

Thanks a million in advance.

Zeeshan

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-20 : 01:34:09
You have to find out what kind of file it is then load it with proper driver.
Go to Top of Page
   

- Advertisement -