SSIS's individual Task's folder access


I've been working on a particular project were we need to extract data out of two ERPs, transform it and then send it by secure FTP (OpenSSH).

I have evidence that make us believe that the 'profile' under which an especific task runs may vary between tasks within the same SSIS runs. I have an Script Task dumping an csv file into a secured folder and the next task is an 'SQL Task' which can't access it and therefore generates 'invalid file' error.

I have test everything using a public folder and works just fine, but when we use the restricted folder is when things get odd. I've been able to establish that in a particular 'Script Task' the owner of the Job plays an important role, because if the owner doesn't have access to a windows folder the task fails.

Later on I have established that another task fails if the Job runner doesn't have enough privileges on the box where is running.

Finally I haven't been able to walkaround the issue I already mentioned where a task creates the csv file and the next tryes to access it and it's denied.

All that whiout mentioning that where you run the package from Visual Studio is even harder to tell which profile is being use by the particular task.

Does anyone knows where to go?


more ▼

asked Apr 21, 2010 at 04:58 PM in Default

avatar image

1 1 1 1

(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 21, 2010 at 04:58 PM

Seen: 528 times

Last Updated: Apr 21, 2010 at 04:58 PM

Copyright 2018 Redgate Software. Privacy Policy