Hey Looks like I have to Join my Multicast again ,.... becoz when I have OLEDB command its expecting the destination ................

So i have to join again I belive..........

ANy one...

Thanks, Sara....!!!!

Your Second one looks to fit my scenerio.

Once I Select my Source , then I can have three multicast----

1. to writre to 7 diff files.

2. one to update...

I belive Crispin is right too. But there will be only about 7 files each time i run and mostly one or two files will be empty. But agian we...

Thanks Michael.........yet another way of doing it , more simple.

But now the problem is ( i would say not problem, but more complex) that i have seven flat files destination,...

I AGree With you. I was thinking across the same line. I was thinking to loop over the folrder to see if anyfile has size 0, if so then use...

hey chuck i am applying ur approach, However it is not working. its still creating file with 0 kb.

Do u know if there is anything i am missing in Rowcount...

Guys sorry for late reply, got stuck in something.

Chuck U are absloutelt rt, in the datafllow i don't think we can we any precendence connstraints. I didn't get the Brandie...

Thanks Crispin...................

I have tried my way with some dummy data. let's see how i get my data in the flat file.

First i have a flat file connection...

Your logic seems absolutely right.

Few other issues -----

HeaderID CustID HeaderID DetailID StatusCode

----------- ----------- ----------- ----------- ----------

2...

The problem is i don't have the data yet. i will try to put here together everything and explain to best of my ability.

Create tbl Header( ...

Eventually, WE will do this through query, but the query will be in SSIS packages, becoz we have to check daily whether any record with ALL 'S' status is ready...

Use SELECT * from msdb..sysdtspackages90 to get all the lists of the packages in the msdn. And i hope there might a column where u can check the status of...

Thanks, I did.

I think we are not on the same page here. ( I belive, I fail to explain here enough).

I don't have SQL Server on my machine( my Local...

Andy, you don't need a code. Brimg the foreachloop container and in the properties of it, make sure it returns full file path. create a variable and map this to...

Kbata thanks for ur inputs. there are several issues in this case. First i need to keep all those files in the Prior also, becoz we use third party tool...