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

What is the second job called? It doesn't contain '%integrity%' does it?

I have had to resort to using a sql statement from a variable, then set the variable earlier in the package.

I have created a table variable that contains the...

The easiest way is to use ssis to import the data into a table, then execute a sql task that does the update / insert (merge).

Alternatively you could include a...