Yeah, I tried Bruce's but it gave me a syntax error. Anyway, I went with Wayne's suggestion and it seems pretty simpler.

Thanks guys,

Bruce, your suggestions "convert(varchar" won't work because it's a text field, so the field needs to be parsed to remove the spaces and time after the date. Then I...

I want it as 7/2/2009.

the source field is a text field and the value is stored as 7/2/2009 11:07:23 AM

Thanks happycat; that works perfect.

John

You're right!! after I deployed and viewed in Report Manager it showed.

thx,

John

Thanks Lowell.

How about it, Nate.

Pardon my ignorance Lowell, but where exactly or how do I insert such script.

This is what I've tried so far:

in the Textbox Properties window, in the General tab, I typed...

Thanks Peddie, I didn't think there was an automated way to do this.

John

Thanks Greg, I ended up migrating the DTS pckg in BIDS; built it to our SSIS share folder, then from Mgmt Studio I created a job and added the...

Greg,

So what do I need to do to see the former DTS job in SQL Server AGent? Is that not possible?

Yeah, I figured that. Thanks for the info.

I figured it out myself. I had to size down the width of the matrix to be within the array....whatever that is, it works.

Thanks guys....

I forgot to explain what I'm trying to do: My report is in reporting services. My datasource execs a sproc that passes all my fields except for one. This...

Thanks for the detailed options. I'd actually like to explore all three, but first I'd like to explore the first one. So how would I enable xp_Cmdshell and execute SSIS...