Hi

Can u send a sample xml file and the details of the table u want to load the data .So that I can help you.

hi

But how the Filewatcher task will come to know that a new file is placed in the source folder .Once the package stops ,you need to run the SSIS package...

Hi

I agree with you ,The File Watcher Task will keep running until the file shows up.

But let's say 2 files are to be read.The package starts and reads the 2...

Hi

If you start the package when the server starts,

let's say it runs at 12:30 and ends after 5 minute .

But the file is placed at 12:36.When the file will...

Hi

I don't think so.Using File watcher task or WMI eventwatcher task in the SSIS package can be usefull but it will not meet the requirement.The requirement is that the...

Hi

The problem is only with your FTP Task.So first you try to execute only the FTP task .Crete a FTP connection ,set the localpath to a hardcoded value like "D:\Test\"...

Hi

You need to schedule your SSIS package to run every 5 or 10 minutes.

Hope this is gonna help you

Incase any query let me know

Thanks and Regards

Rashmi

Hi Abhas

Can you pls explain in details what problem you are facing in the pakage or what u actually want to do ,so that I can help you.

Thanks & Regards...

Hi Praveena

I think this solution will also work for your ParentPackage.Can you please explain in detail what problem you are facing with your Parent Package.

It will be good if u...

Hi abhas

The earlier code was copying the desired file from various source folder to a single Destination folder.

I hav attached a sample project .It is copying the file from source...

Hi abhas

The last solution works fine.I have attached a sample project .Try it out

In case any query let me know

Regards

Rashmi

Hi abhas

Yes ,it is possible to get the file from test1 through test4 .In your ForeachloopEditor select the connection tab and then select the checkbox Traverse Subfolders.

Hope this will...

Hi paul

I think You need to create a lookup table to solve your issue

I have attached a excel sheet that contain the structure of your lookup table and the sample...

Hi Paul

Thank You so much for such a nice complement and warm regards.

Rashmi

Hi Paul

TRADELANE-----------------POL_COUNTRY_CD----------------POD_COUNTRY_CD

Euro NC/UK to ASPA---------Starts with GB-------------Any country where Region/Trade = ASPA

Euro NC/UK to SPAC-------- Starts with GB-------------Any country where Region/Trade = SPAC

Euro NC/UK to US-----------Starts with GB-------------Starts with...