Skip to main content

All Questions

Tagged with
0 votes
0 answers
24 views

How do I feed the output arrow (`Input0_ProcessInputRow()`) of a second Script Component with data from a temp table of the first Script Component?

Here is the full setup and code that takes up this answer at DFT drops connection and its temporary table after leaving any DFT item, tested with two Script Components. How do I keep the temp table ...
questionto42's user avatar
0 votes
1 answer
130 views

DFT drops connection and its temporary table after leaving any DFT item, tested with two Script Components. How do I keep the temp table alive?

Links This takes up: Using temporary tables in SSIS flow fails - Stack Overflow Is it possible to use a temp table in a data flow source?; answer is: 'No', since it cannot be passed without being ...
questionto42's user avatar
0 votes
2 answers
371 views

How do I create and fill a temporary table with incoming data from a Data Source item without leaving the SSIS Data Flow Task C# Script Component?

I came to ask this question after coding in a script component for some time, testing mainly how to loop over columns of the Row object, see Looping Through Columns in SSIS Script Component - Stack ...
questionto42's user avatar