Post reply

Import Export Wizard Performance

  • June 3, 2013 at 12:58 am

    #278437

    I am having access to sql server 2005.

    Question : I need to load a text file data to the sql server table.Which of the following options will be better?

    1.Use BIDS,Import & Export Wizard,use source as text file and load it into sql server table.

    2. Use BIDS,Import & Export Wizard,use source as XML file and load it into sql server table.

    3. Use SSMS,Import & Export Wizard,use source as text file and load it into sql server table.

    4. Use SSMS,Import & Export Wizard,use source as XML file and load it into sql server table.

  • June 3, 2013 at 1:05 am

    #1620403

    in my experice i would rather not use any wizards (they usually tend to be slow), rather go the route of BCP.

    http://msdn.microsoft.com/en-us/library/aa337544.aspx

  • June 3, 2013 at 1:18 am

    #1620405

    ya..thanks for your reply..

    But i want to know in that options which one is better ?

  • June 3, 2013 at 1:42 am

    #1620412

    well personally if i have a text file which does not change in format, i use SSMS and save the wizard.

    remeber there is no better method to another, it what you prefer in your enviroment 🙂

    hope that helps?

Viewing 4 posts - 1 through 3 (of 3 total)

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