Okay, I've been meaning to do something like this for a while, but to have it laid out as a copy/paste job! Must say I am impressed. Intend...

Technically, you're right. They do not charge you to keep the license, the program did not stop working - as it turns out - because keelio turned off...we transferred...

r.saintclaire:

I promise you it is not some dumb marketing ploy. Licensed users swear by it. We use it here at our company. We discovered it...

Yeah...I said that.

Like...a year ago. Way to follow the thread.

As for an update:

Keelio gets the job done as an easy trick in SSIS but bear this in mind. The...

Yes, there is...

You use a FUNCTION in your BIS. You bring the variable in, run it through a "function", do the appropriate pulldowns, and you can convert that date...

http://www.keelio.com

Download the 30 day trial and save yourself some grief and aggravation...

Beware of N_TEXT fields though, CAST them as CHAR if you need to convert one.

Trust me...I just...

Sorry J, but I gotta disagree...

I do not believe in reinventing the wheel, nor do I accept that I need to become a script junkie to convert a simple query...

Okay Gang.

I can officially say I have tried every posted method. If you are using Visual Studio Business Intelligence Studio, GO RIGHT NOW and get the Keelio...