ssis script task adding outputs for 100s of columns

Question

I have a script task in which I need to add 100(s) of columns to its output. Is there a way to import these output columns from a specification file instead of having to manually input them one by one or some other way I'm just not seeing?

More info: I read a list of case numbers from a table, use that as an input column to a script task that then calls a web service to get the case details, I then intend to output that and insert it into another table. Loop till there are no more case numbers. Seemed like a logical thing to do since this will need to be scheduled but copying/pasting/change datatype for all the columns in the output is very tedious and I'm not seeing anything that addresses this so I thought I would ask.

Community · Accepted Answer · 2017-05-23 12:09:52Z

2

In Visual Studio, you can do this only manually.

Programmatically, you can do this by opening your package and adding columns (but you have to do a hard work), you can follow these links to achieve this:

edited May 23, 2017 at 12:09

CommunityBot

11 silver badge

answered Apr 23, 2017 at 22:29

Hadi

37.5k13 gold badges73 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Marshall Alan Hill Over a year ago

Appreciate your response. I will investigate this.

Collectives™ on Stack Overflow

ssis script task adding outputs for 100s of columns

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related