This problem occurs when we try to import an Excel file. All values of a column are returned in SSIS as null values but in the document we had values.
The problem is due to the provider : the provider calculate the data type of a column by analysing the first lines of the document.
The solution is to modify the ConnectionString property of the ExcelConnection component (add IMEX=1)
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\data\maroc\import.xls; Extended Properties="EXCEL 8.0;HDR=YES;IMEX=1;"
IMEX=1: indicates the provider to convert data, in multitype columns, to text values.
SEE :http://support.microsoft.com/kb/194124/en-us
jeudi 27 septembre 2007
Building ClickOnce application from the command line(Without VS2005)
I was looking for an alternative to use VS 2005 for publishing an application, And I found that MSBuild allow us to do that. the solution consists of using the .csproj file generated by visual studio and this command line : msbuild /target:publish.
A detailed explanation is available here : Building ClickOnce Applications from the Command Line
A detailed explanation is available here : Building ClickOnce Applications from the Command Line
mardi 18 septembre 2007
Nouveauté du framework 2.0
ayant travailler essentiellement sur .Net 2.0, je ne pouvais pas répondre à cette question qui est souvent posé lors des entretient d'ambauche : quelles sont les nouvautés du framework 2.0 ?
Des éléments de réponses sont disponible à cette adresse :
Les nouveautés du framework 2.0
Des éléments de réponses sont disponible à cette adresse :
Les nouveautés du framework 2.0
lundi 17 septembre 2007
Welcome to .Net Generation
In this blog you will find essentially, technical postes about .Net technologies.
Inscription à :
Commentaires (Atom)