May 20, 2010 at 12:43 pm
I am importing an excel file into sqlserver 2005 using SSIS.
I have selected Excel Source from DataFlowSources and selected an excel file that I am going to import into new sql table.
In DataFlowDestinations I have selected Sql Server Destination and selected server name and database name that I am going to import the data from excel sheet.Here I wanted to have an option to import this data into a new table instead of existing tables. In the connection manager I am able to see servername.dbname under OLEDB Connection Manager. But under use a table or view drop down I am able to select the existing tables but not able to enter a new table name. The new button is disabled. How can I enter new table name here?
Thanks.
May 20, 2010 at 12:52 pm
Use a OLE DB destination instead and follow the same steps that you did for SQL Server Destination
May 20, 2010 at 1:07 pm
I am not able to enter new table name even though I selected OLEDB Destination instead of SqlServer Destination.
In this case I dont see the New button at all next to table selection.
Thanks.
May 20, 2010 at 1:15 pm
Once you select the server and the Data Access mode as Table/View OR Table/view fastload.. Beside the Name of the table or view you should see a NEW button..A click on it will give you the Create statement for the new table and you can Also modify the structure, if needed...
If you are still cannot create a New Table..post some screen shots
July 23, 2010 at 6:51 pm
I also have same problem - New button isn't hightlighted.
This would seem to indicate that the target connection user doesn't have security to create table in the related database. However it's currently using SA - if that doesn't have access what does? I've tried win authenticated admin user, sql user with create table privilege on the database - pretty much everything I could think of.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply