Post reply

import/export wizard... how do you do that in SQL 2005 ?

  • May 16, 2006 at 1:19 pm

    #168297

     I believe I have all of the necessary components installed for SQL 2005. I cannot for the life of me figure out what I am missing. I want to do a simple export data/import data within SQL Server like the old DTS import/export wizard but i cannot figure out how to do it.. What I look up in BOL I cannot find in Management Studio ?  HELP ...............

  • May 16, 2006 at 1:36 pm

    #638260

    In SQL 2005 it is is exactly the same as in SQL Server 2000: right-click on the database, All Tasks ->Import Data (or Export Data) It brings up the wizard. You will have to use Visual Studio from the Start menu and select Integration Services project if you would like more complex things

    Regards,Yelena Varsha

  • May 16, 2006 at 1:38 pm

    #638262

    That is what I thought because I remember doing that in my SQL 2005 DBA admin class. The option though is not there and I truely think I installed the correct components. Do you know what components I need to install to add that ? 

  • May 16, 2006 at 1:45 pm

    #638264

    I am an idiot. I found it... right click on database, then tasks... it is in there !!!!   Thanks for making me look again for the 5th time !

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

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