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

Maybe add a couple of derived columns, cSex and cDOB (or whatever) which are set correctly and use these.

If there's not enough flexibility in there, a script component could easily...

Does the SQL Agent user have permissions to access the files?

Delay validation should be set to True, not False, if the source file does not exist until run-time.

You could approach this a different way. Set up a hard-coded connection to,...