Another BI & Programming Blog - Jason Yousef

Let's talk dynamic - SSIS variables and expressions So yesterday I was honrored to speak before the NJSQL group about "SSIS variables and expressions" I do apologize for my lengthy presentation as I went so deep into small details... but I was just trying to go with the flow, and naswering the questions... I've attached a RAR file,  containing the slide deck  along with the demo scripts.  I hope you get as much out of SQL Server as I have, and Thanks for coming! The slides can downloaded from https://www.box.com/s/9lvnf2cy3mdbluy8ykqo

Today I was facing a client's problem in SSRS to edit the comments text for over 120 reports to point to a server name (Host Name) instead of IP, to begin with, it was a bad idea and judgment from the person who created the report. and secondly it's rarely to see a server that gets an IP change too! But the two issues could happen and it's ok, let's face it and fix it. Here's a screen shot, If you're not familiar with the subscription comments. To locate it, just navigate to SQL server management studio (SSMS), and browse the : [ReportServer].[dbo].[Subscriptions] Table the column that has the comments is [ExtensionSettings] just replace the text using your T-SQL query and you're done! the data type of that column in nText, so it won't with T-SQL replace function. so you might use... UPDATE   S    SET     S.ExtensionSettings = T.ExtensionSettings    FROM [ReportServer].[dbo].[Subscriptions]...