Task Container names.

Question

Post reply

Task Container names.

dave-dj

SSChampion

Points: 11297
More actions
June 8, 2010 at 5:16 am

#139362

Hi,
Does anyone know how I can get the name of a task container. to use in an SSIS expression?
(I want this so I can dynamically set error output files to have a relevant name for the failing task container).
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

Try the following variable in your expression:

@[System::TaskName]

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

dave-dj SSChampion Points: 11297 More actions · Answer 2

thanks. but it's not quite what I was looking for.

That gives me the Data Flow Task name.

What I would like is (if possible) the name of the DFT internal step that is running.

ie OLE_SRC ZONES (ole db source)

DER AuditDetails (derived column task)

etc etc, with the aim of dynamically setting an error output file name.

I suspect that I will have to be happy with the Data Flow Task name

_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 3

I think you are screwed.. I looked at the available system variables associated with items within a dataflow and tried several different data-flow components, not one idenitified itself by a system variable..

CEWII

dave-dj SSChampion Points: 11297 More actions · Answer 4

Oh well. I guess I'll have to be happy with the Task names from the control flow level.

Thanks.

_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 5

dave-dj (6/10/2010)
Oh well. I guess I'll have to be happy with the Task names from the control flow level.
Thanks.

Well, in your original question, you asked for the name of the task container 😉

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

dave-dj SSChampion Points: 11297 More actions · Answer 6

lol 🙂 fair point.

_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

Cadavre SSC-Forever Points: 41690 More actions · Answer 7

You could always declare a variable, then change it at "fail" to whatever task had failed.

[/URL]

Uploaded with ImageShack.us

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 8

I was thinking about event handlers to solve your problem, but these darn things also just go to the depth of a single task.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

dave-dj SSChampion Points: 11297 More actions · Answer 9

skcadavre (6/10/2010)
You could always declare a variable, then change it at "fail" to whatever task had failed.

Not a bad suggestion. but I think it would be easier just to append the name that I want onto the file connection string if I have to create a task to change variable which I would then append onto the connection string. 6 and 2x3 on that one really.

thanks though.

_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

dave-dj SSChampion Points: 11297 More actions · Answer 10

Although, I've just seem your screen shot, so If I can dynamically generate the logfile each time then that may actually be a good way forward.

_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)