Posted by oshanahan on 09/08/05 21:42

"" wrote:
> Have you looked at third party ETL tools and DTS? In
> particular,
> Google Sunopsis if you have to bring in data from several
> sources.

Thanks for your response.
I�m using DTS to populate a staging table with raw streams of data (a
lot of it) from one source. I thought about imbedding the SQL
somewhere in the VB script that DTS uses. Our resident DTS man said
he didn�t think that was possible here.
The problem essentially is that a large field on the staging table
must be substringed to populate other tables, which have no
relationship to the staging table. The substringing is where the
performance drag is, but there is no way around that. I�m looking to
somehow shave a little time on each populate transaction to help cut
down processing.

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/General-Discussions-Inserting-large-amounts-data-ftopict254055.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=878479

• Next in forum: Re: bcp utf8 file
• Prev in forum: Re: Extracting Time from the SQL DateTime field.
• Thread view: Re: Re: Inserting large amounts of data

[Reply to this message]