So, I got a bit further ...

1. using the Watch, I can confirm that the variable holds the correct clientID at each loop

2. tried to replace the "?" with @[User::clientID]

but...

Thanks Koen, I'll give it a try and let you know ...

Thanks a lot Eirikur and Matt for your answers ...

The @ sign did the trick and I was looking so long for this ... :crazy:

I was wondering how I could...

Sorry for the delay ... I wanted to post my solution but I was stuck with deadlines!

So, as a newbie, in XML using a SQL query ,my approach was to...

Searched and found!

ok, so I got a bit further, simplified the query, added the sort order, displayed data and again the same error appearing

The SQL query is ...

select 1...

ok, I think I got it ... let me check ...

hi,

just a quick note to philosophae:

in the new query you wrote you're summing from table1 and deleting / inserting in table test; this is not what you ment to do...

Hi Sean and thanks for your answer. I was off over the week-end but now back to work.

Basically what I want to achieve is something like this

<Document>

<CstmrCdtTrfInitn>

...

This is really a problem for me and no answer despite 120 views ...:crying:

Let me re-phrase my question:

Is it possible to create a linked server to a file (best Excel...

+1

Good article; thanks for sharing your experience Phil ...

Below is my solution ...

In my scenario, I needed to restore a Live DB to any of our 4 QA environments. As...

I narrowed down the problem which comes from Excel's spreadsheet creation. So I tried to use Flat File Destinations and it's much better!

The problem I'm facing now is to dynamically...

See attachments for the execution of the package

Control flow - 001.jpg

Data flow - 002.jpg

Oups, nobody replied yet ... it seems this error is hard to solve ... or maybe I'm not clear enough

Please let me know ...