question

pez avatar image
pez asked

SSIS FTP File System Task

I am very new at SSIS. I have files that I need to monitor on an FTP site. When files are placed there I need to download which I successfully do using the FTP Task. I am using a For Each Loop Container and File System Task to run through the files and move them to the appropriate folder. All works well when I test the File System Task locally but when I try to use the path to my ftp server I get Warning: The For Each File enumerator is empty. The For Each File enumerator did not find any files that matched the file pattern, or the specified directory was empty. I'm not sure what I am doing wrong. Any help would be greatly appreciated.

sql-server-2005ssis
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Answers

·
Oleg avatar image
Oleg answered

It looks like the account used by SSIS does not have permissions to the share where the files are stored. Please check permissions on the share. What is really important is to understand that share permissions have nothing to do with folder permissions. For example, create a folder named c:\Useless\Test on your local box and place a file there. Navigate to that folder and share it (right-click, properties, sharing etc). Now, if you access the folder from explorer as c:\Useless\Test then life is good and you can delete the file if you want. But if you navigate to the same folder as \\your_box\Test you might still see the file there, but you will definitely not be able to delete it. Sometimes, the default share permissions do not allow even viewing the contents of the share depending on the ADSI policies.

Oleg

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

pez avatar image pez commented ·
Thanks. I downloaded a program called Watch FTP. This program does something similar where it watches the site, downloads and then renames files. I didn't set any permissions or do anything to my ftp site and it works fine.
0 Likes 0 ·
Bhaskar avatar image
Bhaskar answered

Oleg is right, the account used by SSIS does not have permissions to FTP. I just had this problem where I had to grant access to SSIS package and it was all set.

Run the package with a job and proxy in the job when setting "Run As".

To create SSIS proxy under sql server agent you may need to create credential with your user name.

You should be all set with this.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

starterm avatar image
starterm answered

I have problem as follows: files comes from FTP and stored in share folder from share folder based on their types they are loaded into database. I am trying to use WMI event watcher task to know the information whether new file is placed is in shared folder or not, how to get output filenames from that wmi event watcher task.So that i can use file system task to put the files into other folder and later use data flow task for loading into database.

please help me how to get output filenames which are newly placed in the folder through WMI

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.