Browse by Tags

Tagged Content List
  • Blog Post: Scripts and assembly caching in 2005

    A recent discussion with MVP Andy Leonard about a new property which showed up on the Script Task in SQL Server 2005 SP3 reminded me that I’ve been meaning to blog about how the script task and script component cache their precompiled code at runtime. This behavior has changed in every SP since 2005...
  • Blog Post: Read an RSS feed from SSIS

    The 3.5 .NET framework introduced a new SyndicationFeed class which simplifies the process of reading (and creating) RSS feeds . To try it out, I threw together a simple SSIS package which reads from an RSS feed using a Script Component.   Things to note: I have an Http Connection Manager, but I...
  • Blog Post: Accessing OLEDB Connection Managers in a Script

    Accessing ADO.Net Connection Managers from an SSIS script task / script component is pretty easy – you just need to cast the object returned from AcquireConnection() to the appropriate class (i.e. SqlConnection if you’re using SQL Native Client). SqlConnection conn = ( SqlConnection )Dts.Connections...
  • Blog Post: SSWUG Business Intelligence Virtual Conference

    I’ve been invited to speak at the SSWUG BI Virtual Conference in September. Like John Welch mentioned in his blog, the current speaker lineup is very impressive. I’m honored (and a little intimidated) to be on the presenters list! I’ll be flying out to Tucson in early September to record three SSIS related...
  • Blog Post: Upgrading scripts from early 2008 CTPs

    The February CTP has been out almost a month now, but just incase you hadn't checked it out yet, I thought I'd post a heads up. The February CTP introduced Visual Studio 2008 (Orcas), replacing Visual Studio 2005 as our Business Intelligence Designer Studio (BIDS).[ side note - why is it I always misspell...
  • Blog Post: Transfering a couple of tables at a time

    I missed some of the comments to my post about creating your own Transfer SQL Objects Task with a script task , so I thought I'd post the answer here incase people miss my answer. You can use the ObjectList property of the Transfer object to specify which database objects you want to transfer. To transfer...
  • Blog Post: Capture PRINT messages from a stored procedure

    I recently helped with a customer issue where they had a long running stored procedure which output status messages periodically using PRINT statements. They wanted to capture these statements and output them into the SSIS log. Unfortunately, the Execute SQL Task doesn't support this (it's something...
  • Blog Post: Select variables dialog

    A nice convenience feature in the new VSTA based script task is that we now provide a variable selection dialog for the ReadOnlyVariables and ReadWriteVariables properties. Ok, so there's not much content in this post. I admit it - this was just a reason for me to play around with some of the plug-ins...
  • Blog Post: Katmai - Script tasks which use the SSIS object model

    [ Edit: Note, this has been resolve in current Katmai CTPs ] You may run into issues in the current Katmai CTP if your script task uses objects contained within the ManagedDTS assembly. If you're interested in the details, keep reading - otherwise you can skip to the bottom for a possible work around...
  • Blog Post: Roll your own Transfer SQL Server Objects task

    Awhile back we went through a lot of customer feedback logged through the Connect site concerning the Transfer SQL Server Objects task. Some of these turned out to be bugs, but a lot of the reported issues stemmed from usability problems with the task itself. There's actually not that much to the task...
Page 1 of 1 (10 items)