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
 Import/Export (DTS) and Replication (2000)
 Import Data Help

Author  Topic 

pankaj.pareek@sparrowi.co
Starting Member

26 Posts

Posted - 2007-03-22 : 01:32:06
Hi,

I need a help to automatically import the data from txt (, seprated) file from a specific folder at regular interval into the sqlserver 2000 database table.

Is this possiable?

Yes! Please give me a detailed procedure to do this.


Thanks

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-22 : 01:37:22
refer to Books OnLine on DTS. And also http://www.sqldts.com/


KH

Go to Top of Page

pravin14u
Posting Yak Master

246 Posts

Posted - 2007-03-22 : 08:26:32
use DTS (Import) + Jobs(Execute Import Periodically)
Go to Top of Page
   

- Advertisement -