|
|
|
Grasshopper
 
Group: General Forum Members
Last Login: Tuesday, January 19, 2010 11:00 AM
Points: 19,
Visits: 82
|
|
Hi All
My SSIS package is executed from C# code.
I have a variable that I want passed from the C# code to the package. I know how to set it at the C# code end i.e.
ssisPackage.Variables["PaidWeight"].Value = '5'
but what I dont know is, how do i use this at the SSIS package end in a ExecuteSQL task. Do i create a package wide variable? Pls help.
Thank you
Gomz
conningtower@gmail.com
|
|
|
|
|
SSCrazy
Group: General Forum Members
Last Login: Today @ 5:59 PM
Points: 2,379,
Visits: 1,832
|
|
Did you not understand what was posted at:
http://www.sqlservercentral.com/Forums/Topic803085-148-1.aspx
CEWII
--------------------------------
Having trouble figuring out what jobs are running in SQL Server at the same time.
Try Sql Job History Visualization
It lets you view your SQL Job history on an Outlook style calendar..
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Tuesday, January 19, 2010 11:00 AM
Points: 19,
Visits: 82
|
|
Hi elliot
I m sorry for not getting back , the problem i faced was i needed to get the package variable into a ole db source so that I can use it to create my output and send it to a flat file destination. I dont know how i could do that when i use a execute sql task like the way u had suggested.
Thank you
Gomz
|
|
|
|
