file import

Last Post 05 Jul 2008 09:49 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

01 Jul 2008 11:01 AM
Can some one help me with this?

i have to create DTS to import file on daily basis

The trick is application that exports the file creates multiple folders every day per day
so there can be 5 folders for today, applocation did five exports today
so tomorrow morning i want to import 5 txt files (one from each folder)
and format is like this:


how do i do this?


New Member
New Member

05 Jul 2008 09:49 AM
You can use

EXEC master.sys.xp_dirtree 'f:\data\'

to chartup the directory/subdirectory structure.

Kalman Toth SQL Server Training

Acceptable Use Policy