Sql Server 2008 SSIS, disable pre-execute validation
Posted on 2009-04-17
I have an SSIS package that utilizes a "Script Task" on the Control Flow tab as the first step in the process. The package has a series of variables, but here are the ones pertinent to the question:
workingDistrict is a variable that is set via the "Package Configuration" functionality.
The DataFlow tab has a series of "Flat File -> transformation -> OLE Destination" entries. The database connection utilizes the "sourceDB" variable in its connection string. The "Script Task" is a C# script that queries a database for configuration information (sourceDB, FTP folder names, etc) using the "workingDistrict" number in its query. It then assigns the query values to the package variables (such as sourceDB).
The problem is.... When the package is executed, it tries to validate the database connections BEFORE the script task is run. This obviously creates fatal errors because the connection string is incomplete at that time. If I manually enter data into the "sourceDB" package variable it will validate (which then the script task changes the variable values before the actual work begins).
Is there a way to tell SSIS to NOT validate the connections before runtime, or a way to turn off connection validation for a single entry in my Connections window?