kevin.lanners (6/2/2009)

---

Thanks!

The update statement worked... I was right, it was pretty simple as soon as started thinking "outside the table"

Instead of referencing the newly created table I added an Execute...

Did you try my suggestion of changing the derived column's datatype to DT_STR?

Then we should be keeping DT_STR from one end of the pipeline to the other and your destination...

You just need to avoid mixing and matching your datatypes if you can. Working with DT_STR is just fine. Try using the Advanced Editor on your datasource and looking at...

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?