Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [ssis]

SQL Server Integration Services, an ETL tool sold by Microsoft and bundled with SQL Server versions since SQL Server 2005.

Filter by
Sorted by
Tagged with
1 vote
1 answer
2k views

Cannot deploy SSIS packages after upgrade to SQL Server 2016 SP2 Build 5201.2

We recently upgraded from SQL 2016 SP1 build 4466 to SP2 build 5201 (CU2 GDR) on an AG. On one server an analyst was deploying SSIS using Visual Studio Enterprise 2015 (version 14.0.25431.01 Update 3 ...
2 votes
1 answer
2k views

T-SQL Check another table's rows, if match delete them

I am creating a script in SSIS where I want table A to check if rows exist in table B. If they exist, they must be deleted. Table A is an archive table named Customer_archive Table B is a table that ...
0 votes
2 answers
60 views

SSIS Package hanging with two Constraints pointed at one Task: Can you have multiple constraints pointing to one Task?

In the example I pasted in the image, I have 5 Tasks. I don't think it's important what kind of Tasks I'm using--but I could be wrong, of course--because the main issue seems to be how the constraints ...
9 votes
9 answers
58k views

Error Authenticating Proxy Account when Executing SSIS job

I have a SQL Server instance that runs 5 scheduled tasks each night, each of which run SSIS packages. These packages have been running for years and the associated steps run via a Proxy Account (...
0 votes
1 answer
17 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
2k views

Changing the connection string in SQL Server

We deployed the packages from an old server to a new server. How to change the connection string i.e initial catalog or server name parameter from Agent job -> Configuration -> Connection ...
1 vote
1 answer
563 views

SSIS 2016 conditional split with multiple columns in conditions

I am having an issue in executing a conditional split for upserting records into my production table, using SSIS 2016 and MSSQL 2016 (Standard Ed.) I am trying to load two separate files (produced ...
2 votes
1 answer
10k views

Difference in number format (comma and dot) on SSMS and SSIS

I have a numeric(5,2) field on my SQL Server database. When I run the query, the number on that field appears with . (dot) separator. However, when I preview the query on SSIS, it appears with comma(,)...
0 votes
1 answer
23 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 ...
3 votes
1 answer
3k views

SSIS Script Component as Source AddRow Null Exception

I have a SSIS package with single Dataflow Task. The first step in this Dataflow is a Script component setup as a source, the default 'Output 0' has been renamed to 'Out' and it has a single column '...
0 votes
1 answer
616 views

Issues deploying SSIS package to SQL Server in Azure AD Domain Services (AADDS) environment

We use Azure Active Directory (Azure AD) in my organisation, and we recently deployed Azure AD Domain Services AADDS) to handle a SQL Server 2019 we use internally. My Azure AD domain is (fictitiously)...
0 votes
1 answer
276 views

SSIS Package is writing corrupt data, but only when run as a Job

Our environment is the following: SQL Server 2019 (15.0.4153.1) + SQL Integration Services (15.0.2000) We have a DTSX Package that uses a OLE connection manager to connect to an SQL Server to read ...
5 votes
2 answers
5k views

Issues running SSIS package as SQL Server Agent job

I've got some ridiculously stubborn difficulties when trying to run SSIS packages SQL Server Agent jobs on two SQL Servers, one in a domain and one without. I've read hundreds of posts on dozens of ...
0 votes
0 answers
16 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 ...
0 votes
1 answer
112 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 ...
-1 votes
2 answers
3k views

Multiple conditions in a derived column ssis

Hi I am trying fairly new to SSIS , and my task is to convert dates in string as given below to a datetime. These are my date of birth in the source file (string data type): Source date of birth (...
1 vote
1 answer
994 views

SSIS - Data Import & export wizard - existing tables

For a project I'm attempting to move data from a view in source to a table in destination. And this will need to be done periodically. The quickest way to do this seems to be a SSIS package (as this ...
1 vote
1 answer
1k views

Execute SSIS (package) in SSMS using T-SQL and return a value

Using VS (2019) I created an Integration Services Project to code an SSIS package. The goal was to call a Web API from an SSIS package using input variables like username/password/url and so on. I ...
0 votes
1 answer
436 views

SSIS Package Duration is big before it begins executing

hello i have this question. From Visual Studio i have deployd package in Sql server and i am manualy executing Package. BUt i have noticed that package need 6 sec to do all things but Duration is 8 ...
0 votes
3 answers
2k views

What is the point of installing integration services without database engine?

My understanding is that the database engine feature of sql server enables us to create databases. In the SSIS documentation, https://learn.microsoft.com/en-us/sql/integration-services/install-windows/...
0 votes
1 answer
626 views

SSIS Excel Import - First row getting skipped

I am using VS 2017(SSDT) with SSIS(2012). I'm trying to import an Excel file, but the issue is that the first row is getting skipped. I've unchecked First row has column names in Excel Connection ...
0 votes
1 answer
42 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 ...
3 votes
1 answer
227 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
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 =============================...
1 vote
1 answer
374 views

Open Row insert- SQL

When we run a SSIS package to import data from excel , we get an initial error: The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered. If the 64-bit driver is not installed, run the ...
0 votes
1 answer
440 views

How to get SSIS to stop waiting/processing at task above time limit?

So I have a couple SSIS packages that are run sequentially, scheduled through SQL Server Agent. Right now, I'm getting some errors where certain input data steps just wait indefinitely-- i.e access ...
0 votes
1 answer
67 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
2k views

How to make variable update for each instance of for-each loop?

I have a for-each loop that goes through a file directory. These files are transaction information from different clients. When there is an error with a file (i.e. can't be processed), the Event ...
0 votes
1 answer
20 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 ...
6 votes
6 answers
61k views

SSIS Package Truncation may occur due to inserting data from data flow column

I've a dataflow in SSIS 2008. It reads the data from flat file and inserts in to database. The flat file is CSV. For some reason, all the fields in flat file connection manager seems to have 50 ...
12 votes
3 answers
40k views

SSIS Script Component - How to modify the Output0Buffer

I've a script component which accepts records from SQL Azure database table. The script then invokes a web service, which returns the number of failed and success records. For all the records, I ...
0 votes
2 answers
119 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 ...
0 votes
1 answer
374 views

SQL Server user running SSIS package getting EXECUTE permissions error when they have that permission

We have a user running an SSIS package from Visual Studio. The step that is failing is it is trying to run a stored proc but the error within Visual Studio is "The EXECUTE permission was denied ...
0 votes
0 answers
45 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 ...
0 votes
1 answer
611 views

Error while deploying package to catalog

I am getting below error while deploying package to SSIS catalog on the last step, I am sysadmin and have access to the below views. Can someone help please. Let me know if you need more info. Any ...
0 votes
1 answer
873 views

Inserting in db is extremely slow - SSIS OLE DB Destination

I have been experienced that my DB is experiencing a lot of performance issues and after some time I have observer that an SSIS jobs takes extremely long time to inserting new rows through SSIS OLE DB ...
5 votes
1 answer
5k views

Execute T-SQL Only If AlwaysOn Database Is Primary

Little background on the system. It is SQL Server 2012 AlwaysOn Availability Group with 1 primary and 1 secondary. I have been following this article (SSIS with AlwaysOn) to make SSIS work with ...
14 votes
2 answers
19k views

How do I Continue After a Failure in SSIS

I want to implement something like the following: In this package, I want to loop through a list of database names, dynamically modifying connection manager settings. However, the first failure on "...
9 votes
8 answers
24k views

Permission to view execution report in SSIS Catalog

We are currently using SSIS 2012. Is there any way for a user to view execution reports under SSIS Catalog without being ssis_admin or sysadmin? This is for production environment and we don't want ...
7 votes
2 answers
1k views

Is there any way to tell which derived column failed?

In an SSIS dataflow task we have a derived column transformation with approximately 100 columns (basically converting raw input string data into typed variables). When this task fails, is there any ...
2 votes
1 answer
571 views

Split SSIS project in to multiple files to avoid merge hell

Since SSIS does not like being merged nicely I was wondering how to have a big SSIS package split up. With the idea of having multiple devs working on this simultaneously, and a minimal chance of ...
11 votes
3 answers
31k views

SSIS 2012: The environment reference n is not associated with the project

I have a package that I am updating. The package is executed by a Job Agent job. After deleting the package and then deploying the new version, I run a script that executes any necessary [...
4 votes
1 answer
15k views

How do I map SSIS 2012 Package Variables to Parameters?

I have created multiple packages that use variables to assign Connection Manager Expressions such as Connection String. However in the new SQL 2012 Project Deployment Model I don't seem to be able to ...
1 vote
1 answer
2k views

I am facing issue while decryption (Gives NULL value), While export/Import my Colum level encrypted data

I am facing issue while decryption, Please help me if my column encryption/decryption process is wrong. I encrypted table in Source DB and back up certificate, then exported my encrypted table result ...
3 votes
0 answers
1k views

What are the possible causes for an SSIS package execution having an "ended unexpectedly" status

I have a SQL Agent job that runs an SSIS 2012 package every 30 seconds to export a small amount of data to a CSV file. There is often nothing to export, but when there is, the business wants it done ...
5 votes
4 answers
4k views

SSIS data flow to update source table rows after copying to destination

I have a simple data flow that copies a subset of data from a source table on an internal database to a table on web-facing database. If there is a problem, the error is outputted to an errors table. ...
0 votes
1 answer
1k views

Integration Services 'All Execution Reports' Loads Forever

I'm using SQL Server 2012 to run my Integration Services (SSIS) package by deploying it to the SSIS catalog. Then an error happened in my packages, so I went to check what it is by opening: Reports |...
2 votes
0 answers
974 views

Why does it appear as though SSIS is not reading a connection string properly?

I am executing an SSIS package on a db server and receiving an error. I can execute it just fine on my local machine but when I try to execute it via a SQL Job I get the following: Executed as user: &...
4 votes
1 answer
9k views

Verify if user has read access to a table

I'm developing an ETL, which must read data from a table. There are times that my user's access to that table is revoked. So, to avoid the ETL failing, before reading the table I must verify if I have ...
2 votes
1 answer
2k views

SSIS - Setup OLEDB Connection to SQL Server Always On Listener

I am trying to connect to SQL Server 2017 Always On from an SSIS package (built in SSDT 2017). I am using an OLEDB Connection Manager. 'Application Intent' is set to READWRITE. However, where do I ...

1
2 3 4 5
23