the config file needs to be where the packages can see it, either locally in the same location on each box that runs the package (remember that the package runs...

and you have set the resultset to single row. in the result set section, you should have one entry, with the result name set to "0" and the variable...

could you post the code here?

is your sql statement calling a stored proc with an output parameter?

it looks like I am unable to get access to the subcomponent information, so i have had to implement a clunky workaround joining and splitting strings.

i can't quite remember (i don't have ssis on this machine) but for result set i think you can choose to have either none, single row, full rowset or xml.

if...

do you mean:

s, b, d

a, b, c

c, null, null

or

s, b, d

a, b, c

null, null, c?

is the criteria that the last row contains only the last column from the previous...

wrong forum, i think, bud.

cheers,

tom

what have you specified for the result set?

tom

Just about to leave work so a quick reply.

Try running the select statement in a SQL task, and save the result as XML to a variable.

Then, use an XML task...

Unfortunately, the location of the config file has to be hard coded somewhere. Either you specify it when you run the package, or you save the location of the...

update: I know the event handler is consuming the subComponent parameter because it appears in the output text. I just cannot figure out how to get hold of that...

No problem, glad it's up and running.

Like most things with SSIS, there are usually two or three ways of getting it done.

Cheers,

Tom

If you look at the properties of the SQLMain variable, you will see a property called EvaluateAsExpression. Set this to True.

Then, right below this, there is a property called...

You can always use a variable to hold the stripped characters, and set it to be evaluated as expression.

Then, add this variable as a derived column.

Tom