Well done. My debugging idea would also have helped you get to this ... and in future, I suggest that you learn to watch out for validation errors vs runtime...

For your future reference, note that you can also display images in-line, like so

Which helps reduce the amount of clicking for people viewing the post.

Looks OK to me!

What is the scope of variable strfilename?

You could try adding a pre-execute breakpoint to your FST (click once on it to select and then press F9). Then...

• This reply was modified 5 years, 10 months ago by Phil Parkin.

OK, I had no idea what 837 files were. I just thought you had a lot of files!

Excuse my lack of knowledge about these files, but how do you determine...

As that is the case, you shouldn't have to change Run64BitRuntime.

I've run out of ideas right now, sorry.

Difficult to help without knowing more. Can you provide screenshots of the config of your Foreach container?

Presumably you have the ACE drivers installed on your PC?

Do you have 32-bit, 64-bit or both?

Are you seeing the error when running the package from VS? If not, how are you running it?

What do you mean by "raw data"?

What sort of data do the files contain?

Are the files all structured the same? (Number of columns, order of columns, column names etc)

What do...

Git's just another VCS – it monitors and tracks changes to files. There's nothing in Git which is specific...

Thank...

I have a developer who want's to run sql agent jobs as temporarily. Like create the sql agent job dynamically, run (job is very simple) and when the job...

Since SQL Server 2016, single package deployment to SSISDB has been possible.

What you choose to push to GitHub is entirely under your control, on a file-by-file basis, as long as...

Your package needs to be part of a VS project & solution before the Run button will appear. Try creating these and adding the package to them.

Hello,

the new environment I am working at now wants to use GitHub for version control, and SSIS for ETL, and wondering if SSIS integration catalog will work well with...