Post reply

Copy Columns Task

  • January 31, 2003 at 11:37 am

    #105993

    I am trying to import data from a .CSV file into a table. However, it takes forever. I also set up my task so that the transformations share one transformation object when copying the columns. Is there a specific option or way that I could speed this up?

    Thanks!

  • February 2, 2003 at 2:42 pm

    #447774

    How many rows are you importing? How long is it taking? What version of SQL are you using?

    What other methods of importing have you tried?

    Thanks

    Phill Carter

    --------------------
    Colt 45 - the original point and click interface

  • February 3, 2003 at 7:29 am

    #447809

    I'm trying to import approx 205,000 rows and I'm using SQL 2000. I didn't try any other import method

  • February 3, 2003 at 2:30 pm

    #447898

    Try doing using the BULK INSERT command in Query Analyzer and see how long it takes.

    What sort of data are you importing?

    Thanks

    Phill Carter

    --------------------
    Colt 45 - the original point and click interface

  • February 3, 2003 at 3:32 pm

    #447912

    Can I use Bulk Insert when I'm importing the CSV file into a table that has an Identity column? Currently, I just copy the columns and ignore the identity column.

    The data I am importing is just general customer and order information as varchar datatype.

    Thanks.

  • February 3, 2003 at 3:42 pm

    #447916

    Do a Bilk Insert into a staging table, then execute a regular T-SQL insert to insert the records into the final table.

    Thanks

    Phill Carter

    --------------------
    Colt 45 - the original point and click interface

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply