Re: adVarWChar slower than adVarChar

N. Scheller wrote:
Hello Bob,
thanks for your comment. Sure we can build a DTS package for each
file to be imported for each of our customers.

Why? You can't think of a way to use a single DTS package for all
imports? I (or somebody on one of the sqlserver newsgroups) might be
able to help if provided with some details ....

And we surely would
find a similar technology to do this in Oracle. But this would have
to be adopted for each customer and for each kind of import file, so
we are quiet convinced that the import program we wrote is the best
and flexible way (since we have to check if a record already exists
and update it or have to insert the data if the record is new) .


The same thing could be done with a DTS package. Think "staging table"
and "stored procedure to process the imported data".


So back to my problem: is there any way to speed up the import with
adVarWChar parameters?

None that I know of. Sorry.
Hopefully somebody else will be able to jump in and provide the answer.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: dts packages take a long time to run
    ... > You can use profiler to monitor what is going on - looking ... >>I'm running a DTS package that imports data from various Excel ... When all rows have been imported from a particular worksheet ...
    (microsoft.public.sqlserver.connect)
  • Re: dts packages take a long time to run
    ... You can use profiler to monitor what is going on - looking ... >I'm running a DTS package that imports data from various Excel spreadsheets ... When all rows have been imported from a particular worksheet ...
    (microsoft.public.sqlserver.connect)
  • Text file import
    ... I have a DTS package which imports thousands of text files into a database. ... With the 'First Row' option on the ...
    (microsoft.public.sqlserver.dts)
  • dts packages take a long time to run
    ... I'm running a DTS package that imports data from various Excel spreadsheets ... When all rows have been imported from a particular worksheet ...
    (microsoft.public.sqlserver.connect)