Yes, that is your Data Flow 1. I'm not sure I'm following you with what you're saying though. Is that now working for you?

The same way you do in the first data flow, use a Flat...

abhisek karki (7/30/2009)

---

I will appriciate if you can send me the screnshot of the data flow to my question, I am bit confused how to embade row count, derived cloumn...

abhisek karki (7/30/2009)

---

I removed the flat file destination from my data flow, so i route error output to row count, but it didnt give me the # if error...

abhisek karki (7/30/2009)

---

It makes sense now, i will try to do that, but omy other question how do i configure send mail task, in case if i get less than...

What does the execution plan look like?

Here's an idea:

From your error output, route that to a Row Count transformation. This will give you the # of error rows in the pipeline. From there, add...

Were you ever able to connect?

It sounds like you'll need to get someone involved who has server admin rights to help go through the troubleshooting list.

Another one from Microsoft:

http://support.microsoft.com/kb/940232

Try to walk through this and see what happens:

http://totaldevpro.com/blogs/khaselden/archive/2009/04/09/connecting-to-a-remote-ssis-server.aspx

Are you trying to connect via SSMS? What happens?

You are using SSIS for this, right?

If so, each iteration of your for each loop should process one file. In your data flow for the file, you can use...

Yes. If you go back to my detailed post, you'll see that I discussed using Lookup transformations in place of the joins to get the values from MSO and...

It looks like you guys start a bit earlier in the AM than I :-).

You're SSIS work is close. You need 2 data flows. The first...

Yes, you can still partition your table.