I was thinking of solving this by expression, how I understand things in this case as my project variable is read only I first have to read the project variable...

well what I want to achieve is this:
If specified by flag: do a full load,
otherwise: attempt a daily load. If there is no file available, skip processing to...

Hi Phil,
there is no index on this column as the only thing ever querying FILE_DATE will be SSIS to check wether to delete records or not.

Regardless of...

Hi Phil,

the Filename contains the date.
Actually we have two different Folders, one for the current file (which does not have the date in the filename yet,...

DELETE FROM dbo.Table
WHERE     (YEAR(CONVERT(datetime, CONVERT(char(8), FILE_DATE))) = YEAR(GETDATE()))

works pretty well. I know this is far from a nice solution but I'm not designing something brand...

Hi Phil,
pretty simple: I'm not going to rewrite the whole package someone started 2+ years ago. The Table is working within the solution and was completed as such. All...

The decision to store a date in bigint format was not mine, I basically just took this to complete whoever before me started this, so the why question is the...

@matt-2 Miller 
If I extract from 1)  and 2) what is left after you won't get a service contract with a medium company and the small company would be the big...

My current customer has an "IT-Dashboard" basically it shows if a certain application is working or not through various checks.

Unfortunately (as with most bigger organizations) there is...

The SQL Engine would only use an index if it feels that it's costs are lower than otherwise getting the data. One very well example of INCLUDE Columns which might...

can you provide me with the output from @debug = 1 running your query? I'll have a look at it next week (I noticed myself some strange things with this...

Well the basic idea is this: you have ServerA as your Data Source configured, you create a linked Server connection on ServerA to ServerB. If you need to...

Being in the Cloud is not the issue, not for Backups neither for Applications running fully on S3 or something like that. The problem is rather that secure configuration of...