Hey Guys,

I need help from you regarding SSIS. Here is my requirement:

. A window service will act as watcher on a given folder which wil notice any new file placed in it.
. if a new file comes in folder I want to import file present in given table (this file is flat text file).

I have idea how to create SSIS package through wizard. but i m looking for a way to pass file name from this window service to respective SSIS package.
Is there any way by which i can pass file name programmitcally?

Please provide me some input on this.