Dynamically Move Data from one server to another SSIS

See more:

SQL-Server-2008R2

Hi,

I want to move data from one server to another server. I don't have access to generate scripts or use the Import export wizard or to take backup and import it.

Currently I created a SSIS package by creating 2 Database connection managers for source and destination.

I have used OLEDB Source and OLEDB Destination data flow tasks and linked them.

In OleDBSource I have choose Data access mode as "Table or View name variable " and created a variable name "TblName"

In OleDBDestination I have choose Data access mode as "Table name or View name variable" and pointed the variable name to "TblName".

I am changing the Value of the TblName variable everytime I have to insert data into different table by editing the ssis package and it is working fine but sometimes when I assign the value to variable and execute the dtsx package it fails mapping the columns from source to destination.

Is there a way to give the name from a file or dynamically to the variable and to avoid these mapping issue?