How do I create a Proxy? i.e.: Proxy name, Credential name, Principals, Type of Principal, etc.

Thanks and I agree that the For Each Loop Container is the best route after I iron out more core problems. I'm writing this program first assuming that the .csv...

There's no compression on the source or destination folder and I used this just guessing, but no change in the results:

     ...

• This reply was modified 3 years, 4 months ago by  DaveBriCam.

Let me know what info would help. I can run the package from the ISC with no problem, but when running from the Agent Job it says it can't read...

• This reply was modified 3 years, 4 months ago by  DaveBriCam.
• This reply was modified 3 years, 4 months ago by  DaveBriCam.

I'm having unexpected trouble getting the SQL Agent Job to run. I first set it to run about 45 minutes ago and to run every 15 minutes. There are no...

• This reply was modified 3 years, 4 months ago by  DaveBriCam.

Yes that's it... I can create a File System Task to move it to an Archive Folder using some C# script:

using System.IO;
namespace ST_adc7961e6d564b959438804fe590a5a4
{
[Microsoft.SqlServer.Dts.Tasks.ScriptTask.SSISScriptTaskEntryPointAttribute]
public partial class ScriptMain :...

What about if that file is not removed from the folder at the end of the day and another is not put in its place... will it not reprocess that...

Where is the typical place etl folks place files for a deployed SSIS package to consume? Are there alternatives?

I resolved the 64bit issue on the host machine (thanks!) but two errors remain:

How do I tell if I need the x86 or the x64 driver?

The machine is a 64-bit operating system windows 10... but I have no idea how to find the drivers or install a 64-bit driver without breaking something.

Do I install the driver on the actual machine that the SQL Server resides on or my local machine? And do I download the driver and install it? Totally new...

If I choose to check the box for "32-bit runtime" I get the same message. What additional configurations need changed or do I need to add a driver to SQL...

I found the problem - the Constraint needed just an expression and it needed double equal signs: @[User::TrainingFilePresent]==1 and @[User::TrainingFilePresent]==0

Thanks!

The variable for the path is ReadOnly, the variable for the filename is readOnly, the variable for the FilePresent is Read/Write