SSIS: OLEDB Destination dynamic SQL Table Name?

Asked By karthik 200 points N/A Posted on - 06/17/2011

Hi,

I would like to know how to setup the OLEDB Destination dynamic SQL Table name in SSIS. I have designed the Raw File Source Tasks which would pick up the source files dynamically. And I connected the Source Task to an OLEDB Destination Task. The OLEDB Destination tasks SQL Table name should be changed dynamically.

I have tried using variable name. But in the Connection Editor page, I can’t select the Table Name variable which was declared previously. Please let me know the solution for this issue.

Thanks in Advance.
Karthik.

• Status: Open
• Question Views: 5400
• Answer Count: 2
• Vote Up 20 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by karthikeyan

Go To Solution

Best Answer

Best Answer

Answered By karthikeyan 0 points N/A #125556

SSIS: OLEDB Destination dynamic SQL Table Name?

Hi Karthik,

For your information, you can choose the variable option from the Table Name list in the Editor Page of the OLEDB Destination tasks. If you are trying to create the SQL tables at run time, then you have to enable the “Delay Validation” option in the Properties page. Enabling the delay validation option would accept the table creation at run time.

Sometimes the editor page of the OLDEDB Destination task will not allow you for further steps until the table names have been selected. In this case, you have to create a dummy SQL table in the database and select that table name from the drop down list. This solution may solve your issue in SSIS.  

Thanks,
Karthikeyan.

About karthikeyan

Questions
0

Answers
2

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 06/17/2011
• Question Category: MS SQL Server

Answered By karthikeyan 0 points N/A #125557

SSIS: OLEDB Destination dynamic SQL Table Name?

Hi Karthik,

If the previous solutions are not working, finally you can try the Bulk Insert task in the Data Flow Control. That is a perfect solution for this issue. You can use the Bulk Insert task in the For each loop container for the dynamic insertion of Source Data into the dynamic SQL table.

Thanks,
Karthikeyan.

About karthikeyan

Questions
0

Answers
2

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 06/17/2011
• Question Category: MS SQL Server