Random thoughts

The SSIS package template can contain Log Provider, Log Task, Control Flow Task, Common SQL Task, Data Flow Element and Event Handler and Connection manager etc. Open the SSIS Package design the package that is required in the template (All the common task and variable that should be present in every package as initial setup requirement. So further you need not to do the same task. You can directly add to the template in you project and get all the settings. Once your designing of Template package is done click on -> File menu -> Save Copy of File name as. Save copy of File Dialog box appear -> Select Package Location : File System -> Browse the location to save the package. The location of Template file is drive:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\DataTransformationProject\DataTransformationItems and type the name of the template. Save Source: How to create a package template in SQL Server Business Intelligence Development St...

Open Report Manager and locate the Report Model folder Select the report model that you want to update and click on the hand sign to edit the model (this view will be appearing only after selection “Show Detail” from report manager toolbar. By default general tab is selected ->inside the model definition “Update” link is available click on this link. Browse File page will be appear click on the browse button to locate the report model file -> OK You will be return back to the main page click on the apply button to apply the changes. Now your report model has been updated.

Once you have design the report model and build the project this is the time to deploy on production environment. Similar to Report deployment if you will specify the Report Server and the folder name where your want to deploy the project and deploy; Visual studio environment deploy the project on the report server. But in case it is not possible then have to deploy the Report model through Report Manager Web application (using upload feature of web manager). Connect to the Target server -> Open Report Manager -> Locate the folder where you want to deploy the Report Model -> Click on Upload File Button of Report Manager Locate the Report Model (.smdl) file and click Ok. It will deploy the file on the server. Wait a minute are you getting a problem “ The DataSourceView is missing for the SemanticModel ” or something it just because of data source view is not available. The data source view and report model are the xml based file so you need to merge the both file (.smdl and .ds...

Some time we required to represent the data in Columnar form where as SQL is generating in Row form. I got a solution to convert rows into column. I hope It will help you out. The data is available in this format Month Status Count ===== ====== ===== April I 129 April O 4689 April S 6 July I 131 July O 4838 July S 8 June I 131 June O 4837 But, I need the same result set as below Month I O S ===== = = = April 129 4689 6 July 131 4838 8 June 131 4837 8 Solution select [Month], max(case when [Status]='I' then [Count] end) as I, max(case when [Status]='O' then [Count] end) as O, max(case when [Status]='S' then [Count] end) as S from mytable group by [Month] order by [Month] Referenced by MSDN forums : http://forums.microsoft...