Building SSIS Custom Task

Question

Building SSIS Custom Task

bodempudi111

SSC Veteran

Points: 219
More actions
February 1, 2025 at 4:29 pm

#4527531
Hi Everyone,
Greetings of the day!
I am working on building SSIS Custom task which logs variable values to SSIS execution log. I should be able to select more than one variable in SSIS Custom task, package should log all of the selected variable values to the execution log. I need your help in writing code for this custom task.
I can share any specific details as required.
Outline SSIS Custom task is below.
When developer click add variable button, he can a variable to log, click remove variable button, he can remove a variable.
Thanks
Venkat
- This topic was modified 1 month ago by bodempudi111. Reason: Added image for better understanding
Attachments:
You must be logged in to view attached files.

Viewing 5 posts - 1 through 4 (of 4 total)

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

Phil Parkin SSC Guru Points: 247086 More actions · Answer 1

Are you planning on using Events in a Script Task to do this?

https://learn.microsoft.com/en-us/sql/integration-services/extending-packages-scripting/task/raising-events-in-the-script-task?view=sql-server-ver16

bodempudi111 SSC Veteran Points: 219 More actions · Answer 2

Thanks for your reply Phil.

We do not want to use script task for this.

We would like build an SSIS Custom task(say Log Variable Task). Developer can drag this from SSIS toolbox to log a particular set of variable values to the execution log.

Thanks

Venkat

This reply was modified 1 month ago by bodempudi111.

Phil Parkin SSC Guru Points: 247086 More actions · Answer 3

I have never created a custom task in SSIS, so I'm not going to be able to help you with this, unless you have specific questions about C# code within SSIS.

bodempudi111 SSC Veteran Points: 219 More actions · Answer 4

Thanks for your reply Phil.

Anybody else can help?

Thanks

Venkat

Building SSIS Custom Task

Attachments:

Cookies on SQLServerCentral