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 > Control Panel > System > Advanced system settings > Environment Variables > New…

– Variable name: SSISPackage_Configuration

– Variable value: C:\Temp\SSISPackage.dtsConfig

– Click on [OK]

– Click on [OK]

 

– Open the Microsoft Visual Studio 2005 solution containing the SSIS project.

– Open the *.dtsx

– Click in the top menu on SSIS > Package Configurations …

– Check the Enable package configurations

image

– Click on Add …

image

image

image

When you start debugging the SSIS package in Microsoft Visual Studio 2005, the configuration will be red from the C:\Temp\SSISPackage.dtsConfig.

In production you can change the path of the environment variable and the configuration will then be red from that location.

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:

Problem During Load
Problems came up in the following areas during load:
Worksheet Setting
This file cannot be opened because of errors. Erros are listed in C:\Users……\Content.MSO\7BF935F6.log

 

<Worksheet ss:Name="Sheet3">
  <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1" x:FullRows="1">
  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
</Worksheet>

 

An other error that can occur is:

XML ERROR in Table
REASON:    Bad Value
FILE:    C:\Temp\MyTest.xml
GROUP:    Table
TAG:    Row
ATTRIB:    Index
VALUE:    128

 

This was caused by the line:

<ss:Row ss:Index="128" ss:AutoFitHeight="0" ss:Height="12.9375">

Cause and solution

The index was not correct, by removing the ss:Index="128" ss:AutoFitHeight="0" ss:Height="12.9375" from the Row tag, the file could be opened correctly again.

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] is null or undefined');}
    if(IsNullOrUndefined(elementId)){alert('SetText: Object [elementId] is null or undefined');}
    if(IsNullOrUndefined(text)){text = '';}

    // Get the given element by id
    var resultGetElementById = document.getElementById(elementId);
    if(IsNullOrUndefined(resultGetElementById)){alert('SetText: Object [resultGetElementById] is null or undefined');}

    // Check if the firstChild is null or undefined
    if(IsNullOrUndefined(resultGetElementById.firstChild))
    {
        // Element does not have a first node, add an textnode.
        resultGetElementById.appendChild(document.createTextNode(text));
    }
    else
    {
        // Element has a first childe node, so replace it's text value.
        resultGetElementById.firstChild.nodeValue = text;
    }
}

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>