New answers tagged

0 votes

SSIS project window turns white right at the beginning of debugging, status "Running", tricky to get the project back. How do I avoid this crash?

I saved all open projects, shut down Visual Studio, and opened the project again without running into this error again. By the same time, I could also change the size of te SSIS boxes in the Control ...
questionto42's user avatar
-1 votes

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?

Here is the full setup and code that takes up the other answer. Testing for this answer made clear that in the second Script Component, you can only work on the temp table that was made in the first ...
questionto42's user avatar
2 votes
Accepted

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?

All you have to do is add an ADO.NET connection manager for SQL Server to your project and set it to "RetainSameConnection". Then each script task can access the same SqlConection object. ...
David Browne - Microsoft's user avatar
0 votes

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?

First commend you on opening the question adding some detail and attempting a thoughtful answer. Honestly your answer has made me think a bit more and could work as long as public class ScriptMain is ...
Matt's user avatar
  • 111
0 votes
Accepted

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?

After checking this for long hours, I found a way to do this. The main thing to understand is that the column names of the Row object are changed so that only letters are kept, example: my_column-1 b ...
questionto42's user avatar

Top 50 recent answers are included