blogs.conchango.com

Browse by Tags

• containers
• Dataflow Task
• Execute SQL Task
• Expressions
• Inane Waffle
• Microsoft
• Nugget
• ole db source adapter
• raw files
• Scripting
• SQL Server Integration Services
• Variables

• SSIS: Initialise variables the easy way

  Its possible that at some point when building SSIS packages that you will want to initialise a variable with some value at execution time and the most obvious way of doing this is to use a script task. That code would look something like the following: Read More... Posted 09 September 2008 19:58 by jamie.thomson | 5 Comments Filed under: SQL Server Integration Services, SSIS, Scripting, Variables, Foreach Loop

• SSIS: Deleting a group of files

  A question I quite often see on the SSIS forum is: Is there a way to delete a group of files within a directory? ie: I want to delete all files in directorty c:\logs\*.txt ( http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3196521&SiteID=1 ) Read More... Posted 17 April 2008 22:38 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, Foreach Loop

• SSIS: Put a package to sleep

  A question was recently asked on the SSIS forum about how you can put a package "to sleep". In other words, pause execution for a defined length of time. It was suggested to use a script task to do this. That would definately work but there Read More... Posted 23 October 2006 22:28 by jamie.thomson | 14 Comments Filed under: SQL Server Integration Services, SSIS, Foreach Loop

• SSIS: Processing data from multiple files all at once

  Quite often you may want to process data from multiple files all at the same time. There are a number of options available to you if you want to do this. 1. Have a seperate source adapter for each file and amalgamate them together with the Union All component. Read More... Posted 14 October 2006 17:54 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SSIS, raw files, Dataflow Task, Foreach Loop

• SSIS: Expressions on ForEach enumerators

  I've noticed a few people on the SSIS forum lately asking about expressions on the Foreach Loop. They are aware that its possible to set expressions on properties of the Foreach container but are flummoxed when it comes to setting expressions on the Read More... Posted 13 October 2006 22:35 by jamie.thomson | 28 Comments Filed under: SQL Server Integration Services, SSIS, Expressions, Foreach Loop

• SSIS: Append to a raw file

  I have just arrived home from an excellent BI-flavoured meeting of Tony Rogerson's UK SQL Server User Group . Aside from some great content the thing I love about these events is the change to meet up with people from around the BI community - people Read More... Posted 22 June 2006 23:42 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SSIS, raw files, Foreach Loop Attachment(s): 20060622AppendToARawFile.zip

• SSIS Nugget: Setting expressions

  Whilst reading posts on the SSIS forum of late it has become evident that people are unaware of the power that expressions can provide within an SSIS package. This is understandable - alot of people are starting to use SSIS now but expressions aren't Read More... Posted 11 March 2006 09:24 by jamie.thomson | 30 Comments Filed under: SQL Server Integration Services, SSIS, raw files, Expressions, Foreach Loop, Nugget

• SSIS: Caching result sets for re-use in a ForEach loop

  Peter (sorry, don't know your surname) made a very good comment here: http://blogs.conchango.com/jamiethomson/archive/2006/02/20/2895.aspx#2903 that data-flows in a ForEach loop carry out repeated SELECTs against a data source and it would be good to Read More... Posted 20 February 2006 17:08 by jamie.thomson | 1 Comments Filed under: SQL Server Integration Services, SSIS, raw files, ole db source adapter, Foreach Loop

• SSIS Nugget: Execute SQL Task into an object variable - Shred it with a Foreach loop

  Here is the first in what will hopefully be a long series of postings in what I have colloquially called my SSIS Nuggets series. I was reading a post this morning from Sam Bendayan in which he was pondering how to store a full result set returned from Read More... Posted 04 July 2005 09:55 by jamie.thomson | 43 Comments Filed under: SQL Server Integration Services, SSIS, Execute SQL Task, Foreach Loop, Nugget

• SSIS: Getting a value out of a file to use it in our package

  Someone recently asked on a newsgroup how they could grab hold of a value from a given field in the last row of a file. For example, in the file depicted below we would like to grab the value "Posh". I figured this might be a fairly common requirement Read More... Posted 15 June 2005 22:21 by jamie.thomson | 4 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task, Foreach Loop

• SSIS: Enumerating files in a Foreach loop

  I've just got back from a Charlatans gig at Hammersmith Palais in London. Anyone that knows me will tell you that I'm a massive massive Charlatans fan so I've had a great night. They played alot of stuff from earlier albums like "With No Shoes" from Tellin' Read More... Posted 30 May 2005 00:59 by jamie.thomson | 45 Comments Filed under: SQL Server Integration Services, Inane Waffle, SSIS, Foreach Loop

• SSIS: Accessing a recordset in a script task

  UPDATE 2006-03-14: This information in this post should now be disregarded. Read here: http://blogs.conchango.com/jamiethomson/archive/2006/01/04/2540.aspx instead! It is possible to populate an SSIS variable of type "Object" with a recordset using the Read More... Posted 08 February 2005 23:13 by jamie.thomson | 14 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task, Scripting, Foreach Loop

• SSIS: Containers

  DTS 2000 packages contained a hierarchical view of a package known as the DTS object model . The replacement for DTS, SQL Server Integration Services, has a similar concept of a package being represented as a hierarchy but it is not as rigid as before. Read More... Posted 13 December 2004 15:05 by jamie.thomson | 35 Comments Filed under: SQL Server Integration Services, SSIS, containers, Foreach Loop