Thank you Phil and Craig for you replies and examples. This helps a lot. The biggest reason I wanted to see the values is for troubleshooting what was...

Craig Farrell (3/14/2011)

---

bruce.b.allen (3/14/2011)

---

Quick question maybe someone can answer.

I currently use a script task to set the value of a variable. The script task works and sets the variable...

steveb. (1/13/2011)

---

you can add a sort transformation and check the box to remove duplicates based upon the sort key,

or you could put the data as is in a staging...

Alvin Ramard (10/25/2010)

---

I agree with Derrick that flat files would be much easier.

If you have to use Excel, and you have a row number for every row of...

Thanks for the suggestions. I'll look at the conditional split and see if I can get that to work. I agree with both of you on the exporting to...