February 2, 2012 at 7:55 am
Hi, how do you choose the name of the table that will be created in your DB when you are importing a table through the import/export wizard?
February 2, 2012 at 8:09 am
You can just edit the name of the table in the destination and rename it. By default same name will be there as source.
Ryan
//All our dreams can come true, if we have the courage to pursue them//
February 2, 2012 at 8:13 am
I have another table on the server with the same name. Anyway to import with a different name by default?
February 2, 2012 at 8:17 am
If this is regular you can create a custom SSIS package to wrap it up
February 2, 2012 at 8:22 am
I created a SSIS file using the wizard. But when I open the SSIS file, I don't see an option to change the destination table name
February 2, 2012 at 8:24 am
If you have the same table name use the secound option to write a query. In the destination field select the table name where you wanted to inserted.
Ryan
//All our dreams can come true, if we have the courage to pursue them//
February 2, 2012 at 8:32 am
What should my FROM statement be if I am writing a custom query? ie. If my Access database location is "I:\databases\quarterdata.mdb", how do I phrase that in my FROM statement?
February 2, 2012 at 9:22 am
guerillaunit (2/2/2012)
What should my FROM statement be if I am writing a custom query? ie. If my Access database location is "I:\databases\quarterdata.mdb", how do I phrase that in my FROM statement?
I suspect you havent done any research on SSIS.
You will need a data source and data destination within a dataflow component. Do a search for importing data from Access using SSIS.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply