May 8, 2009 at 2:13 pm
In SQL Server 2005, I'm trying to import a CSV file. According to BOL I should be able to right click on the table and go to Tasks then Import data (just like in 2000). When I right click on the table, I only get the options for New Table, Filter, Reports, and Refresh. Is there something I am doing wrong? Was there an issue with the installation?
Thanks
May 8, 2009 at 5:14 pm
Task option is available at Database level, so if you right click on the database you will see task and then you can go through the wizard to load data to a specific table.
Database -> Task -> Import Data - > SQL Sever Import and Export Wizard
HTH
~Mukti
May 11, 2009 at 7:38 am
Thank you for the help.
I had originally tried it at server, database, and table level but the tasks options would not show up. I went back through the control panel and tried to reinstall the SSIS, rebooted the server and now it is showing up for me. I'm not sure why it would not show up before because it was showing up as an installed component.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply