Advertisement

03.11.2008 at 08:52AM PDT, ID: 23232171
[x]
Attachment Details

Get name of current DTS package at runtime

Asked by SWRO in MS SQL DTS

Tags: , , ,

Hello, I am trying to dynamically adjust the Error File name in the Error Handling section on the Logging tab of my DTS package properties. That is, if the package is named "B2B_Import_Daily", then I'd like my Error file to be the following: dts_error_B2B_Import_Daily.txt.

I am using the Dynamic Properties task in a few DTS packages to dynamically change text file names, and would like to use the same methodology here, but I can't figure out how to get the name of the current DTS package via a variable (I want to avoid hard coding and make these DTS' templatable).

How does one get the name of the current package?Start Free Trial
[+][-]03.11.2008 at 05:05PM PDT, ID: 21101745

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL DTS
Tags: Microsoft, SQL Server DTS, 2000, Getting name of current package at runtime
Sign Up Now!
Solution Provided By: TommyTupa
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628