April 7, 2014 at 8:54 am
The SSIS package is saved at the file system of the SQL server. The job calls the SSIS package. The SSIS packages writes into a log table, like # of records processed. My question is how to link the SQL job history record to the SSIS log table records.
The Command column inside msdb.dbo.sysjobsteps table exposes the full path of the SSIS package. However, I do not know how to automatically export the SSIS execution path from inside the SSIS package.
I am trying to make the process automatic. Manually I can make a rule that the SSIS package name must be the same as the job name to resolve this issue.
Any suggestions?
Thanks.
April 7, 2014 at 6:15 pm
ssis version??
April 7, 2014 at 10:43 pm
I am not what you meant by "ssis version".
Right now the only automatic way I can think about is to create s script task that output the full path of the package into a variable, which can then be written into the SSIS log table. I am still researching how to create the task.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply