Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Script Task   (RSS)
Wednesday, June 17, 2009 10:18 AM

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.
Posted by mmasson | 2 Comments
Filed under:
Thursday, February 19, 2009 10:35 AM

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
Posted by mmasson | 1 Comments
Filed under:
Friday, August 22, 2008 4:05 PM

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
Posted by mmasson | 3 Comments
Wednesday, July 30, 2008 2:00 PM

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
Posted by mmasson | 1 Comments
Friday, March 21, 2008 9:44 PM

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
Posted by mmasson | 1 Comments
Filed under: ,
Wednesday, October 31, 2007 11:04 AM

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
Posted by mmasson | 1 Comments
Filed under: ,
Thursday, September 13, 2007 9:28 AM

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
Posted by mmasson | 5 Comments
Wednesday, June 06, 2007 11:46 AM

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
Posted by mmasson | 1 Comments
Filed under: ,
Tuesday, June 05, 2007 4:39 PM

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
Posted by mmasson | 2 Comments
Filed under: ,
Wednesday, April 18, 2007 4:08 PM

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
Posted by mmasson | 12 Comments
Filed under: , ,
 
Page view tracker