hi, I'm getting this error while running the script: Msg 8152, Level 16, State 2, Line 23 String or binary data would be truncated.

I enlarged the column Included_columns...

hi Tom, I have a work-around using BI Express from Pragmatic Works. No problems there.

I was also using indirect configuration (the Metadata connection in the XML and all of...

Thanks Phil. I'm trying to move my packages "as is" from SQL2008R2 to SQL2014. I will dive into the project deployment model. It is new to me.

As for my question,...

Hi Wilfred, there is a small typo in the code; in the select ... full_windows_name from ... cte one quote ( ' ) is used instead of two ( ...

hi, the solution didn't work for me though I had the same error. What I found was that the SQL Connections (in BIDS) can not contain spaces when processed via...