Why I think everyone on...

Honestly, why is it converting MARCH1 to a date in the first place. MARCH1 doesn't have a year, so it's not a date... Changing it to a date means it...

One way to do this would be to have a stored procedure with EXECUTE AS in it.  This way, you can set the stored procedure to run as sysadmin...

If this is in a loop container, then you actually want to turn error propagation off on  the node:

1. Open your package.
2. Select the Event Handlers Page.
3. Locate the node...

Is this, by any chance, in some kind of loop container?

I'm working over a VPN, yes, but I'm not working with projects that...

This doesn't sound right; I wouldn't expect the package to behave like that. Have you tried changing the ForceExecutionResult value of the Node to Success?

Ahh, don't remind me of that "feature"! I lost so...

To add to what Phil is saying here, you only need to Group on the columns/expressions that aren't in an aggregate function. You are aggregating on Col_amt therefore it's very...

What edition of SQL Server 2008R2 are you running? Is it 32bit version too perhaps?

SQL Server 2008 is completely unsupported now, and has been for a year. Ideally you should be looking at upgrade paths, if not already. It's also concerning that you hadn't...

So what are your expected results here exactly? What is the logic and your attempts, as they will help us understand your goal. Also, please do use consumable sample data,...

since it is living for about 209 years now

RDBMS, let alone SQL Server, weren't around in 1811, so your database must have been really advanced back then!

As for what you're...

SQL Server can't take descriptions and turn that into SQL, and if you have a valid (SQL) expression you would have to use Dynamic SQL; which is an entirely different...

I, personally, tend to go down this route:

CASE WHEN Col1 = Col2 OR (Col1 IS NULL AND Col2 IS NULL) THEN 'Yes'
     ...