KevinGurney (3/31/2012)

---

[SOLVED] An additional language can be added to the OS, without changing system default.

Then the correct locale can be selected in the souce connection and it takes care of...

Or the import/export wizard was used.

How to: Map Query Parameters to Variables in an Execute SQL Task

W00t! 7 points 😀

Ah yes, I have bumped into that...

How are you trying to do this?

Do you have write permissions on that database/table?

You could add a dummy task in the for each loop and connect the dataflow to this task using the error path (red arrow).

The reason there's no error is probably because the For Each Loop thinks it has no access rights, so there are no files to loop over.

So I would check it...

The most visible effect of this architecture is the amount of RAM...

No, I don't know a thing about Kerberos. And I like to keep it like that 🙂

Take contact with the administrators at your firm.

Phil Parkin (3/30/2012)

---

Or create a linked server on the TBL_A server to the server with the codes table. Then create a view on the TBL_A server which returns the required...

Thanks Steve for an easy question to finish the week!

AIRWALKER-375999 (3/29/2012)

---

I've found out that this is not actually possible, but I can acheive the same functionality by using a script task to set a variable and then using Precedence...

Can't you just use the Microsoft OLE DB provider for DB2 and get rid of the ODBC entirely?

You cannot use the object variable directly like that.

I would read from the source with the following query:

SELECT col1, col2, ..., coln FROM TBL_A

I have obviously replaced the * with...