If you used my suggestion with a dervied column, you might want to double check and make sure that you have a correct count of delimiters and columns now. ...

Redacted as this will not solve OP's problem.

just a thought here...

Direct your Lookup Match Output to another Lookup - use the same setup as you did before ut this time look up and slecect both the...

I'm not sure why you're lookup is directing Matching Output to your destination...everything you describe seems as it should be.

For your particular scenario, this is how I would set up...

osmereqork (7/10/2013)

---

Hi,

confusing myself with possible options for this scenario -

Reporting from our DW must be in both English and French, therefore i maintain the standard dimension in english and...

I think you may have misunderstood what I was suggesting just a little bit.

I suggest that you use SSIS to organize the data in the files into the 2/3/4 "containers"...

demin99 (7/10/2013)

---

b) based on a certain value in a database table?

I think this is possible.

1) Using execute SQL task select the value from the data base.

2) Use the...

This may seem like a quite circuitous solution, but it just may work...

This is not a step by step solution but more of an abstract...

Loop through your files and bring...

Glad it worked!

I had this happen to me before when I mucked around with the columns in one of the buffers - either earlier in the flow or possibly even in the...

Forgive me if I have oversimplified or misunderstood the issue, but this is how I understand it:

You are getting a full backup of your DB nightly (test_stage) and you wish...

Phil Parkin (5/20/2013)

---

greeshatu (5/20/2013)

---

Select and Update are running paralelly .. this is because I have used Balance data distributor to run the tasks parallely .Which asyncronous transformations is helpful in...

greeshatu (5/16/2013)

---

HI ,

I have a Dataflowtask in which following following Transformations are used

---OLEDB Source[Pulls Data From X StagingTable]

---Balance data distributor is used [For Parallel Execution]

---CRM Destination is used for Inserts/Updates...

I might suggest modifying your intial approach...

Create a staging table per the design you need. Add a SQL task to truncate the staging table in early in your process.

Using...

Thanks for setting this up Steve - it was fun!