the file format for it to work. Really, this situation is almost
impossible unless you standardize your file format or at least narrow it
down to where the file is in one of a few selected formats that you can
easily test to determine the right way to process.
_____________________
Eric A. Laney
_____________________
Last night I stayed up late playing poker with Tarot cards. I got a full
house and four people died. - Steven Wright
"Nick de Voil" <[EMAIL PROTECTED]>
04/27/2004 08:32 AM
Please respond to sql
To: SQL <[EMAIL PROTECTED]>
cc:
Subject: Re: Importing large text files
> I've been searching around and DTS/Bulk Import seem to be the key here.
But I need to send files to be imported on the fly, i.e. the file will
constantly change. All the DTS stuff I can find involves setting up the
package for a specific file then invoking this.
Have you looked at the bcp utility? Might be more flexible in this
particular case.
Nick
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
