SSIS - Integration Services - SimonS Blog on SQL Server Stuff

Browse by Tags

All Tags » SSIS - Integration Services (RSS)
04 December 2007 22:58

Installing Visual Studio 2008 and SQL Server 2005

If you are upgrading to Visual Studio 2008 then be careful with SQL Server. You may or may not know that the Business Intelligence Development Studio (BIDS) is a visual studio shell. If you don't have Visual Studio installed when you install SQL Server...
Posted by simonsabin | with no comments
Filed under: , , ,
16 November 2007 13:35

SSIS Pipeline - Katmai changes - Reusing data

Katmai increases the concurrency of SSIS packages by a change to the pipeline. In SQL 2005 a dataflow is split into sections, This is called the execution tree. Each section has the same buffer strucuture and the buffers are passed to each component in...
Posted by simonsabin | with no comments
Filed under: ,
06 November 2007 14:43

What application doesn't have UNDO in today's world

Well the first that is close to my heart is Integration Services and its really annoying. I tried to track down a connect item for this but couldn't find a specific one. So I raised one https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx...
Posted by simonsabin | with no comments
Filed under: , , , ,
06 November 2007 10:45

SSIS - Change your GUIDs

Did you know that your package has an identifier in it? Well it does and it can be used to provide automated reporting of your package executions. Using the eventhandlers you can log information to a central store to provide easy reporting. The key for...
Posted by simonsabin | with no comments
Filed under: ,
29 October 2007 22:04

SSIS - Maintenance Plan Tasks

In using SSIS you will have noticed a section in the toolbox labelled Maintenance Plan Tasks. You will have seen in there tasks like "Execute SQL Task". You may be tempted to use these in your package. DON'T These are tasks that are designed to be used...
Posted by simonsabin | 1 comment(s)
Filed under: ,
25 October 2007 18:03

SSIS - Class not registered (0x80040154) Excel Source

Just a quick note that if you are developing SSIS packages with Excel on a 64 bit machine you need to make sure the package is configured to not use 64bit runtime. There are no 64bit Excel drivers (Jet) and so whilst you code works in the desiger, i.e...
Posted by simonsabin | with no comments
Filed under: ,
25 October 2007 17:48

SSIS - Testing the source in your data flow

When building an SSIS package, which I seem to be doing more and more of lately, I am invariably using a data flow. Whilst the data flows often end up with complicated transforms in them my approach to building it is very much bit by bit. The first step...
Posted by simonsabin | with no comments
Filed under: ,
25 September 2007 22:01

SSIS change to pipeline for custom components

If you've written your own custom components then you should read this post on the SSIS forum about a possible change to the pipeline that may affect your component. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2190281&SiteID=1&mode=1...
Posted by simonsabin | with no comments
Filed under:
25 September 2007 21:33

SSIS Dates aren't very precise

I'm implementing some SSIS packages at the moment and started looking at logging with the event handlers. I simply wanted task start and end times etc and so used the start time system variables. What I noticed when I ran reports was that the accuracy...
Posted by simonsabin | 1 comment(s)
Filed under: , ,
27 July 2007 23:08

SSIS - What is wrong with it

I recently visited a client that was achieving wonders with DTS, I was there to give them pointers on SSIS. I spent a day gogin over SSIS from the control flow to configrations. A couple of things really got me was that SSIS is a new world that youhave...
Posted by simonsabin | with no comments
Filed under: , ,
26 July 2007 23:17

SSIS - Enhanced Error Component

For those that downloaded the enhanced error component I forgot to make it clear that the new version requires you to have service pack 1 installed. The reason being is that we are using an interface that allows us to look at the whol package in the component...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,
24 July 2007 08:25

SSIS - Error outputs should you configure them

Should you connect configure error outputs for your components in a data flow? I'm putting a SSIS crib sheet together I asked Jamie Thomson to have a look over it and one point he question was my statement on error outputs. My view is that you should...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,
23 July 2007 22:03

SSIS - Variable lists for the script task are case sensitive

I've just been tearing my hair out trying to get variables and locking working. It was only after one of those eureka moments that I realised that the variable names are case sensitive. So the lesson learnt is make sure that you have a naming convention...
Posted by simonsabin | with no comments
Filed under: , ,
23 July 2007 21:10

SSIS - 64 Bit woes

I am starting to regret installing 64 bit vista on my laptop, my woes are continuing as I found out today I can't debug script tasks. I do hope this is fixed in Katmai :) The full limitations, and there are a few, can be found here http://msdn2.microsoft...
Posted by simonsabin | 2 comment(s)
Filed under: , ,
02 July 2007 21:36

SSIS : Web Service task doesn't cut it but who cares

18 months ago I was trying to use the SSIS web service task for a number of purposes. The first was to integrate with SalesForce, the second was to manage reporting services. Unfortunately the Integration Services (SSIS) web service task doesn't work...
Posted by simonsabin | with no comments
Filed under: , , , ,
More Posts Next page »