SSIS package configuration

We have chosen to use a windows environment variable to hold the path to the *.dtsConfig, which is used to configure the *.dtsx package. – Close all open Microsoft Visual Studio 2005 instances (because changing windows environment variables will have nog effect) – Add a Windows Environment Variable: – start …

Remove ExpandedColunCount and ExpandedRowCount when using Microsoft Exel (*.xml) file as template

When you use a Microsoft Excel "*.xml" file as template for generating Microsoft Excel reports, remove the ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1" x:FullRows="1" from the <Table> tag under the <Worksheet> tag. If you don’t remove these counters a error will occur, because the row and or column count is higher then 1: …

Set text on control with javascript

To set the text on a control with javascript use:   /* Set the text value of the given element. This function assumes this document is defined and not null and has a function getElementById Used by: – */ function SetText(elementId, text) { // Check input values if(IsNullOrUndefined(document)){alert(‘SetText: Object [document] …

Change cursor to hand with CSS, when mouse over a column in a ASP .NET 2.0 GridView

When you want to change the cursor to a hand instead of the default pointer on mouse over, use CSS. In you’re gridview column: <Columns> <asp:TemplateField HeaderText=”Barcode”> <ItemTemplate><span class=”hand”><%# Eval(“Column”)%></span></ItemTemplate> </asp:TemplateField> </Columns> In the header: <style type=”text/css”>    .hand { cursor: pointer; cursor: hand; } /* cross browser hand */</style>   …