Look closer at Convert. There is a third parameter which is a date format.

Here is an example:

declare @date varchar(10)

set @date = convert(varchar,getDate(),121)

print @date

So you were having trouble finding the actual property? That I found pretty quickly in the Sept. CTP. You're right it might not be there in a previous release. I thought...

Sounds like you have a challenge!

I'm not sure what you actual question is. Possibly,how to set up the database. You mentioned using BCP which you may be comfortable with...

They did a good job hiding this one!

If you look at the Properties window of the Data Flow -- not the flat file destination -- you will see the...

Well, for the chapter example I was working on, using parameters was less messy than a dynamic statement. I also wanted to use an output parameter. Believe me, I tried...

Thanks, Kirk.

Thanks. Looks like it is going over well.

No problem. I just had to go back and find some information I had previously researched.

Depending on the type of connection, the parameters are set up differently. Even then, things didn't always work for me. If you use an ADO.NET connection manager, the parameters should...

This parameter stuff just about drove me nuts. All my 2005 stuff is at home, so I'll try to post how I solved the problem tonight.

More from Thursday: I attended a BI Power Hour hosted by Bill Baker. Several silly demos using Reporting Services, Integration Services and Analysis Services were shown. The cutest was an...

Thursday turned out to be another amazing day. I attended some fantastic presentations. I had a good turn out for my talk and I think it was received well. I'll...

My talk is today. I will be presenting on communication skills. I'll let you know how it goes.

Once more a very long day. Bill Baker gave a great keynote to start off the conference. I ended up attending sessions by Kurt Windisch and Charles Felber. Both are great presenters...

Thanks Jeetendra and Sushila!

This has been the most incredible day! I attended the PSS Boot Camp today and it was awesome. I learned so much and again realized how much...