Are they both in YYYYMMDD format?

There is no such thing as an 'Execute SQL Script Task component'. I think you mean an ExecuteSQL task, is that correct?

Why not something like this?

IIF(LEN(Col1) <2, Col1, LEFT(Col1, LEN(Col1) - 2))

where t.col5 is not null

Hah! I thought of this too, but assumed that the values in Col3 and Col4 for the NULL date were required to be included somewhere in...

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

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 5 years 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.