Hello,

Hope to find everyone in good health.

In control flow I successfully created a task which will copy data from text file to a table named abcback.

Now I want to transfer data from abcback to abc using SSIS. How do I accomplish this?

Why cant I transfer data directly to abc?

Table abc has two extra columns of varchar type. So when I tried loading data directly to abc data would not go proper.

Meaning the text file has comma separated seven columns. whereas abc has 9 columns. So data would not load properly and I has to change data types to string in SQL SERVER for all columns for abc to get rid of bulk insert error.

So I  created abcback with 7 columns. Now want to tranfer data from abcback to abc which have same column names for 7 columns.

Any suggestions?