Viewing 15 posts - 31 through 45 (of 55 total)
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...
April 23, 2010 at 7:06 am
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...
April 23, 2010 at 6:42 am
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...
April 23, 2010 at 6:24 am
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...
July 16, 2009 at 11:20 am
SQL Server 2008 Merge syntax could be a better solution in this case.
May 29, 2009 at 6:20 am
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...
May 5, 2009 at 6:30 am
Thank you for your reply Grasshopper and to everybody else.
October 24, 2008 at 12:03 pm
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...
October 24, 2008 at 7:40 am
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. ...
October 24, 2008 at 7:18 am
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...
September 30, 2008 at 11:12 am
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,...
September 19, 2008 at 6:17 am
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...
August 7, 2008 at 6:58 am
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...
July 31, 2008 at 7:00 am
Viewing 15 posts - 31 through 45 (of 55 total)