You could do something like this:

DECLARE @Week_Start AS Int
DECLARE @Current_Date AS Date
DECLARE @Week_Start_Date AS Date
DECLARE @Day_Diff Int

SET @Week_Start = 3

If the portion you are loading from both files are the same, you can actually specify a range of columns in your Excel data source.  This would allow you to...

The ACE provider wouldn't be on the server by default.
It is on your machine because you have Office installed.  
Search for "Microsoft Access Database Engine Redistributable" and you should...

I forgot to mention that in most cases adding code within your job to send out email notifications means hard-coding email addresses in your job.  

However, there is a...

When you configure email alerting for the job agent, you specify a particular profile to use.  This is the profile that all job notification failures will use to send failure...

Wow, I didn't expect that.  Very interesting!

You could probably use a script task to write out the connection information to the log if you wanted, although there could be an issue if the connection uses and...

I went with the first, thinking there was a pattern to what the answers were meant to be.
Looks like that wasn't the case.  :crazy::hehe:

Hi All.

SSIS looks for text qualifier as the character next to the column delimiter. 
If there is anything extra between the two, such as a space, it...