blogs.conchango.com

Browse by Tags

• Conchango
• connection manager
• Dataflow Task
• Datareader source adapter
• DTS
• lookup
• memory usage
• Microsoft
• Nugget
• ole db source adapter
• regex
• regular expressions
• RetainSameConnection
• Scripting
• SP2
• SQL
• SQL Server
• SQL Server Analysis Services
• ssas
• SSIS
• stored procedures

• 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: Service Pack 2 improvements

  For those of you interested in what's new in SSIS in service pack 2, here are a couple of resources: New Features: http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/WhatsNewSQL2005SP2.htm#BKMK_IntegrationServices Bug Read More... Posted 08 February 2007 04:48 by jamie.thomson | 0 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SSIS, Microsoft, SP2

• SSIS: Connectivity whitepaper

  In case you hadn't picked this up on the grapevine already, Microsoft and Bob Beauchemin SQL Skills have jointly released a whitepaper that talks about connectivity issues that you may come across in SSIS. Check it out here: http://ssis.wik.is/Connectivity_White_Paper Read More... Posted 23 January 2007 04:34 by jamie.thomson | 0 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SSIS, connection manager, Microsoft

• SSIS is "Best ETL Software" (according to someone)

  I have just received an email from Donald Farmer , Group Program Manager for SSIS, who took great delight in telling me that his product has claimed the title of "Best ETL Software" in the Techweb Readers' Choice Awards . I don't usually Read More... Posted 06 January 2007 07:17 by jamie.thomson | 0 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SQL, SSIS

• SSIS: But it used to work in DTS (10) - Use multiple connection objects in order to maintain seperate connections to databases

  Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS. Use multiple connection objects in order to maintain seperate connections to a database It was commonly recommended in DTS that a package should Read More... Posted 21 December 2006 19:11 by jamie.thomson | 1 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SQL Server, SQL, SSIS, connection manager, RetainSameConnection, DTS

• SSIS: Using stored procedures inside an OLE DB Source component

  Many people like to use stored procedures as the source of data for the SSIS pipeline. In theory there is nothing wrong with that however it does have its complications. Depending on the way the stored procedure is written, it may or may not be suitable Read More... Posted 20 December 2006 13:24 by jamie.thomson | 33 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SQL Server, SQL, SSIS, ole db source adapter, stored procedures

• SSIS Nugget: Extract last word from a sentance using regular expressions

  About a month ago I wrote this very simple blog post explaining how one might go about stripping off the last word from a sentance in the pipeline. My Conchango colleague James Saull thought that this would be ripe for a regular expression (and he's Read More... Posted 19 December 2006 08:45 by jamie.thomson | 1 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SQL, SSIS, regex, regular expressions, Nugget Attachment(s): 20061219lastWordUsingRegex.zip

• SSIS: Checking if a row exists and if it does, has it changed?

  I've been writing about SSIS for quite some time now and probably one of the more popular articles post I have written is this one: Get all from Table A that isn't in Table B ( http://www.sqlis.com/default.aspx?311 ) which I wrote way back in Read More... Posted 12 September 2006 21:31 by jamie.thomson | 96 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SSIS, Dataflow Task, lookup Attachment(s): UpdateAndInsert.zip

• SSIS: Rank Transform

  With the advent of SQL Server 2005, Microsoft provided three new T-SQL windowing functions that will turn out to be highly beneficial to T-SQL developers. They are: ROW_NUMBER (Which I have talked about previously here ) RANK DENSE_RANK It occurred to Read More... Posted 12 September 2006 13:36 by jamie.thomson | 5 Comments Filed under: SQL Server 2005, SQL Server Integration Services, Conchango, SSIS, Dataflow Task Attachment(s): RankTransform.zip

• SSIS: Webcast: How to use the DataReader Source and the OLE DB Source objects in SQL Server 2005 Integration Services

  Just a short note to tell you about a webcast that is coming up on 25th October 2006. "How to use the DataReader Source and the OLE DB Source objects in SQL Server 2005 Integration Services" The subject matter will be (it says 'ere): This Read More... Posted 06 September 2006 20:54 by jamie.thomson | 0 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SSIS, ole db source adapter, Datareader source adapter, Dataflow Task

• Changing system tables and INFORMATION_SCHEMA views

  We all know what system tables are right? They are the tables within the master database that hold the metadata of all the objects stored in our SQL Server. In SQL2005 an extra set of views called the sys views has been provided on top of the system tables Read More... Posted 06 September 2006 20:43 by jamie.thomson | 2 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SSIS, Nugget

• SSIS: Import/Export wizard warning

  Just lately I have been making heavy use of the Import/Export wizard in SQL Server Management Studio and on the whole I'm very pleased with it. I have though come across one problem with it that caused me no end of trouble before I discovered what was Read More... Posted 29 August 2006 15:30 by jamie.thomson | 2 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SSIS

• Interesting reads

  If you're interested in BI solutions on the Microsoft platform and you have nothing better to do then you could do worse than readig a couple of whitepapers that I have recently encountered: ETL Performance: Unisys and Microsoft SQL Server Speed Up The Read More... Posted 09 April 2006 11:29 by jamie.thomson | 2 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SQL Server Analysis Services, SSIS, ssas

• Connectionstrings.com - worth a bookmark

  For all you data integration pros out there, its worth bringing your attention toa site I've just come across - Connectionstrings.com . In short, it shows you how to build connection strings for many heterogeneous data sources when accessed using one Read More... Posted 28 February 2006 22:53 by jamie.thomson | 0 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SQL Server, SSIS

• SSIS: SQL Documenter

  According to the good Mr Haselden Microsoft are going to be bring out a tool called "SQL Documenter" that will traverse SQL Server objects and servers and then build operational metadata reports (RS reports one would hope) based on what it finds. And, Read More... Posted 14 September 2005 21:37 by jamie.thomson | 0 Comments Filed under: SSIS, SQL Server 2005, SQL Server Integration Services