blogs.conchango.com

Browse by Tags

• best practice
• Checkpoints
• connection manager
• Dataflow Task
• DTS
• encryption
• Expressions
• indirect configurations
• Informatica
• kimball
• Microsoft
• ole db source adapter
• ProtectionLevel
• raw files
• Scripting
• security
• SQL Server
• SQL Server Integration Services
• SSIS
• template
• Variables
• XMLA

• SSIS: Parent package configurations. Yay or nay?

  A few of my fellow SSIS MVPs and I were asked if we wanted to submit a whitepaper to coincide with the new release of SQL Server; today those papers were (bar one) released: Considerations for High Volume ETL Using SQL Server Integration Services by Pat Read More... Posted 29 August 2008 22:49 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS, configurations

• SSIS: Case sensitive SQL Server configurations

  I just received an email from Michael Groh who had a warning about using SQL Server configurations in SSIS and he suggested I post about it on my blog which I'm more than happy to do. Here's what Michael had to say:   We finally tracked down a really Read More... Posted 22 August 2008 08:49 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SQL Server, SSIS, configurations

• SSIS: Encrypted Configurations

  7 days ago I posted a blog entry called Storing Passwords in which I explained the various options for securely storing passwords in a SSIS configuration. The securest form of doing this is storing them in an encrypted fashon in a SQL Server table although Read More... Posted 04 May 2007 05:03 by jamie.thomson | 0 Comments Filed under: SQL Server Integration Services, SSIS, configurations, encryption

• SSIS: Storing passwords

  Many questions on the SSIS forum relate to security aspects of using SSIS and a large percentage of those relate to the storing of passwords in configurations. Many people have correctly observed that, whilst SSIS will generate configuration files for Read More... Posted 26 April 2007 20:14 by jamie.thomson | 19 Comments Filed under: SQL Server Integration Services, SSIS, security, ProtectionLevel, configurations

• SSIS: The steep SSIS learning curve!

  As anyone who has been using SQL Server Integration Services (SSIS) for a while will know there are lots and lots of knobs within a package that can be tweaked to alter behaviour. Many of these aren't obvious and the steep learning curve that many Read More... Posted 20 April 2007 22:03 by jamie.thomson | 11 Comments Filed under: SQL Server Integration Services, SSIS, configurations

• SSIS: Property Paths syntax

  A comment here from Evan made me realise that there doesn't really exist a good reference for property paths in SSIS. Property paths are used in configurations and the /SET option of dtexec.exe to set properties in the package dynamically at runtime. Read More... Posted 13 March 2007 00:35 by jamie.thomson | 30 Comments Filed under: SQL Server Integration Services, SSIS, configurations

• SSIS: Should I store connection strings in variables?

  I've had an idea about how I'd like to use connection managers, variables, and consequently, configurations and its quite a diversion from how I manage these object types in SSIS currently. Quite simply I'm toying with the idea of storing Read More... Posted 01 December 2006 18:01 by jamie.thomson | 20 Comments Filed under: SQL Server Integration Services, SSIS, configurations, Variables

• SSIS: Package spin-up order of events

  There's a really good post here by Davide Mauri explaining the order in which "things" happen when a package spins up. By "things" I mean logging starting, reading configurations, validation and control-flow execution. Logging Read More... Posted 08 October 2006 18:01 by jamie.thomson | 0 Comments Filed under: SQL Server Integration Services, SSIS, configurations

• SSIS: Loading a Kimball data warehouse using SSIS

  I have just been watching Joy Mundy's webcast " Loading a Kimball method data warehouse using SQL Server Integration Services ". I highly recommend it - Joy has done great job in outlining the basic skeleton for loading a data warehouse Read More... Posted 14 August 2006 21:22 by jamie.thomson | 6 Comments Filed under: SQL Server Integration Services, SSIS, kimball, configurations

• SSIS: But it used to work in DTS (3) - Passing a parameter from a parent package to a child package

  Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS. Passing a parameter from a parent package to a child package In DTS, packages could execute other packages by use of the Execute Package Task. Values Read More... Posted 29 June 2006 13:14 by jamie.thomson | 5 Comments Filed under: SQL Server Integration Services, SSIS, DTS, configurations

• SSIS: But it used to work in DTS (2) - Changing connections using the Dynamic Properties Task

  Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS. Changing connections using a Dynamic Properties Task DTS2000 introduced the popular, and very powerful, Dynamic Properties Task. This task enabled Read More... Posted 28 June 2006 13:28 by jamie.thomson | 4 Comments Filed under: SQL Server Integration Services, SSIS, DTS, configurations

• SSIS: Warning but no error if an environment variable is missing

  I have spoken previously about indirect configurations and tried to convince everyone of how useful they are. I noticed something today concerning indirect configurations that quite surprised me. If you execute a package that uses an indirect configuration Read More... Posted 25 May 2006 18:15 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS, configurations, indirect configurations

• SSIS: Common folder structure

  For reasons that I'll save until another post , I always deploy my packages as files rather than to SQL Server. In doing this I have derived a folder structure that I use in order to keep all my deployed packages and other files in the same place: Read More... Posted 05 January 2006 15:19 by jamie.thomson | 37 Comments Filed under: SQL Server Integration Services, SSIS, raw files, best practice, configurations, Checkpoints, template, indirect configurations Attachment(s): PackageToUseCommonFolderStructure.zip

• SSIS: Suggested Best Practices and naming conventions

  I thought it would be worth publishing a list of guidelines that I see as SSIS development best practices. These are my own opinions and are based upon my experience of using SSIS over the past 18 months. I am not saying you should take them as gospel Read More... Posted 05 January 2006 12:13 by jamie.thomson | 53 Comments Filed under: SQL Server Integration Services, SSIS, raw files, ole db source adapter, connection manager, Microsoft, Dataflow Task, Scripting, Expressions, best practice, configurations, Variables, Checkpoints, template

• SSIS: Indirect configurations ROCK!

  By now alot of you will be familiar with Configurations right? I am using XML configuration files extensively in my current project - they're a method of affecting the way your package executes - the most common use is to store connection strings for Read More... Posted 02 November 2005 11:24 by jamie.thomson | 67 Comments Filed under: SQL Server Integration Services, SSIS, configurations, indirect configurations