Maybe I wasn't specific enough and I apologize, but our DBA has already done those tasks. I guess the tasks that I've been asked of are Data Analysis/Reporting related tasks,...

Perfect. thx,

John

If by delimeter you mean backslash "\" after the name of the domain, then that's it. Otherwise, I'm lost.

John

Lynn and Bruce, unfortunately that doesn't give me the desired results. I'll just take the easy route and format it in RS.

thx,

John

I need to display the time when the subscription ran. For example; a subscription ran at 20:59:58 on 02-03-2009, which would be the value in field RunDate '2009-02-03 20:59:58.687'.

Also, please...

I apologize. Actually I need to pull the hh:mm:ss from the datetime field. The sample value is 2009-02-04 12:29:49.753

Hope this helps,

Thanks, that worked.

Another question:

I'm trying to add a Data Flow step to my package thru BI Studio, but can't seem to find the equivalent of sql 2000 Server Enterprise Manager...

Thanks CozyRoc. You're right; my knowledge of ssis is limited. Although I used to create dts packages in sql 2000.

I'll definitely follow up on your links and info.

John

Thanks for the info. Unfortunately I need to know how to get to step 1. Do I connect to integration svcs from sql mgmt studio, or do I use...

I had to be something that simple, right?

Thanks a lot, it's working now.

John

Thank you all for the valuable input and resources.

John

Thanks for the suggestion. I went with a different one though, creating a separate insert temp table w/an identity field and insert from it sequentially using this identity field. ...

I'll try both, thx.

select convert(datetime,getdate()) - Datepart(dw, convert(datetime,getdate())) + 8

I understand. The way suggested works just fine. I was just curious to know if it was possible to do this looking up GUID.

Regards,

John