Sorry missed the whole 'don't want 25 packages' quote, but still the script might help others.

I take it you are doing a simple lift and shift of data from one source to the other?

I had a similar issue, except I had to do this for...

If you are new then the books by Itzik Ben-gan are very good, the previously mentioned book, as well as Inside Microsoft® SQL Server® 2008: T-SQL Querying which can be...

I thought there were issues with using a DEFAULT constraint, as it will only kick in on INSERT if the column isn't explicitly named, or you use 'DEFAULT' clause on...

sounds like a bit of overkill, surely a better solution is to have a corporate intranet with the privacy act on it, and require that every employ accepts the terms...

I've found that the SSDT database projects and TFS works very well as the means of checking the DB against the Source Controlled Master version.

Though I agree with Phil on...

As with all reporting tools it all depends on what you want to do. There are scenarios where Tabular is far better than OLAP, but just as many where...

When you break this down you are creating weekly bandings, the following query reduces the need for the parameters, as this could form either a CTE, Subquery or Table valued...

What actually happened to the cluster did it throw a disk?

as its possible a file that SSAS needs to start up may be corrupt or missing.

This might help...

<ignore missed the first post on the second page>

For those attempting to help, I found this link that explains the requirements

http://scn.sap.com/people/deepak.aggarwal3/blog/2009/04/01/italy-legal-requirement-official-document-number-range

There are 2 possible solutions, the first is the simple prefilled table with a flag to show if...

Thanks Phil, I think that might have to be the solution, I'll have chat with the manager to check on the process that they follow when importing data and...

Thanks for the reply Phil. I would agree about setting them to a max size and leaving it, but we have no control over the database. It seems...

Thanks that works a treat though I had to use Item(0).Name, and wrap it all in a StrToMember

The last issue is that it...

The issue with DB triggers is that they only operate on the change of objects, not actual data changes.

To Monitor data changes you would need to create table level...