Another nice example of using a date table, however when you assign the day name wouldnt you be better removing the Case statement and using the DateName(dw,<date>) function that is...

Samuel Vella (7/15/2010)

---

There is logic behind not using the date as the key to the date dimension... it stops developers from falling into the easy trap of using the key...

Rather than using the Tally method have you considered using a CTE, the code below would work just as well and be a little more flexible.

DECLARE @DateFrom as DateTime

Declare...

I did something similar the other month to demonstrate the use of XML data, and how to remove the dreaded cursors from the code, granted it was written on an...

Todd McDermid (6/14/2010)

---

Jason Lees-299789 (6/14/2010)

---

...a better option would be a custom ssis task that allows you to select all the columns you want to be Hashed, and attach the hashed...

UMG, I've used the Binary_CheckSum function as well and normally keep it as a calculated column that forms part of the Business key Index as an include.

However there is a...

rob mcnicol (3/17/2010)

---

'you tell your boss he's off his rocker for suggesting that you work past your usual time but you will happily do the report next morning on receipt...

Firstly I wouldnt use a Script task they ar quite slow and can have problems on 64bit machines if they arnt precompiled.

I would use an Execute SQL task to...

sabyasm (12/22/2009)

---

[font="Comic Sans MS"]You already asked 😛 ...

I was...

sabyasm (12/22/2009)

---

[font="Comic Sans MS"]

The only additional thing I did was to define a variable user::fileJustFound (string).

On for each loop container -> variable mapping -> mapped user::fileJustFound as 0 (the only...

mwwheeler (12/22/2009)

---

I had a similar problem with an ftp connection early in the process, adding the ftp password manually to the config file solved it, so i know that the...

Like Jeff, I'm not sure what it is you are trying to do.

what is the purpose of the package? Is it to parse through a list of files?, to loop...

jarred.nicholls (11/26/2009)

---

Jason Lees-299789 (11/26/2009)

---

As an aside, one of my colleagues ran some internal tests on a somewhat larger data set (1000 rows, same number of columns) and found that the...

Martins answer is a lot sweeter and more robust if you need to loop through a data set, as there is no guarantee that the numbers are consecutive eg record...

In some ways the restrictions have already started...