October 6, 2015 at 6:12 am
Guys i am building the custom logging framework in that i want get the task name ( Eg: get the data from source) which is currently executing , i can get in the event handler, however i need in the script task ? is there any way to achieve this thing
i am not clear let me know i can post some sample
October 6, 2015 at 6:32 am
rajarajansudar (10/6/2015)
Guys i am building the custom logging framework in that i want get the task name ( Eg: get the data from source) which is currently executing , i can get in the event handler, however i need in the script task ? is there any way to achieve this thingi am not clear let me know i can post some sample
Not easy. You get only limited access to the package object model in a script task (connections, variables and not much else).
Are you using pre-2012 SSIS?
If not, have you tried using the native SSISDB logging?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
October 8, 2015 at 2:11 am
i am using SQL server 2012 data tool any work round idea to take the current executing task name
October 8, 2015 at 2:14 am
idea is get how rows got inserted from source to destination for each data flow task inside the pkg
October 8, 2015 at 6:43 am
can u use the script components ? it has pre execute and post
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply