Blogs
Welcome to EMC Consulting Blogs Sign in | Join | Help

Welcome to EMC Consulting Blogs

SSIS Junkie

Once upon a time this blog was a hive of activity. Now however its pretty lifeless as you can probably tell so if are pining for more of the same you can find me over at http://sqlblog.com/blogs/jamie_thomson. I look forward to seeing you there!

Article: SSIS Package Configurations

I've been looking into SQL Server Integration Services (SSIS) quite a lot lately and have been writing a couple of articles about what I've been doing. My latest one called Easy Package Configuration is available on http://www.sqlis.com. The article explains how to use package configurations to dynamicly alter your SSIS packages at run-time.

The functionality is very similar to that provided by Conchango's SQL Server Accelerator for BI.

- Jamie

Published 29 November 2004 22:38 by jamie.thomson

Comments

 

TrackBack said:

March 1, 2005 10:04
 

Jamie Thomson - Life, the universe and SSIS! said:

By now alot of you will be familiar with Configurations right? I am using XML configuration files extensively...
November 14, 2005 12:02
 

Jamie Thomson - Life, the universe and SSIS! said:

By now alot of you will be familiar with Configurations right? I am using XML configuration files extensively...
November 14, 2005 12:03
 

Jamie Thomson - Life, the universe and SSIS! said:

By now alot of you will be familiar with Configurations right? I am using XML configuration files extensively...
February 8, 2006 20:42
 

Suresh said:

HI Jamie
I am not sure if this a bug with SSIS but I had a package with some lookups in it. Later I changed the connection manager for database connectivity and I put the connection string in a variable, just to make it flexible for me to change it at run time. But now all my lookups are giving error one by one saying " The Acquireconnection method  call to the connection manager "<name>" failed with error code 0xc0202009. I think lookup should work fine as i just put the connection string in variable and picked it from their by putting it in expression.
Pls advice.
April 18, 2006 13:28
 

jamie.thomson said:

Suresh,
Did you set up an expression on the connection manager's ConnectionString property?
What connection string is it trying to use? Use this technique to find out: http://blogs.conchango.com/jamiethomson/archive/2005/10/10/2253.aspx

-Jamie
April 18, 2006 13:39
 

SSIS Junkie said:

By now alot of you will be familiar with Configurations right? I am using XML configuration files extensively

January 16, 2007 18:13
New Comments to this post are disabled

This Blog

Syndication
EMC2, EMC, and where information lives are registered trademarks of EMC Corporation.
All other trademarks used herein are the property of their respective owners.                  
© Copyright 2009 EMC Corporation. All rights reserved.                                                    
Powered by Community Server (Personal Edition), by Telligent Systems