Finally u Got it ..............

You know what, the environment i am working changes 3 times in a day.... u go in the morning and edit the work from last time,,and...

ok Jeff, may be now I am confused too...........

here let me give the real name and real scenerio of my ssis package........

the folder where i receive all three files is...

Jeff I belive u r missing something here......................

Let me tell you the situtation at present.

One Inbound folder three data files, three empty files for each data file....... the empty file...

It might sound little complex and long...........But I can think of one solution ( i haven't tired it myself..................)

Create a table for loogging out the success or failure information...

what are you doing inside the dataflow? i know loading, -but from what to what.............? is there a flat file as ur source?....if flat file then what you do with...

The empty file name at present is just "emptyfile" for all three difftypes of datafile.

However mainframe are willing to chnage it to different name like PROFemptyfile, INSTemptyfile and DENTemptyfile. ALso,...

Lynn, FInally Got IT. But for one FTP process I don't thing they would like to do it. ALso, on my side I only have one ssis packages to load...

MedClmPROF

MedClmINST

MedClmDENT

all empty files will be named EMPTYFILE.................

Rt now i have left as it is ..........becoz the scenerio I presented might not happen never, its just one of those WHAT...

Mukti I got it. U r good. BUt, Do you think mainframe guys will agree this. Lots of politics here in the environment.

You know I did my little testing...

Mukti Here the same logical problem for ur solution. Let's say my ssis job starts. I look for lock.lc file. I don't see it . So i start processing FileA....

Mukti I believe I understood ur solution. I thought I was able to fix the problem, but I think I created another one.

Mukti I hope things were like just u...

I am not sure exactly if i got your question or not?

The mainframe guys have their own server, and they FTP the file they create to my database server.

I don't...

Lynn,

I am a great fan of this site. I used to have this task before but when I schedule the job to run ssis packages , it gaev me error...

there is no where clause , thanks....

what is a row delimeter?

or it is a fixed width including the last column.

If so , when you create the flat file connection using dataflow, map the columns accordingly. you...