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

For a start, try using single quotes around your literals ...

--edit:

You may first want to create an sp to help. Something like:

Create procedure [dbo].[s_ExecutePackage]

@FilePath varchar(1000) ,

@Filename ...

bc (5/28/2009)

---

My two cents would be to use the TSQL. I've never tested the ssis Aggregate transform, but would be surprised if it outperformed sql server (of course it...

Yuk, I am amazed that anyone would provide you with a file of this quality.

Is it true that your field delimiter is a space? But then that there is also...

sachinvinod2k (5/28/2009)

---

I can add derived columns but there are so many such values and so its tough to change all of them. do you know how to use conditional split...