It's a long time since I used DTS, and I don't even have it installed any more, but I think you can use something called dynamic properties to achieve what...

Ah yes - you're right. If you can't be sure that all names appear in both tables then an inner join won't work.

John

Almost... you need an INNER JOIN on the Name column.

John

This is a simple JOIN and SUM query. Please will you show us what you've tried so far?

John

Be careful about standardising your users in this way. Although it simplifies administration, it's a security risk since it means that giving someone (or something) access to one thing...

Without seeing the script you used in your job, it's difficult to comment.

John

Group by CartesisRU, CartesisBU and HFMEntity and use a HAVING clause.

John

OK, you've got an NTFS permission issue. You need to make sure your SQL Server and SQL Server Agent account have read-write access to that folder on your X...

Dan

Although I suspect it won't make any difference to performance, I don't think you need the ISNULL, since SUM ignores NULLs.

John

You're quite right - I said active-passive but I meant to say active-active. I'll amend my...

Be aware that if you go active-active then your licensing costs double, since you have to pay for a licence for each node that SQL Server runs on.

John

Putting performance aside for a moment, creating a separate instance for Sharepoint would provide a couple of benefits. The first is that you can perform maintenance on your Sharepoint...

You can use the Derived Column transformation.

John

You can specify in your package at design time which configuration filter to use. If you want to specify a different one at run time, I don't know how...

If your parameters are stored in a table that looks like the [SSIS Configurations] table that is created when you enable package configurations for a SQL Server table, then you'll...