November 27, 2001 at 1:39 pm
I am wondering if there is a way to set up an automated process to import a coma delineated text field into a table...either appending existing data or overwriting? Any help would be appreciated.
Thanks,
Scot Huntsberry
Redmagnet
662.849.2992
Scot Huntsberry
Redmagnet
shuntsberry@redmagnet.com
662.849.2992
November 27, 2001 at 2:07 pm
Yes, you could use DTS, Data Transformation Services, to take care of that for you. Once you get the DTS package set up, it is easy to schedule it for periodic runs.
Books On Line has some pretty good coverage of the functionality within DTS. Let me know if you want more specific information.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 27, 2001 at 2:23 pm
You could also use bulk insert / bcp from a scheduled SP.
Cursors never.
DTS - only when needed and never to control.
November 27, 2001 at 4:53 pm
If you need to worry about updates, you probably need to insert into a temp table and then move across. With DTS, you could script this, but it would be rather complex using the data driven query task.
Steve Jones
November 27, 2001 at 7:20 pm
Whatever method you use I wouldn't consider trying to merge directly into a production table. Treat the data import as a separate task from the merge. Better to import into it's own database.
Then you can change the import method without affecting the rest of the processing.
Cursors never.
DTS - only when needed and never to control.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply