All Questions
Tagged with visual-studio ssis
35
questions
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 ...
- 316
0
votes
1
answer
36
views
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?
This takes up SSIS package with status running is not running - Stack Overflow.
SSIS project window turns white right at the beginning of debugging, status "Running":
Right click closing ...
- 316
0
votes
1
answer
28
views
The debugger only stops at the breakpoints of the first Script Component. How do I debug more than one Script Component in an SSIS Data Flow Task?
This takes up How to debug a script component in SSIS - Stack Overflow which was asked for the 2008 version and is now outdated. That is why this question needs to be revived for the versions of ...
- 316
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 ...
- 316
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 ...
- 316
3
votes
1
answer
6k
views
Unable to install msoledbsql despite installing the visual c++ redistributable prerequisite
I am trying to use Visual Studio 2022 to successfully load and build an SSIS package that targets SQL Server 2016. Documentation suggests that this is indeed supported. Per the online docs (https://...
- 143
0
votes
1
answer
523
views
SSIS OLE DB Destination REPLACE instead of INSERT
The information flowing from an OLE DB Source to an OLE DB Destination is getting inserted, allowing duplicate records to be submitted after the package is run.
Is there a good way to replace these ...
- 3
1
vote
0
answers
2k
views
SQL server job agent fails to execute SSIS package, the package runs fine manually
I have a job which executes two packages. Step 1 is a package which is no longer executing under the job agent although it was executing fine before the server reboot. The package executes fine ...
1
vote
1
answer
3k
views
SSIS transforming numbers with decimal comma to decimal dot
I'm trying to create a very basic package that copies data from my SQL server into an Excel file.
The data that comes from the server comes with a decimal comma (e.g. 1234,56) - that is how I want it, ...
- 11
0
votes
1
answer
2k
views
How to recover missing SQL auto-recover files in SSMS (Microsoft SQL Server Management Studio) after unexpected shutdown
SQL Server Management Studio (SSMS) closed unexpectedly. Many SQL files were open. When SSMS was restarted, it did reopen some auto-recover files, but not all of them, especially one in particular. ...
- 137
2
votes
1
answer
93
views
Identifying elements in SSIS package built in MS Visual Studio 2008
I recognize that these are variables, but I am not sure how to add these elements to the package (or how they are added to begin with), what effect that have or even how to manipulate them. No right ...
- 75
2
votes
1
answer
419
views
Annotations for SSIS
Forgive me if this is an inappropriate question for this forum (being DBA and all, I thought it may fit).
I have an SSIS package that I've recently upgraded and moved from BIDS to VS 2019.
It's a very ...
- 188
0
votes
1
answer
2k
views
SSIS cannot deploy package to SQL server - An error occurred during decryption 15466
After recovering and re-importing a backup of a SQL Server 2019 instance none of my SSIS packages will deploy from Visual Studio.
Whenever I try and deploy I get the error
=============================...
- 101
0
votes
1
answer
292
views
Does visual studio (2015 or above) needs to be installed in a server in order to transfer/create SSIS packages there?
At work we have an old server and we're moving everything from there to our new server. We're a very small team, and one of my team-members says without visual studio 2015 in the new server he can not ...
- 1
1
vote
1
answer
8k
views
How to change "deployment target version" on SSIS 2019?
I am experiencing the following errors when using the "Transfer SQL Server Objects" task in SSIS on Visual Studio 2019:
An exception occurred in SMO
Value cannot be null. Parameter name: server
...
- 207