November 2010 - Posts

• SQL Server 2008 SP1 CU 6 includes small changes to .dtsx files

  At work earlier this week an SSIS package in our environment was failing inexplicably and after a great deal of effort my superhuman colleague Tom Hunter discovered the root cause of the problem and I thought it might be worth sharing, particularly as Read More... Posted Thursday, November 25, 2010 11:21 PM by jamiet | 15 Comments Filed under: sql server integration services, ssis

• Synchronous execution of SSIS packages using T-SQL : Denali

  This post relates to SQL Server code-named Denali which at the time of writing is a pre-release version of the next version of SQL Server. It is also known as SQL11 and is expected to be released sometime in 2011 or 2012. The name given to it on release Read More... Posted Friday, November 19, 2010 8:25 PM by jamiet | 1 Comments Filed under: denali, SQL Server 2012, sql server integration services, ssis

• Convert an integer seconds value into words in VBScript : Reporting Services

  Occasionally I stick random bits of code up on this blog because (a) I know I’ll need it again someday and (b) maybe it’ll be useful for someone else. This particular VBScript function called TimeInWords can be used in SQL Server Reporting Services to Read More... Posted Sunday, November 14, 2010 11:36 PM by jamiet | 1 Comments Filed under: SQL Server Reporting Services, SSRS

• SQL Server presentations this week

  Just a short note here to let you know of some presentations that I am doing this week. On Tuesday 16th November at 8pm GMT I am doing a webinar as part of Pragmatic Works’ “British SQL Invasion “ series of webinars. Sadly there is only actually two of Read More... Posted Sunday, November 14, 2010 9:16 PM by jamiet | 2 Comments

• SSIS Server, Catalogs, Environments & Environment Variables in SSIS in Denali

  In the last few days I have written 3 blog posts covering some new features in SQL Server Integration Services (SSIS) in the next version of SQL Server, code-named Denali: Introduction to SSIS Project in Denali Parameters in SSIS in Denali The new Execute Read More... Posted Saturday, November 13, 2010 7:50 PM by jamiet | 15 Comments Filed under: Catalogs, denali, Environments, sql server, SQL Server 2012, sql server integration services, ssis

• The new Execute Package Task in SSIS in Denali

  In my blog post of 10th November Introduction to SSIS projects in Denali I spoke of how, in Denali, SSIS packages can collectively be distributed as a single unit called a Project. I want to start digging into the advantages that Projects bring and the Read More... Posted Friday, November 12, 2010 7:41 PM by jamiet | 8 Comments Filed under: denali, sql server, SQL Server 2012, sql server integration services, ssis

• Parameters in SSIS in Denali

  In my last blog post Introduction to SSIS Projects in Denali I talked about the new Project deployment model that is coming in the next version of SQL Server Integration Services (SSIS); working hand-in-hand with Projects is another new feature – Parameters. Read More... Posted Thursday, November 11, 2010 8:58 PM by jamiet | 17 Comments Filed under: denali, Parameters, sql server, SQL Server 2012, sql server integration services, ssis

• Introduction to SSIS Projects in Denali

  The next version of SQL Server has been unveiled and it has a codename of Denali (aka SQL11, not aka SQL2011). SQL Server Integration Services (SSIS) is receiving quite an overhaul in Denali and over the next few days I’m going to outline some of the Read More... Posted Wednesday, November 10, 2010 8:06 PM by jamiet | 11 Comments Filed under: denali, sql server, SQL Server 2012, sql server integration services, ssis

• What's new in SSIS in Denali?

  SQL Server codename Denali was presented to the world yesterday and with it a promise that there's a lot of goodness coming in the new version of SSIS. I've got a few half-written blog posts coming up on that but in the meantime you might want to dive Read More... Posted Wednesday, November 10, 2010 11:08 AM by jamiet | 1 Comments Filed under: denali, SQL Server 2012, sql server integration services, ssis

• SSMS in SQL Server Denali – “Insert snippet” and “Surround with”

  SQL Server Denali CTP1 has hit the streets! I’ve been lucky enough to have been playing with it for a couple of weeks (thank you to those responsible – you know who you are) and that means I can now start talking publicly about some of the cool stuff Read More... Posted Monday, November 08, 2010 11:40 PM by jamiet | 5 Comments Filed under: denali, sql server, SQL Server 2012, sql server management studio