|
Posted by JCC on 10/31/06 15:42
"Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message
news:SYG1h.947$m54.525@newssvr14.news.prodigy.com...
>> but surely there's a way to get DTS to read from a format file so I don't
>> have to click 200 times (with all the ensuing errors I could make).
>
> Have you looked into the DTS Bulk Insert task or Transact-SQL BULK INSERT?
> Both can read a standard BCP format file.
>
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
I have looked into this - but as I said, I don't want to mess around with
bcp if I can avoid it - I had no end of problems with bcp a while back.
It looks like I can't avoid it though!
Cheers
Rob
Navigation:
[Reply to this message]
|