i need to get list of package variable names during execution of a custom control flow task.
Best regards Crom
View Complete Post
it is possible to start ssis packages with dtexec and set variables as package configuration like this:
dtexec.exe /SQL "\mart1\import_fact_calls" /SERVER "R08" /SET \package.variables[FullImport].Value;True
Now I'm trying to start a package via script task with this code:
Public Sub Main()
Dim pkg As New Package
Dim app As New Application
Dim pkgResults As DTSExecResult
If Dts.Variables("package").Value <> "" Then
pkg = app.LoadFromSqlServer(Dts.Variables("package").Value, "R08", "USER", "PASS", Nothing)
pkgResults = pkg.Execute()
Dts.TaskResult = ScriptResults.Success
How can I add a package configuration like the one with dtexec to the script code?
I like any ideas, links, docus ... Thanks!
I'm a having a problem in passing the value of a variable from child package to the parent package in SSIS.
Can anyone please help me??? Any process would be helpful..either using configurations or using scripting (c# or vb.net)..