SSIS Junkie : SQL Server 2005

Twitter-alike on SSDS

[I had to call this out because I think its a cool example of what can be done with SSDS.] Mike Amundsen is a guy that really grasped the SSDS nettle. First he built the SSDS provisioning client ( http://amundsen.com/examples/ssds/data-client/ ) and now Read More...

Posted 01 August 2008 09:13 by jamie.thomson | 3 Comments

Filed under: SQL Server 2005, SSDS, SQL Server Data Services, SDS, SQL Data Services

SQL Server Data Services raises questions straightaway

I don't care what any of you say, by far the most exciting announcement from today's MIX08 keynote was SQL Server Data Services (SSDS) . [OK, I admit I may be in a minority on this one and I strongly suspect my colleagues in Conchango's Interactive Media Read More...

Posted 06 March 2008 03:23 by jamie.thomson | 8 Comments

Filed under: SQL Server 2005, SQL Server, Microsoft, SSDS, SQL Server Data Services, cloud computing, SDS, SQL Data Services

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

SQL Server 2005: View all permissions (2) - Explode the roles!

Two days ago I posted a blog entry here that showed how the following SQL statement: select dp.NAME AS principal_name, dp.type_desc AS principal_type_desc, o.NAME AS object_name , p.permission_name, p.state_desc AS permission_state_desc from sys.database_permissions Read More...

Posted 09 February 2007 23:54 by jamie.thomson | 34 Comments

Filed under: SQL Server 2005, SQL Server, Microsoft, T-SQL

SQL Server 2005: Books Online

SQL Server Books Online (BOL) has improved dramatically in SQL Server 2005. I'm not necassarily talking about the content (though that IS better I feel), I'm talking about the ability to provide feedback about the articles. What's great is Read More...

Posted 09 February 2007 19:08 by jamie.thomson | 3 Comments

Filed under: SQL Server 2005, SQL Server, Microsoft, Books Online

SQL Server 2005: View all permissions

Today I was asked how one can query the server to list out all permissions that a principal has on all the securables in a SQL Server database. After 10 mins of searching through BOL I came up with the following that seems to work quite well: 1 select Read More...

Posted 09 February 2007 00:38 by jamie.thomson | 9 Comments

Filed under: SQL Server 2005, SQL Server, Microsoft, T-SQL

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

T-SQL: Generate a list of dates

Sometimes we can be working and we write or find a ridiculously simple bit of code that we know will be useful in the future, then we just go ahead and plain forget all about it. When I find such stuff I like to stick it on my blog so that I know where Read More...

Posted 11 January 2007 22:44 by jamie.thomson | 18 Comments

Filed under: SQL Server 2005, SQL Server, SQL, Common Table Expression, T-SQL, List of dates

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 | 1 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

SQL Server 2005 SP2

By now you probably know that the first Community Technology Preview (CTP) of SQL Server 2005 Service Pack 2 is available. I wanted to highlight what I see as the most important addition: "Generate Script Wizard . You can now specify that the scripted Read More...

Posted 09 November 2006 04:22 by jamie.thomson | 5 Comments

Filed under: SQL Server 2005, SP2

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 | 98 Comments

Filed under: SQL Server 2005, SQL Server Integration Services, SSIS, Dataflow Task, lookup

Attachment(s): UpdateAndInsert.zip

Welcome to blogs.conchango.com

SSIS Junkie

SQL Server 2005 (RSS)