Hi ..
I need some information on the package configuration files. i.e how to set the configuration parameters from outside the packages. Pls provide me some detailed information along with examples. I want to make my packages to read paramaters from the configuration files as we have in .NET(web.config)////
Secondly I want to know how to play well with variables.. i.e setting a variable.. reading a variable.. passing a variable in the SSIS package dataflows and datatasks.. respectively. Please provide some infomation and a good exam[ple on it I need
sam_idea wrote: Hi ..
I need some information on the package configuration files. i.e how to set the configuration parameters from outside the packages. Pls provide me some detailed information along with examples. I want to make my packages to read paramaters from the configuration files as we have in .NET(web.config)////
Have you looked in BOL? There's plenty in there regarding SSIS configurations.
Example here: http://www.sqlis.com/?26
sam_idea wrote: Secondly I want to know how to play well with variables.. i.e setting a variable.. reading a variable.. passing a variable in the SSIS package dataflows and datatasks.. respectively. Please provide some infomation and a good exam[ple on it I need
The 2 most common methods for setting the value of a variable are using an expression (when the variable has EvaluateAsExpression=TRUE, example here: http://blogs.conchango.com/jamiethomson/archive/2005/03/19/1163.aspx) or a script task. There are various tasks (e.g. Execute SQL Task, XML Task) and components (e.g. Rowcount transform, Recordset destination) that can set variable values also.
There is no concept of "passing variables between tasks". A variable is scoped to a container within the package and is accessible by that container and all its ancestral containers. You can pass values between tasks by storing them in variables (note the subtle difference here)
Here's some examples of how you can use variables:
http://blogs.conchango.com/jamiethomson/archive/2005/07/04/1748.aspx
http://blogs.conchango.com/jamiethomson/archive/2005/04/09/1265.aspx
http://blogs.conchango.com/jamiethomson/archive/2005/06/15/1693.aspx
http://blogs.conchango.com/jamiethomson/archive/2005/05/30/1489.aspx
http://blogs.conchango.com/jamiethomson/archive/2005/02/09/964.aspx
Here's a tip for you. Google is your friend and alot quicker than this forum: http://www.google.co.uk/search?hl=en&q=ssis+configurations&meta=
-Jamie
No comments:
Post a Comment