| Author |
Topic |
|
mlawton
Starting Member
35 Posts |
 Posted - 2010-11-18 : 12:25:21
|
| I have a SSIS package called CustomerBilling. I use a variable in the package for region. I have a job set up for each of the 4 regions. I have SSIS monitor set up for the 4 jobs. The results for the monitoring will just have CustomerBilling as the package name. How can I add the variable to the package name to distinguish between the 4 regions? For example, have it say East CustomerBilling instead of just CustomerBilling. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-11-18 : 12:32:04
|
| you mean make package name dynamic based on variable?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
mlawton
Starting Member
35 Posts |
Posted - 2010-11-18 : 13:19:35
|
| Yes |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-11-19 : 10:59:34
|
| what kind of requirement is that? can i ask reason for doing this?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-19 : 11:08:47
|
| What information do you get about the running package at the moment.You would probably do this by logging the variable or associating it with the job instance==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
mlawton
Starting Member
35 Posts |
Posted - 2010-11-19 : 11:42:44
|
| The requirement is that when I look in the SSIS Monitor through reporting services I see a listing for each of the 4 jobs and they all say CustomerBilling and I can only tell which is which by the date and time the job ran. what I want to be able to see is the variable from the package in the title of the package CustomerBilling. It should say east CustomerBilling, pulling the variable from the package.How do I log the variable or associate it with the job instance? |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-19 : 11:52:54
|
| I think you mean you're using the running packages report from the inteagtion services snap in? Not something I've ever considered using.Easier would be to just add steps into the job before and after the step that runs the package and log the info to a table. You can then view the table (and also have a record of what has happened).==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
mlawton
Starting Member
35 Posts |
Posted - 2010-11-19 : 12:26:53
|
| Okay. I have the results of monitoring the package going to the sysdtslog90 table. How can I get the variable East passed to this table from the SSIS Log provider? I saw the ON VARIABLEVALUE CHANGED. Will this do it? The current columns are Id, Event, Operator, Source AS [SSIS Step], StartTime, EndTime, [Message]. |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-19 : 12:35:00
|
| That's written using sp_dts_addlogentry.You can create your own (or call this one) and call it from the job or from within the package - but if you're going to do that why not create your own table.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
SSIS Variable Monitoring