Below I will show you how to use the Surrogate Key transform that’s available from Task Factory. The Surrogate Key transform can be used to add a unique identifier column to your source data. From within this tool you can set the seed value (which is the starting value) and how it will increment. The values for the seed and increments can be entered in as a static text value or can be dynamically changed by using variables. Below I will show you the steps of how to use this simple but time...
Read More
Recently I heard some chatter about Report Parts. In this conversation I heard this, ‘Report Parts can only be published from within BIDS.’ Luckily for me I knew this to be false because I had just published a few Report Parts from report builder. Once you’re in the report builder and you have the (Chart, Image, Tablix, Etc.) that you want to publish as a Report Part Completed. All you have to do is click on the SQL Server logo on the top left hand of the screen and select ‘Publish Report Parts....