Windows Phone 7 – Dynamically load XAML

Sometimes it is necessary to load an element like a shape dynamically from an file, resource or directly from a string into the corresponding API classes. In Silverlight for Windows Phone 7 this can be done with the use of the XamlReader Class. This class can be found in the System.Windows.Markup namespace. With the use…

0

Recursive delete procedure

The following procedure can be used in development systems to remove data from tables which are referenced by other tables. The procedure recursively follows all the references and deletes all referening tables first. Be careful, when you use it! All data of all referenced tables will be deleted. create procedure temp.RecursiveDelete(     @tablename nvarchar(1000)     ,@schemaname nvarchar(1000))as…

1

Programmatically add or modify a FlatFile-Source component

Intro   In the first article of this series I painted the high level picture and provided an overview of the package generation framework. In this and the following articles I want to show how to programmatically generate or modify specific SSIS components. FlatFile Source Component The first step is to find the connection manager…

1

Useful partition script

Retrieve filegroup by table name and partition range The following script can be used to retrieve the filegroup name for a given table and a partition range.  It can be very useful in an automated sliding window process. declare @tablename nvarchar(128) declare @range sql_variant   set @tablename = ‚myPartitionedTable‘ set @range = 1209   declare…

2

Accessing MS Reporting Services with Java

In this article I describe how to access Microsoft Reporting Services Web Service interface with a Java web service client. Microsoft Reporting Services MS Reporting Services (MSRS) provides its full functionality via two Web services endpoints. The WSDL for the endpoints are accessed using the following URL’s: http://<Server Name>/ReportServer/ReportService2005.asmx?wsdlhttp://<Server Name>/ReportServer/ReportExecution2005.asmx?wsdl The first on is the…


Creating SSIS Packages dynamically from template packages

Scenario In data warehouse projects it is often necessary to import a huge amount of data provided in CSV format into a database, without making essential structural changes to the source data format.   Possible requirements for this Extract Transform Load (ETL) processes are: –       Adding a BatchId to the imported records in the staging…

8