Applying the VMWare KB fix worked for us: http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1012225

thank you..

Researching this potential resolution now:

http://www.sqlservercentral.com/Forums/Topic1300021-2799-2.aspx#bm1395349

Solution: I changed the ORDER BY / COLLATE statement to:

order by wpcnt COLLATE...

Execution plan (when COLLATE is commented out) shows 99% of work being done as TABLE SCAN on table tmp_DST_DOR_Activity_Table_raw_data_wtg w/ 243k rows in it...

Execution plan fails when I UN-comment...

One finding.. when I started up my SQL Server 2008 R2 Developer edition SSMS, I was then able to connect to my registered Integration Services server which is also SQL...

just found this: http://weblogs.sqlteam.com/jamesw/archive/2010/08/04/datatypes-translation-between-oracle-and-sql-server-part-2-number.aspx

Oracle allows numbers to be defined with a scale greater than the precision, such as NUMBER(4,5), but SQL Server requires the precision to be...

I've coded a process to DELETE rows > 13 months old. The date in the SQL table is first populated (replicated) from an older Oracle db w/...

PERFECT! Exactly what I was looking for.. thanks a million.

1 correction (I mis-typed the date needed value above)

If today is June 1, 2012, I need 05/01/2011

thx Phil.. I wound up doing the following to resolve the issue:

Reviewed Microsoft recommendation on this issue: "Configure a Report Server for E-Mail Delivery (Reporting Services)"

http://msdn.microsoft.com/en-us/library/ms159155.aspx -- Configuration...

We have the same issue. Anyone no why the "To:" box is greyed out / protected when the user is in the BROWSER role?

Unfortunately, we cannot change the target Oracle legacy system. Wish we could.

Does SSIS have a data conversion rule that will accomodate this target data type?

thanks

thanks Peter. I will review these. Much appreciated.

I have a similar need here - Is there a way to get:

- a list of ALL reports on the Report Server (we have SSRS 2008)

- the last time each...

yes, I replaced myname w/ my account..

Not sure about the Roaming attribute.. need to check that