blogs.conchango.com

Browse by Tags

• best practice
• Checkpoints
• Conchango
• configurations
• connection manager
• Dataflow Task
• ExclusionGroup
• Expressions
• Foreach Loop
• katmai
• Microsoft
• Nugget
• ole db source adapter
• raw files
• regex
• regular expressions
• SQL Server
• SQL Server 2005
• sqL server 2008
• SQL Server Integration Services
• template
• Variables

• SSIS: How to use .Net assembly configuration files in the script task

  A couple of work colleagues had a problem when using SSIS yesterday which took a bit of working out so I thought I'd share it here, it'll be useful for anyone else that has the same problem. It was all to do with calling .Net assemblies (i.e. DLLs) from Read More... Posted 25 January 2008 23:59 by jamie.thomson | 9 Comments Filed under: SQL Server Integration Services, SSIS, Scripting

• SSIS Nugget: Output the number of processed rows

  Here's a handy little tip for when you are building custom destination components or script destination components that enables you to log the number of processed rows. Have you ever seen that handy little message that appears in your logs that tells Read More... Posted 03 July 2007 20:30 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task, Scripting, Nugget Attachment(s): JT OutputtingRowsProcessed.zip

• Katmai\SSIS: C# comes to the script task/component

  "Why the <insert your favourite expletive here> doesn't SSIS support C# for the script task and script component?" I've heard the above complaint, in various different ways, many many times over the past 18 months since SQL Server 2005 was released. Read More... Posted 09 June 2007 15:51 by jamie.thomson | 7 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, Microsoft, Scripting, katmai, sqL server 2008

• SSIS: Deprecated features in SQL Server Integration Services 2005

  Here's a useful page to keep an eye on: http://msdn2.microsoft.com/en-us/library/ms403408.aspx . It lists the current features within SSIS that will be disappearing in future versions and the strongest message I take from it is that you should upgrade Read More... Posted 09 March 2007 20:00 by jamie.thomson | 0 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SQL Server, Conchango, SSIS, Scripting

• SSIS: Output a file as a csv or an XML file

  Have you ever had the requirement to output data from a data-flow as a CSV file or an XML file where the choice is dependant on the file extension of your destination file? Well, David Bulog (also known by the pseudonymn " Mr Pro Tools ") has and he has Read More... Posted 11 July 2006 08:55 by jamie.thomson | 20 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task, Scripting Attachment(s): 20060711OutputAsXMLorCSV.zip

• SSIS: Sending SMTP mail from the Script Task

  I've noticed that alot of people have a need to send SMTP email from a script task rather than the SMTP Mail Task. A couple of the reasons for this are: HTML emails None-Windows authenticated SMTP servers neither of which are supported by the SMTP Mail Read More... Posted 03 July 2006 18:40 by jamie.thomson | 23 Comments Filed under: SQL Server Integration Services, SSIS, Scripting

• SSIS: Set Variable Task

  UPDATE: Only 2 hours after posting this and Josh has already told me about another one - a Compress File Task . He's a one-man SSIS custom task machine :) Josh Twist it seems has been bitten by the SSIS bug and is beginning to churn out some really useful Read More... Posted 16 June 2006 13:36 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SSIS, Scripting

• SSIS: Suggested Best Practices and naming conventions

  I thought it would be worth publishing a list of guidelines that I see as SSIS development best practices. These are my own opinions and are based upon my experience of using SSIS over the past 18 months. I am not saying you should take them as gospel Read More... Posted 05 January 2006 12:13 by jamie.thomson | 53 Comments Filed under: SQL Server Integration Services, SSIS, raw files, ole db source adapter, connection manager, Microsoft, Dataflow Task, Scripting, Expressions, best practice, configurations, Variables, Checkpoints, template

• SSIS: Throwing errors from script task/component

  I'm working on a project at the moment that entails making calls to external DLLs from within a script task or script component. In our case the DLL in question is a web service proxy and we've been having numerous problems getting it to work. Being able Read More... Posted 03 November 2005 15:35 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SSIS, Scripting

• SSIS Nugget: Verify a data source before using it

  As some of you may know I've been writing about SSIS on this blog for a lon-n-n-n-n-g time now. Too long it seems sometimes. In all that time though I've only had one short client engagement using the product which means that my real-world experience Read More... Posted 10 October 2005 20:04 by jamie.thomson | 11 Comments Filed under: SQL Server Integration Services, SSIS, connection manager, Scripting, Nugget

• SSIS: Reusing script components

  The SSIS script component rocks, don't you think? I think I might have made this point before on 4 or 5, possibly a few hundred, occasions. The ability it gives you to incorporate the power of the .Net framework and your own assemblies into the SSIS pipeline Read More... Posted 07 September 2005 19:47 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task, Scripting

• SSIS Nugget: Multiple outputs from a synchronous script transform

  It is generally accepted that a synchronous script component outputs the same number of rows as are input. Well I have news for you, this doesn't have to be the case. If you have a synchronous script component with multiple outputs then you can choose Read More... Posted 05 September 2005 09:43 by jamie.thomson | 18 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task, Scripting, ExclusionGroup, Nugget

• SSIS: How to differentiate between identically named variables with different scope

  I'm having trouble with an aspect of SSIS and I'm not getting much joy in solving it from the SSIS forum so I'm going to post it up here instead on the off-chance that someone can help. I have a task and I want to get its execution duration by finding Read More... Posted 18 August 2005 20:15 by jamie.thomson | 5 Comments Filed under: SQL Server Integration Services, SSIS, Scripting

• SSIS: Script tasks and running packages from a SQL Server Agent job

  Here's a little titbit that I found out today. If you have a script task in your package that has PreCompileScriptIntoBinaryCode=FALSE and you then run the package from a SQL Server Agent job then the job step will fail with: "The script files failed Read More... Posted 08 August 2005 22:54 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS, Scripting

• SSIS Nugget: The difference between synchronous and asynchronous script components

  UPDATE: Check out kdog's useful comments at the bottom as well! Script components can either be synchronous or asynchronous. There are a number of definitions about the difference between the two including a description that I posted back in February. Read More... Posted 25 July 2005 12:24 by jamie.thomson | 4 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task, Scripting, Nugget