Hi, Every day i need to get XML file from ftp.how to get that file dynamically... can any one guide me

If this is a standard FTP you would do the following - 1. Create a new Integration Services project 2. Drag the "FTP Task" from the "Toolbox" to the "Control Flow" 3. Double Click the FTP Task 4. Next to "FTPConnection" in "General" Click the Arrow and select "<New Connection>" 5. Enter the connection information click OK 6. Under "File Transfer" select the applicable options - "RemotePath" is the file you want to fetch, "LocalPath" is the locaton you want to save it to. At this point you can now make it more Dynamic by clicking "Expressions" and mapping configuraton properties to variables. Please let me know if you need help with that, I can point you at a few good references. Variables can be staticly set by configuration files at run time, or dynamically generated in containers.

Everyday a different file name? Filename with a date string in it? If so provide an example of the filename.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

If this is a standard FTP you would do the following - 1. Create a new Integration Services project 2. Drag the "FTP Task" from the "Toolbox" to the "Control Flow" 3. Double Click the FTP Task 4. Next to "FTPConnection" in "General" Click the Arrow and select "<New Connection>" 5. Enter the connection information click OK 6. Under "File Transfer" select the applicable options - "RemotePath" is the file you want to fetch, "LocalPath" is the locaton you want to save it to. At this point you can now make it more Dynamic by clicking "Expressions" and mapping configuraton properties to variables. Please let me know if you need help with that, I can point you at a few good references. Variables can be staticly set by configuration files at run time, or dynamically generated in containers.