Personally I would just include a field in the dimension that stores the source where the record came from.

Is it possible though the dimension info for one record can come...

Is the variable property EvaluateAsExpression set to true?

Put a breakpoint on the preexecute event of the Execute SQL Task and check the value of the SQL query in the locals...

SQLRNNR (6/4/2014)

---

Evil Kraig F (6/3/2014)

---

SSIS: Crappy naming methods for your data sources. You're connecting this thing to a database and you're going to push it through environments. It...

Ronnie Rahman (6/4/2014)

---

Koen Verbeeck (6/4/2014)

---

Ronnie Rahman (6/4/2014)

---

Yes please - report rendered as PDFs. Currently we are saving reports as PDF files one by one, which is tedious and painful process....

viresh29 (6/4/2014)

---

The column after "A" is "" that means it's empty so SSIS takes empty space as string.

You are getting error because your destination column is Integer.

You need...

rot-717018 (6/4/2014)

---

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...

In that...

Ronnie Rahman (6/4/2014)

---

Hiya

Thank you very much for your quick response.

I will check the link you have provided. The main requirement is to download report file as pdf format in...

You can try to get it directly out of the reporting database.

Extracting SSRS Report RDL (XML) from the ReportServer database[/url]

In the for each loop container, you need to map the current value to a variable.

This variable is then used in the second Execute SQL Task.

You can put a breakpoint...

+1

I always use leading commas. It looks cleaner in my opinion and it's easier to align everything.

This SO thread shows how to write an UPDATE query using a join:

http://stackoverflow.com/questions/3468006/sql-server-update-with-inner-join

In other words, you join the table you want to update with the update table.

Add a WHERE clause...

Copy pasting the solution will probably be enough.

If it is only the data that changes, it is pretty similar to deploying a solution from the test server to the production...

Evil Kraig F (6/4/2014)

---

Koen Verbeeck (6/3/2014)

---

That is fine during design time, but I'd like the full error at runtime. I've had cases where the actual error was cropped off because...

Yet another awesome question. Thanks Andy!