Can you tell whether it loaded all 16K files?

It sounds like it did all the work, but never reported to the screen that it had finished. Did you look at...

You will need an alias for the derived table containing the unions.

Just add "AS a" after the final close bracket/parenthesis. (Ironically the TIA from your message would probably have sufficed).

Without...

• This reply was modified 2 years, 11 months ago by  Ed B.

Can you join to the other tables within the Merge statement so you have access to your codes?

This might be easier to implement as a CTE, but I don't like...

• This reply was modified 4 years, 10 months ago by  Ed B.
• This reply was modified 4 years, 10 months ago by  Ed B.

I don't think you will be able to do it in a single query.

Here's how I would approach it. This is fairly vague, but the details will depend on the...

Can you put a check constraint on both tables, e.g. ID <= 100. This can give you a "partitioned view". It works for =, but I have never tried it...

I had to do this last week. I found this forum thread and it gave me what I needed.

http://www.sqlservercentral.com/Forums/Topic1465444-279-1.aspx

SMALLDATETIME gets you closer to what you want.

I think the excel connector relies on MS Office drivers being installed.

https://msdn.microsoft.com/en-us/library/cc280527.aspx

I think you need the Access Database Engine.

https://www.microsoft.com/en-us/download/details.aspx?id=13255

This is worth reading.

http://www.madeiradata.com/load-data-excel-ssis-32-bit-vs-64-bit/

I think I'm as confused as you.

http://blog.nwcadence.com/sql-server-data-tools-clearing-up-the-confusion/

Maybe you need to look for SQL Server Data Tools that is part of SQL 2014?

https://www.mssqltips.com/sqlservertip/2804/introduction-to-sql-server-data-tools/

When that happens to me, its usually permissions. The job is typically run by the sql agent account which may not have access to something referenced in the package, like...

Does it work if you export as a csv? If so, then its probably some excel devilry. If not, then perhaps permissions.

Have you set "Use 32 bit runtime" inside the agent job? Edit: Never mind, I see you did mention this.

http://1.bp.blogspot.com/-WHsiqaOI8gA/T8_GuvdMMZI/AAAAAAAAAPE/SoqxcClaSvI/s1600/ssis.jpg

Does this get what you need?

There is probably a cleaner way and I did modify one data value so that SubscriberNum 1234 would be D-D

SELECT *,

CASE

WHEN EXISTS (SELECT 1...