I don't really understand. You write some files to a table. And then you want to read from the table in a data flow task. Can't you just use an...

krriegle (11/19/2010)

---

Thank you all. I used the Transcender practice exam. It was useful because the questions differed in scope than the training kit questions but for future exams...

You mean you want to use a lookup component...

parthi-1705 (11/19/2010)

---

hi

I have used the Source ---->derived column and unionall ---->Destination it has run sucessfully.i need to check duplicates in this ,that is i need to find the duplicate record...

Ah OK. That is indeed stored into the .dtsx file, but as Elliot already...

tmitchelar (11/19/2010)

---

The third way would be to click on the properties of the data flow task from the control flow and use and set your query there with your parameter...

Allright, let's try again. What did you do exactly? What are the errors?

Did you use a flat file destination? Is the file there with data after the data flow has...

Alvin Ramard (11/19/2010)

---

Tim Hief (11/18/2010)

---

Hi Alvin, I couldn't get the .Net samples I found to do what the VBScript did (and so painlessly I might add). I'd be open...

When I see your derived column in the attachment, I keep thinking:

there must be a better way. Like parsing the .csv file in .NET or writing the data to a...

tmitchelar (11/19/2010)

---

This is soley based on personal preference, but I would create four separate packages...one for each table. I like having the option of being able to rerun tables...

Phil Parkin (11/19/2010)

---

I guess it comes down to personal choice, but if I were going for parallelism in this situation, I would still use four dataflow tasks but put them...

You can...

veeren4urs (11/16/2010)

---

Hi,

Congratulations. Even i am planing to write this exam but i dnt have any work experiance or knowledge on SSAS can i go ahead with out SSAS becuase i...

Congratulations!

sharath.chalamgari (11/19/2010)

---

Ya that's what the above solution gives.

In your dataflow task's oledb source select the data access mode as sql comman and

add the sql Command text and where ever...