August 20, 2010 at 8:40 am
Hi All,
I'm facing an issue in my project.I need to import data from Access Db to SqlServer2005 using SSIS.
What i have done is i have created the tables from Access which i need to import along with the data in Sql Server using the Import Wizard and saved that as a package and then i'm using a stored procedure and comparing the data and the insert is done.
But the issue is Import Wizard which i had converted as package always contains the Database name when we select OLEDB destination and try to select the name of the table.
Even if try to change the database name in the Connection it remains what we created during the Import Wizard.
Is there any option where in which we change the Database name attached with table Name.
SSIS experts please help me on this.It's urgent.
Regards,
August 20, 2010 at 8:53 am
Use the variable to store any dynamic changes like in your case Database , connection string ,table name etc , so you can pass the value at runtime , But to achieve it you have to design your package in BIDS and you should be familier with SSIS little bit coz you have to use the script task inside (either C# or Vb.net) very small code to assign the variable values.There are lot of examples of Internet you can use as reference to get your work done.
HTH ...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply