Questions tagged [ssis]
SQL Server Integration Services, an ETL tool sold by Microsoft and bundled with SQL Server versions since SQL Server 2005.
1,137
questions
0
votes
0
answers
22
views
SSIS OnError Propagete set to False - still propagating to parent containers
I have an SSIS package with a Data Flow Task (Word to DB Data Flow Task) that is inside a sequence container that is inside of several loops. "Word to DB Data Flow Task" can sometimes fail ...
0
votes
1
answer
39
views
Simple SSIS package that is successful, but "fails"
We have an SSIS package that runs at midnight daily. It pulls data from Active Directory using ADSI query and pushes the data to a CRM.
The only time it "fails" is on Sunday night. Here is ...
0
votes
1
answer
24
views
How do I enter a bigint number in SSIS?
This is a cross-site duplicate of Evaluate Expression with expression builder - Stack Overflow, I wanted to share this with screenshots and with a broader question since you hit the other link only if ...
0
votes
1
answer
12
views
How do I make a DT_I4 Integer lookup from a boolean condition in a derived column to an Integer lookup column? Only a `0` matches, a `1` does not
In order to make a lookup, make:
a derived column in as the four bytes Integer DT_I4 input that can be a 0 or 1,
a lookup to a lookup table column that is a four bytes integer 0 or 1 as well.
Source ...
0
votes
0
answers
37
views
SSIS Dataflow Task issue, moving data from any Source to MySQL via ADO.Net
Can you please help me in getting this problem solved..
I'm trying to build a SSIS package where I'm moving the data from any Source to MySQL. However I'm getting a weird problem in dataflow task.
[...
0
votes
1
answer
104
views
Why does "Work Offline" turn itself on in SSIS?
I have an SSIS package that is currently working perfectly on my server. Whenever I open it in Visual Studio, "Work Offline" turns itself on for two of the SQL connections. This produces ...
0
votes
1
answer
52
views
How do I avoid passing a row with a NULL in one of the matching column values to the unmatched rows in KingswaySoft SSIS Add-In tool "Premium Lookup"?
Aim
I work with the KingswaySoft SSIS Add-In tool "Premium Lookup", but I guess that the same question might arise with the built-in SSIS "Lookup" tool.
I try to match on a double ...
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 ...
3
votes
1
answer
339
views
What exact error messages do UMPPC*.DLL and SCRIPTCONTROL*.DLL cause SQL Server Agent when it fires SSIDB packages?
Microsoft's maintains a list of bad DLLS. This is one item on that list (emphasis mine)
UMPPC*.DLL and SCRIPTCONTROL*.DLL
These DLL files are loaded in to the address space of SQL Server related ...
0
votes
1
answer
162
views
Run SSIS package from SQL Jobs - error SSL
Environment
SQL Server 2022
Microsoft OLE DB Driver 19 for SQL Server
Connection string:
When I run the SSIS package from SQL Jobs I get below error even if in connection string I have Use ...
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 ...
0
votes
1
answer
119
views
SSIS Double-hop... how to solve?
I have what I assume to be a pretty standard setup:
ServerA running a web application as ServiceAccount1
ServerB running SSIS as ServiceAccount2.
ServerC hosting a network share that ServiceAccount1 ...
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 ...
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 ...
0
votes
0
answers
104
views
SSIS - Save Multiple Query Results to one CSV file
I have around 50 select statements, some with different column names, that I would really like to automate using SSIS. I'm still fairly a beginner with using SSIS. My normal process is to navigate to ...