Click here to Skip to main content
16,020,877 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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?
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900