Re: Slow import problem




"Ingo" <ir2000@xxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:44968440$1@xxxxxxxxxxxxxxxxxxxxxxxxx

"Vitali Kalinin" <vitkalinin@xxxxxxxxx> wrote:

Take a look at "in" statment in Access SQL help.

1. I forgot to mention that I am using Microsoft SQL Server 2000
Yes that makes a big difference here.
2. I dont see where an IN-Statememt would be useful to solve my problem
Still possible to apply. Since you are using MS Jet you can reference
external tables using "IN" statement on Access SQL (don't mix that with "IN"
of ANSI SQL). But in this specific situation I would recommend to go with
DTS or BCP.


.



Relevant Pages

  • Re: CSV File to database question
    ... BCP ... Building a Package in the DTS Designer ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: On going Probs with executing a DTS from a VB exe
    ... www.SQLDTS.com - The site for all your DTS needs. ... as the vb exe fails on an error from the ... >> The package as a whole does not execute? ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: Dynamic column mapping
    ... Allan Mitchell MCSE,MCDBA, ... > I have a DTS that reads from multiple text files importing them into a SQL ... > DTS to use the default mapping it uses when I enter the Transformation ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: cant assign filename in DTS
    ... Have you set "Close Connection On Completion" in the workflow properties? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... > In an active X Script, opens a message box to accept a file path and name. ...
    (microsoft.public.sqlserver.dts)
  • Re: help assigning value to global variable
    ... www.SQLDTS.com - The site for all your DTS needs. ... > (sql task in the package) ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)