Welcome to EMC Consulting Blogs

January 2006 - Posts

• 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