This is likely to be problematic. Consider the following (I added an extra row of data)

SELECT t.col1
      ,t.col2
    ...

• This reply was modified 4 years, 6 months ago by Phil Parkin.

Can we assume that DATETIMEIN and DATETIMEOUT will be on the same day?

Is MINTUES a mistype? Do you mean MINUTES?

It's not that long ago that...

Maybe something has changed but, in the past, it wouldn't allow you (unless you knew the "silent" trick) to install the 64 bit version if 32 bit apps were...

There are two files in the download, one 64-bit and one 32-bit. You need them both.

Presumably you've tried searching for "Microsoft.ACE.OLEDB.12.0 Provider Download"?

Because that's what I did. If you do that, you'll find both the download files and information from others on how to perform...

If you are hoping that...

Have you got both the 32- and 64- bit versions of the drivers installed?

(SSDT uses the 32-bit version and (by default) DTExec will use the 64-bit version – might as...

DACPAC will do that. If you are not familiar, there is plenty of material available online. The process should be straightforward:

1. 'Extract' a DACPAC from the existing database.
2. Create a...

It is likely that you will get more responses if you post your sample data in consumable format (ie, with DDL and INSERT statements).

I have used that before.. but was looking for something that would dump tables in order with foreign key reference in mind, so I could pickup this file and...

As the column names are not static, doing this dynamically is probably the only way you will get this to work.

The answer is 'almost certainly'.

Now, if you will take the...

I hate it when something fails, but only some of the time. Makes troubleshooting all the more challenging.

Can you see any sort of pattern between executions which succeed and those...

OK, then check the SSISDB 'All Executions' report (assuming the package is deployed to SSISDB). It should tell you which component the package fails on.