yep.....made the user a member of the role.

I actually got around the problem temporarily by making the role the owner of the schema that I wanted them to access. Then...

Right....a bit of Googling and I got it to work.

I set the ForceexecutionResult propert of the ForEachLoop container to Success, then the container loops through the files and only imports...

Thx Sabya, that is starting to work...

One thing though...As I am looping through files, lets say 10 excel source files, the 2nd one fails. The Lookup component in my Data...

Sorry about the late reply to this....just getting the project going again 🙂

How do I place the on Event Error handler to reject the files for a particular task?

The whole...

Right... finally started thinking straight...

select

activity_date,

to_char(activity_date,'IW')-to_char(sysdate,'IW') as Date_diff

from

dw.calendar

and then hey presto! :w00t:

Combine brain failure and working with Oracle in place of SQL Server for the last few months... and bingo!

Forget all the functions and the most simple of methods.. 😛

hmmmm....

simple and effective....where is my brain this morning :blush:

Thx for the code..

Most likely this is of course down to security. Running the...

MSDN state the following...

Valid values are one and higher, or -1. Other values are invalid. A value of -1 allows the maximum number of concurrently running executables to equal the...

Thx - obviously for the REPLACE function to work, you have to know all the strange chrs that users may have entered - not possible to cover all eventualities.

Carolyn -...

By the rerror message it looks as if the server + firewall combination of the FTP server are rejecting the connection, not that there is anything wrong with your connection...

Is there any reason why you are scripting this task and not using the FTP Task in SSIS?

In your SSIS package you can also create a log.

Use this log to document all the steps that your package runs through, and check the log verifies everything correctly...

Can you give anymore info about how and what you expect from th export?

Integration services will be your best bet here, but without more info, I can't give much more...

Thx for that - my ssis package also runs faster now without the date conversion.