Passing Parameter dynamically - Integration Services (SSIS) and DTS

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » Integration Services (SSIS) and DTS » Passing Parameter dynamically

Passing Parameter dynamically

Options

Previous Topic · Next Topic

raaz

Posted: Tuesday, September 25, 2007 11:37:06 PM

Rank: Junior DBA

Joined: 5/17/2007
Posts: 59
Points: 189
Location: India

Hi,

I have a task with flow... loading the staging table , validate the row count and process and insert into destination table.

this same flow is needed for 5 different staging and destination tables.

currently i have created 5 differrent flows in a package,

is there any way to having one flow and dynamically pass the tables names.

Thanks
Raaz

Scott Whigham

Posted: Thursday, September 27, 2007 7:56:04 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

Two options come to mind: (1) use an expression to write out your destination table name and populate that value with a variable, (2) use dynamic sql to create an INSERT/UPDATE/WHATEVER statement and store it in a variable.

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.