Very nice. I have had to implement the check sum before. What I did was build a checksum value over the values of columns (in this case all...

I apologize for my oversight da-zero. I agree with you a 100% with the functionality of components for the SCD. How about using a checksum or even hashbyte...

I agree with ashokdasari, the MERGE is what I would do in this particular situation. I actually use the MERGE to handle TYPE II SCD in my data warehouse...

Des Moines, Iowa.

SSIS does not store passwords......period. I work a great deal with AS400 data files and have found that the easiest method is to use a SQL configuration table that...

SQL Server 2008 Merge syntax could be a better solution in this case.

Actually I have found that using a select statement with the columns listed out in the query performs faster then a select all or table to table mapping.

The reason being...

Thank you for your reply Grasshopper and to everybody else.

1st thru the 6th - run 6 September

7th thru the 13th - run 13 September

14th thru the 20th - run 20 September

21st thru the 27th - run 27September

28th thru 30th...

You are correct to a point. The script will always run on the last day of the range so in your example it would run on the 6th. ...

Thank you for your timely response.

I realize that SQL Server will not allow duplicate names, just want to identify objects that are named pretty close or our copies of one another. I hope that...

I recent worked on a project similar to this......

DECLARE @WeekStart smalldatetime

DECLARE @WeekEnd smalldatetime

SET @WeekStart = (DATEADD(day, DATEDIFF(day, 1, getdate()) / 7 * 7,...

The current process is set up to load into a temp table and then process from the SQL side. All columns are populated. This data is then fed...

If you wish to go the software route, we recently purchased SSIS Document (http://www.ssisdocumenter.com/) that we have found to be a very good product. Also has the...