Hey Myles - I've tried to run a Profiler trace on the database to see what parameters are being passed - but I am not a member of of the...

Thanks for the reply. The solution I've gone with is to use a PowerShell script and call this through a process task in SSIS and it seems to work...

Thanks pietlinden,

I used your query - except for the ROW_NUMBER in the WHERE clause - got an error about Windowed functions can only appear in the SELECT or ORDER BY...

Thanks again for the replies. I'm back from PTO and trying to tackle this problem once again.

In regards ROWSCANS or HASH, is that created on a view as well? ...

Thanks to both replies.

I'm not sure what a CDC is?

The Oracle table does have a mod_date so that might be the column to key off of. Could you explain...

Hey Martin,

Turns out I need the SQL 2014 connectors:

And it works.

Thanks for your help however.

Hey Martin,

I don't see them listed under COM but if I open SQL Sever Data Tools (using Visual Studio 2010 Shell) - the Attunity connectors are there and I can...

Hey Martin,

According to Attunity's documentation, a 64-bit connector installs both the X86 (32-bit) and X64 (64-bit) DLLS.

Unfortunately, I cannot manually add the items. Looks like this feature might have been...

That worked beautifully. Thank you very much!

Thanks mr. magoo,

It does look better with this solution, but there is still one issue happening. If the incentive doesn't appear in the first column, the cell background colors are...

Thank you very much Sarah.

First time creating a report like this with a Detail section. Frustrating but I made it through with your advice and the report looks like...

Hey Sarah,

I've gone back and created a new table and placed the summary information in the group header lines so it only appears once. Screenshots below so the table setup...

Thanks Sarah, I was able to accomplish this by doing what you suggeted.

Hey Koen,

The actual report has more columns, but the issue would remain the same and I hid those for posting purposes. Would you be able (or willing) to guide...

Thanks, I'll read that article on STUFF now to try and understand.