It would help if you presented a representation of your recordset ... what you have... and what you want the final output to look like. As I see it you...

Start by right clicking the detail row and select to add a parent group. In the popup dialogue you select the column to group by and if you want to...

Note that in your dataflow, click the green arrow and see that you can add a data watcher. You'll see the data as it flows from the source and BEFORE...

Very awesome. I'll try it out, Thanks!

Else, I found out the ssis package first import the data into a table that has raw data, meaning no constraints defined, then import from raw table to the real...

You have to touch everything that depends on that data stream so that it knows what to do with that new column.

SSIS has an XML source and XML task. THe XML task can validate your data, merge it with another xml set and even do comparisons between the sets (You would...

Hi,

What provider did you use when creating your link?

Not sure if this is still an issue for you... other options are using the fast load option in a OLE DB destination. Not sure if there are constraints on...

I would be interested in seeing the solution.

Wouldn't "SELECT CURRENT_USER, ORIGINAL_LOGIN(), SESSION_USER, USER, USER_NAME(), SYSTEM_USER" return the general user account ? If this is a scheduled job created...

You would need a helper dataset query that went something like :IF (@client=1)

begin

select @datefrom = dateadd(m, -6, getdate() )

You pass the results to the master dataset ...

My advise here is to build a more general stored procedure that brings in all the columns you need at a granular (lowest common factor) level. I assume you mean...

Was this message the result of a server trigger, has this been ruled out? To remove permissions, one would employ the REVOKE command.

Try the default trace to see what ran prior to your reboot.

https://www.simple-talk.com/sql/performance/the-default-trace-in-sql-server---the-power-of-performance-and-security-auditing/

One thing that slows things down is casting in the where clause. I see this in query 2.

plus I also see in the WHERE clause -->

Entitlement.EntitlementId IS NULL ...