I always make sure the AD account for the SQL Server Agent Account has "Full Control" of the Directory where the file is located.

Adaptris have a very useful product called Interlok. If you have a situation where you must collect data from numerous clients, Interlok handles this very well. It spins the design...

Set up your connection manager with column headers. In your data flow task add a Row Count as the first transform in the data flow and store the count in...

A stab in the dark, but this sounds similar to an issue I had using the Project Deployment Model. A new server had been created installed with SQL 16, however...

• This reply was modified 5 years, 2 months ago by  tim.ffitch 25252.

Have you checked your current SQL Server Log to see if SPN (Service Principle Name) was successfully registered the last time the SQL Service was started? This is crucial for...

• This reply was modified 5 years, 2 months ago by  tim.ffitch 25252.

You might want to try running the package in 32bit mode. It depends if the ACE drivers installed on the server are 32bit or 64bit.

Thanks' for the info Sue, it's been a while since I looked at Service Account permissions.

I found the problem. About a week ago the SQL Services failed to start. The server in question uses the default SQL service accounts and someone updated a Group Policy...

• This reply was modified 5 years, 4 months ago by  tim.ffitch 25252. Reason: Typing errors

I set the FailParentOnFailure property to True for the Execeute SQL Task, it made no difference.

I also subsequently tried FailPackageOnFailure = True and that also made no difference. In Both...

I am using an SQL Agent Job that I am running manually during the testing stages. I have used SSIS for years and never had this problem before. 2 other...

No I checked that, the tasks ForceExecutionResult property is set to None. It's not something I ever change.

Are the connections to the Oracle database set to use a Windows AD Account or a Database User Name and Password?

If using the later what protection level is set for...

Yes as Phil said set the Project and each package to Don't save sensitive.

I personally use 2 solutions. A development solution with 1 Visual Studio Configuration and a Release solution...

Use a For Each Loop on the E records to control what is returned for the W records and then the B records in separate Data Flow Tasks inside the...