File Location based on parameter ?

Currently

File Connection Manager Editor with

Usage Type : Create File

and

File: eg C:\DBA\Log\SSISPackage1.log

The desired Goal:

Rather than hardcode the file directory for a log file

eg C:\DBA\Log\SSISPackage1.log

can the definition be parameterized.

For example\\MachineName\DBA\Log\SSISPackage1.log

where MachineName is the location where the package is phyiscally

located.

[541 byte] By [GCB] at [2007-12-22]

«« Maximize and Fullscreen difference?
»» Polygon Tessellation

# 1

Hi,

The file connection manager details need not be hardcoded. Please check "Package Configuration" feature in SSIS - to configure the properties of Package / Task / Connection objects in SSIS.

Using Package Configuations - You will be able to configure the log file details also dynamically during load time.

Thanks,
Loonysan

loonysan at 2007-8-30 >

top of Msdn Tech,SQL Server,SQL Server Integration Services...

# 2

I have been trying to use a user variable for the fileName but I get keep getting the message

expression for LoggingFileName failed evaluation. There is an error in the expression.

My expression is

"\\" + &[System::MachineName] + "\DBA\Log\" + &[System::PackageName] + ".log'

THanks

GCB at 2007-8-30 >

# 3

I finally got a valid experssion. And it is the desired experession.

\\ACCPAPS10\DBA\Log\WARKM_SY01.log

but I am still having problems. There are no error messages but the Connection parameter on the properties page of the File Connection was changed to

@[LoggingFileName].... But no logging file is created

Any ideas

THanks

GCB at 2007-8-30 >

# 4

I hope you would have created a variable called "LoggingFileName" and the resultant value for that variable is "\\ACCPAPS10\DBA\Log\WARKM_SY01.log".

Right Click on the Connection Manager in the Project and select Properties.

In the Properties Window - Clear the value for "ConnectionString" property and click on the Expressions attrubute. Select "ConnectionString" in the property dropdown and select User::LoggingFileName as the expression.

Thanks,
Loonysan

loonysan at 2007-8-30 >

# 5

I did click the Expresssions Connection String but instead of specifying a User variable I just specified

the formula that I wanted.

What is the value of specifying a User Variable?

THanks

GCB at 2007-8-30 >

# 6

Here is why: http://blogs.conchango.com/jamiethomson/archive/2005/12/05/2462.aspx

-Jamie

JamieThomson at 2007-8-30 >