blogs.conchango.com

Browse by Tags

• .Net 2.0
• SQL Server 2005
• SQL Server Integration Services

• SSIS Creating Synchronous Transform Component

  Do you need to write a custom component to transform input data, and disregard this input data, instead, replacing it? That's was what I needed to accomplish with my component. It takes data from the input buffer and performs a lookup via an external Read More... Posted 14 March 2006 14:28 by steve.wright | 0 Comments Filed under: .Net 2.0, SQL Server Integration Services, SSIS

• SSIS File handle leak in For Each Loop

  I am currently working on a project which needs to load over a 1000 xml files. The files are stored across 10 subfolders. I am using a foreach loop with a file enumerator, which is configured at the top of the folder structure and traverses the subfolders. Read More... Posted 02 March 2006 16:57 by steve.wright | 0 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS Connection Object and Expressions

  I have been writing a custom source adapter that uses a file connection within the connection manager. If I hard-code a specific file then the component works. However if I use a file connection that has an expression defined which updates the connection, Read More... Posted 22 February 2006 17:49 by steve.wright | 0 Comments Filed under: .Net 2.0, SQL Server Integration Services, SSIS

• SSIS Changes Database Settings

  I have a SSIS package with a simple data flow task, which takes data from a flat file and loads it to an OLE-DB destination (which is configured to use Native OLE-DB\Native Client). As I ran the package via the command-line I noticed that SSIS made changes Read More... Posted 09 February 2006 14:50 by steve.wright | 0 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SSIS

• SSIS Variable Deadlock

  I have noticed a problem with the script task within SSIS. The problem occurs when a script task encounters an error and the SSIS on-error event also has a script task that uses a variable that is being locked by the script task that raised the error. Read More... Posted 09 February 2006 14:50 by steve.wright | 2 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS Execute SQL Task With VARCHAR(MAX)

  While I was using the SSIS Execute SQL Task to return a single row result I getting the following error: [Execute SQL Task] Error: An error occurred while assigning a value to variable "RestoreCmd": "The type of the value being assigned Read More... Posted 20 January 2006 17:41 by steve.wright | 1 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS XML Task / Source Adapter

  I have been working with SSIS using the XML Task and XML Source Adapter. I was getting an error say that an element is was not defined. When I check the XSD, which was using import / include schemas, I found the element was difined but not in the main Read More... Posted 20 January 2006 17:38 by steve.wright | 0 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS 2005 and Database Snapshots

  I have been looking into the feasibility of using database snapshots as method of rolling back an SSIS package that fails and this is what I found: Creating a database snapshot was not a real problem, there is one issue that you need to be aware of. For Read More... Posted 20 January 2006 13:26 by steve.wright | 0 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SSIS