Once again, I would suggest that the error message gives the game away. Try changing the data type of your derived column to [DT_STR].

Are you able to query user tables in the Access db?

Just wondering whether any additional permissions are required to query Access' system objects.

Or run a simple UPDATE query after the import has completed ...

You need to put a file there somehow for each of the connections you are creating.

Then create the connections, set 'delay validation' to true and delete the files.

greengiant (6/1/2009)

---

In the derived column name I left the text "derived column 1".

In the derived column I left "add a new column".

In the expression I added "@[User::xCurrStatus]" This is my...

Greg J (6/1/2009)

---

sorry Lynn. "UNION ALL" would have the desired effect in that example, but it seems too contrived to be elegant much less efficient.

Destination table has 150 columns.

There...

Does it have to be SSIS? Have you thought about using the Access upsizing wizard?

It seems to make sense, I suppose (no point me asking why it wasn't done that way from the start).

Are the tables/fields in all the databases the same? Are you...

Instead of adding only 1 new field to the pipeline, add enough char(1) fields to accommodate your binary characters.

Then assign the fields in the script component. This example shows you...

I'll show you how to do the conversion part.

Add a new string field to your pipeline - I used 'BinaryString'.

Then add a script component. The line that does the conversion...

Does the source contain a string: "2pow3" or an integer: 8?

You say integer, so I will assume 8. Just looking at it now ...

Eek! What is the rationale behind combining the databases? Are they all related somehow?

zbleslav (5/29/2009)

---

Question was:

"How...

SSIS requires that you put your data through a sort transformation before using a MERGE JOIN - regardless of whether the source data is already sorted.

Have you investigated the LOOKUP...

Greg J (5/28/2009)

---

Yeah, the DelayValidation is set to true for ALL of the data flow, ForEach looper, and the Excel Connection Manager.

I found a similar post here that I've been...