I'm in the middle of doing the explicit conversion within the SSIS package, but I'm unsure why there are differences between the two.

I did just learn the Oracle database is...

I'm unsure what the data types are on the actual Oracle tables since i don't have access to that piece, but I'm going to find out.

The view is being created...

Hi Mike,

Yes the datatypes immediately get switched from nvarchar to varchar.  I even dropped and recreated the view with the very same result.

From what I understand, the client is using...

I did and the port is open

Hi Henrico,

I forgot to mention within the original post that I've already made the necessary changes to the MsDtsSrvr.ini.xml file and restarted the service, but still receive the...

Thank you,

I just figured out that I didn't need to recreate the master key, back it up and copy it to the secondary machines because it was already there....

Hello Luis,

I need to divide using the DailyCount filed which is in the example below:

SUM(CASE WHEN BF_OFFER_CODE IS NOT NULL THEN 1 ELSE 0 END) 'DailyCount'

2014-07-21 00:00:00.000 ...

Thank you for your feedback Jonathan.

I'm going to conduct a series of tests today.

Pete

If you create this outside of msdb, you have to use certificate based security to sign the activation stored procedure as explained in this article:

Using a Certificate Signed Stored Procedure...

I'm also utilizing MSDB, my issue is the notifications aren't working for existing databases, even though service broker is enabled on these database. Doesn't make sense to me, but...

Thank you John,

I'll give it a try.

Pete

Hello Jonathan,

Thank you for providing this article. I have a question on how to add this functionality to an 'existing' database within my organization.

For instance, the code you provided...

Not always. Could be 1 (intra-query parallelism deadlock), or 3 processes or more.

Based on the wait type of e_waitPipeGetRow and the fact that the SPIDs are the same this one...