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

So the weeks can have anywhere from 1 to 7 days in them?

How is that useful?

"oh look our revenue this week is 7 times last week, good job team!".

sam 55243 (4/29/2013)

If you are always loading a finite date range, and its not feasible to index everything, you might be able to index the DateKey column and filter the...

I've never seen the two inserts done like that, it looks very clever.

Am I right in thinking that you are not actually updating anything in the fact table? DST.[LOAD_DATE] =...

Have you tried executing the proc from SSMS, but run as the user that the application connects to the db with?

Maybe the app doesn't have access to something and an...