Browse by Tags

All Tags » SSIS (RSS)

SSIS Nugget - from NULL to NULL but different datatype by MartinIsti

It's so simple yet I spent quite many painful minutes with that. The issue is that I have flat files to use as sources. They have 1 header row and 0 or more detail rows. Since I cannot divide the file in the connection manager for the header row ...
Filed under: , , ,

Data transfer into CRM databases with SSIS by MartinIsti

Last Friday I received a task of loading some information from a data source (which can be a SQL table, a flat file, an Excel sheet...) into a CRM database. It cannot be done directly most of the times so a web service is need to be used. Since Microsoft...
Filed under: , ,

NUMBER without Precision by MartinIsti

This week I experienced an annoying incompatibility between SQL Server 2005 and Oracle 9.2.2. If a column in Oracle has a NUMBER data type without explicitly set precision (like NUMBER(10)) then SSIS is not able to handle it when using an OLE DB Connection...
Filed under: , ,

Oracle DATE vs SQL DATE by MartinIsti

During the development of a simple (or so we thought ) SSIS task a strange error came up: we had a dbtimestamp column from Oracle which we had to load into a SQL Server ( 2005! ) table. It was a transaction date so by default there shouldn't have...

Books to read by MartinIsti

This post is mainly for fellow BI folks such as me who feel that they are only at the beginning of this road: First I show you what I've already read (or at least have learnt a lot from): The 70-445 Training Kit - it's a great book, teaches a...
Filed under: , , , , , , , ,

Little deployment utility (for DTUTIL) by MartinIsti

Today I did not want to use the package deployment wizard so I decided to automate a little our package deployment by using a batchfile with DTUTIL commands. I've created an Excel file with some expressions so the user just need to fill in some mandatory...
Filed under: , , ,

Package Deployment (SSIS 2005) - mainly MSDB-related by MartinIsti

Normal 0 21 false false false HU X-NONE X-NONE MicrosoftInternetExplorer4 I think SSIS's package deployment methods would need a little improvement. I hope some buglike features are fixed in 2008 but I haven't used that one yet. I set aside file...

Exam 70-445 by MartinIsti

It's a quite an exciting story for me As many of you might know Microsoft has a second shot offer that lets you try an exam once more free of charge. The current offer is valid until the end of this year and the 2nd exam can be taken until June 2009...
Filed under: , , , , ,

Multicast error by MartinIsti

Some months ago we began developing a simple way to log the lookup errors in our SSIS solution. First the following structure was created: As you can see the main pont of this method are the Multicast (to direct error rows into a log table (OLE DB Destination...
Filed under: ,

for starter ... by MartinIsti

How and why I started this blog...
Filed under: , ,
Powered by Community Server (Commercial Edition), by Telligent Systems