That's great news, thanks as1981.

If I may be a little bold, I suggest being careful to include the table name when referencing a column (tabusrTelephoneTemp.StaffID instead of...

Thanks as1981, I recommend trying to appropriate the examples in the Books Online article on PIVOT, first without the dynamic SQL clouding the issue.

If you could do with...

I believe you need to wrap your @query variable in brackets, as below. Without those, EXECUTE is looking for a stored procedure with the name of "select tabusrProductGroup.title,...".

I think your code is working as you need it to, it seems to convert "10/08/16" into a column of DT_DBDATE datatype, which be inserted into an SQL destination DATE...

You've got two result-sets there - SSRS will only read the first result-set and ignore the second. UNION ALL them to get the expected result, like below. Note the NULL...

bmg002's answer is my preference, as it's easiest to implement off-hand. 

It looks like you're not passing the output parameter to the executesql statement on the linked server, so...

Hi Dan,

I don't think it's possible to do the structure you're suggesting - if I understand things correctly, SQL doesn't behave the way you expect it to with...

Man, you guys are kind!

sgmunson, I had expected DATEADD and DATEDIFF to automagically use the parsed objects data type. Paying more careful attention, I can see it...

Yes, it's possible to create a batch file that starts an SSIS package via the DTEXEC executable, using the command option "/Parameter" to pass the relevant information as package parameters....

Thanks guys, I appreciate the advice. I went with adding a new record to the parent table (tblEmployee) with the new primary key value, updating all referencing column values to...

Could you please post your script transformation's code so we can see what you're doing to build the XML? You may also want to attach a data viewer to the...

I'm not sure what would be causing this. Here's some approaches I've used to troubleshoot similar situations: