in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » SQL Server 2005 » SSIS - Integration Services (RSS)

Browse by Tags

  • How to downgrade Integration Services 2008 packages to 2005

    Courtesy of an unnamed source we have an app to downgrade a SSIS package from the 2008 version to 2005. Whilst it works with the common components any new components aren’t supported with the exception of the Lookup. 3rd party components are also not supported. It was gone through very limited testing...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Oct 21 2010

  • SSIS - XML Source Script

    The XML Source in SSIS is great if you have a 1 to 1 mapping between entity and table. You can do more complex mapping but it becomes very messy and won't perform. What other options do you have? The challenge with XML processing is to not need a huge amount of memory. I remember using the early...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Mar 11 2010

  • XML Validation in SQL Server Intergration Services

    I've been workig with XML in SQL Server Integration services this week and to say the XML task in SQL Server Integration services sucks is an understatement. Its buggy, the documentation is woefully inadequate in some cases wrong. I believe this was one of the first components written back for SQL...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Jan 20 2010

  • 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 of these values is to the second. When you've...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Sep 25 2007

  • 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 to learn and boy there is a lot to learn, SSIS has...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Jul 27 2007

  • 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 UI. If you were around at a SSIS presentation...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Jul 26 2007

  • 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 connect up error outputs to a destination to capture...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Jul 24 2007

  • 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 for your variables so you don't have to...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Jul 23 2007

  • SSIS - Parallel processing

    I remember seeing a very early CTP of Yukon and the new DTS. I was very exceited to see a parallel property on the loop container which would allow the contents of the container to be executed in parallel. If you've used the RTM on Yukon you will know that there is no such property. Unfortunately...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, May 15 2007

  • SSIS - Viewing packages in Management Studio

    Its odd how you often find things out by accident. Yesterday I was copying a dts package into a folder on my server and for some reason the drop didn't drop. When I then switched to management studio and XP finally decided to drop the file it did it in the management studio work space. At first I...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, May 11 2007
Page 1 of 2 (20 items) 1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems