CODEWITHSUNDEEP
dynamicssis
kthyun
kthyun

Reputation: 13

SSIS - DB Destination Dynamic Table Name

After creating tables A, B, C with Control Flow in ssis package, reading Excel with Data Flow. I want to put the data in tables A, B, C generated after processing.

Control Flow (Create table (A,B,C)) -> Data Flow (Read Excel File -> split -> insert table (A,B,C))

Control Flow

enter image description here

Data Flow

enter image description here

Create Question Table SQL Script functoid

Question table

Destination error message

Invalid object error

I think that Dynamic Table is necessary. please help you how to connect to .

Upvotes: 1

Views: 3251

Answers (1)

Filburt
Filburt

Reputation: 18061

You use the variables holding the desired taget table name in your Destination Table configuration.

On the Connection Manager page of your Destinations, just select Tabel name or view name variable from the Data access mode dropdown option.

Then select the variable holding the desired table name.

Upvotes: 2

Related Questions