Skip to main content

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
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 ...
Lazer's user avatar
  • 101
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 ...
AKDiscer's user avatar
  • 1,385
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 ...
questionto42's user avatar
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 ...
questionto42's user avatar
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. [...
Ho Ka's user avatar
  • 1
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 ...
J. Mini's user avatar
  • 535
0 votes
1 answer
50 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 ...
questionto42's user avatar
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
3 votes
1 answer
336 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 ...
J. Mini's user avatar
  • 535
0 votes
1 answer
161 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 ...
user avatar
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 ...
questionto42's user avatar
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 ...
Spivonious's user avatar
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 ...
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
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 ...
lodi4224's user avatar
0 votes
2 answers
368 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
0 votes
0 answers
51 views

Can I redirect rows on error in SSIS if the error happens within an "if condition", not while writing the column value?

I know how I redirect rows on error or truncation. That works if you have an error while you insert a value into the column. Truncation: Say you have a string of 10 characters and you insert it into ...
questionto42's user avatar
0 votes
1 answer
64 views

Move a file from local folder to One Drive (Cloud) by using SSIS Package

I tried to move the file from a local folder to OneDrive (cloud). So, I have to use the Premium File Transfer Task from KingswaySoft (Free Developer License). Then I created the SSIS Package and ran ...
Dineshkumar R's user avatar
0 votes
1 answer
37 views

FoxPro ODBC/OLEDB in SSIS result inconsistencies

I am using SSIS to extract data from a .dbf-based ERP system. In SSIS, I have the Visual FoxPro OLEDB provider as a source and SQL Server OLEDB provider as a destination. The data copies quickly from ...
funkyman50's user avatar
0 votes
0 answers
34 views

How to retrieve permission information from SSISDB packages?

I'm currently working on a project where I need to retrieve permission information from packages stored in the SSISDB, but I haven't found a satisfying solution yet. My experience with SSIS is limited,...
SettusBlake's user avatar
0 votes
0 answers
72 views

SSIS package failing when trying to deploy : Assembly Error

I had a 2016 sql server and we needed to migrate to 2019 but in doing so we wanted to keep the same IP & hostname as it was the easier route for other apps that connect to this server to still be ...
WhoIsNotActive's user avatar
0 votes
2 answers
84 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 ...
user3621633's user avatar
0 votes
0 answers
76 views

How to find SSIS package thats calling / Executing a stored procedure?

How to find SSIS package that's calling / Executing a stored procedure? May I know a SQL query OR some other way to see which SSIS package is calling / executing a stored procedure? Thanks, Kumar
kumar's user avatar
  • 1
0 votes
1 answer
97 views

SSIS Variables as expressions to generate Start and end dates of a quarter with input year and month passed as variable

Can someone help me create SSIS expressions for variables to generate QuarterStart(DateTime) and QuarterEnd(DateTime) as a variable with year(int32) and quarter(int32) passed on as user variables. The ...
mk SQL's user avatar
  • 5
0 votes
0 answers
331 views

Ado net source fail to acquire connection

I have a SSIS package package that connects with azure sql database through using ADO net connection manager with SQLclient data provider. Authentication method used is Integrated security. The SSIs ...
Agent SKY's user avatar
0 votes
0 answers
123 views

Connection Retry via OLE DB VS ADO.NET in SSIS

Problem: We want to achieve Connection resiliency in SSIS Packages(OLE DB vs ADO.NET Connection manager) Environment Details: Database: SQL Server 2016 SSIS Connection manager: OLEDB OLEDB Provider : ...
ishan verma's user avatar
1 vote
1 answer
428 views

Can SSIS read the results of a stored procedure and write them to CSV, without populating a table?

My current workflow is as follows: A 'Execute SQL Task' task runs a stored procedure that populates a table. After this, a 'Dataflow Task' task does the following: 2A. Read every row from this table ...
J. Mini's user avatar
  • 535
1 vote
1 answer
177 views

SSIS Execute Package task is slow to start running the first time

I'm migrating an SSIS package from SQL Server 2012 to a new 2022 server. The package uses the Execute Package task inside a loop to run another package in the project. I'm finding that the first ...
paulH's user avatar
  • 1,444
0 votes
0 answers
72 views

Migrate SSIS packages from MSDB to SSISDB in place

We have several server that are running SSIS packages stored in MSDB. I'd like to change that to use SSISDB instead. What's the easiest way to do this? These are not pure SSIS servers, so I don't want ...
AlexP012's user avatar
0 votes
0 answers
258 views

SSIS Error: "Metadata could not be determined because procedure uses temp table"

We have recently restored SSIS Packages and I'm facing this error whenever I try to execute a SSIS package: Unable to determine metadata because « INSERT INTO #File_Results EXEC Master.dbo....
Cristhian's user avatar
0 votes
0 answers
19 views

This operation can only be performed on output buffers - SSIS Kingswaysoft error

We have recently migrated to Visual Studio 2022 from Visual Studio 2014 , one of my package is failing in Visual Studio 2022 when trying to use the kingswaysoft data conversion tool stating "...
Biswanath Das's user avatar
0 votes
0 answers
38 views

SSIS - "Access to the path '\\XXX\data2\TXX\zz\Tracker - xx.xlsx' is denied."

SSIS error: Recently the following error "Access to the path '\XXX\data2\TXX\zz\Tracker - xx.xlsx' is denied.". i occurring. The SSIS package is executed through SQL Agent using a Domain ...
mah's user avatar
  • 1
0 votes
1 answer
119 views

How to access an Intersystems Cache database using SSIS dataflow task

We have been trying to ETL data from an Intersystems Cache database to an SQL Server 2019 database, using SSIS in VS 2019. We have installed the drivers from Intersystems on the server, using their ...
GHauan's user avatar
  • 603
0 votes
0 answers
52 views

Passing the file path and file name and getting data in SSIS using foreach loop container

Can I do the same without using Foreach loop file enumerator? If I do the automation to pick file using foreach loop file enumerator i am facing errors like: Error at Package1: The connection "{...
S_T's user avatar
  • 1
0 votes
0 answers
66 views

Database Engine Services and Integration Services failed during SQL Server 2022 installation

Please, what can i do concerning the issue?
Ibukun John's user avatar
0 votes
0 answers
110 views

SQL Server SSIS Data Flow Task: How to enable transactions between two machines while bypassing DTC, if one machine does not have DTC support?

A bit of a conundrum here; I'm trying to survey what are my best to worst-case options. For a given SSIS package, I have a Data Flow Task which connects via OLE DB for both the Source and Destination ...
user3621633's user avatar
0 votes
0 answers
85 views

SSIS Npgsql Connection Authentication method not supported

After upgrading the source database, the previously working package does not execute and reports the following error. Does anyone know what and where to update in the SSIS server? I hope that it will ...
user2966259's user avatar
1 vote
1 answer
4k views

The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine

I am using SQL 2019, SSISDB is installed. My customer creates an SSIS package using the import/export wizard to import an excell file, and that was successful only after I had to install the 32bit ...
PTL_SQL's user avatar
  • 341
0 votes
0 answers
45 views

Parameterized Connection Manager in SSISDB Job not using the set ODBC password

Regardless of the solution I find online I have been unable to get my SSMS Scheduled Job to successfully complete my ODBC-connected SSIS ETL Packages. I have tried deploying the SSIS project/packages ...
funkyman50's user avatar
1 vote
1 answer
74 views

Database name in oracle 12 connection parameters

I am currently working with MS SSIS to copy data from MSSQL to Oracle 12. I cannot figure out how to make connection string to some test database. I found sample connection string for oracle .net ...
Andi's user avatar
  • 11
0 votes
1 answer
79 views

Schedule a job in SQL Server between two days

How to schedule a job in SQL Server that starts on Wednesday afternoon and it should end on Thursday EOD and between this the SSIS package should execute for every one hour if any error occurs in ...
user avatar
0 votes
0 answers
29 views

Download files from multiple FTP folders inside particular files in SSIS

I have an FTP server with a folder named CIV.2-130211067212254633. Inside this folder, there are files with names like 066075254035232083135067074114053142221015071213.Upload. ...
karthik sanapala's user avatar
0 votes
0 answers
15 views

SSIS - Retrieve variable value from controle flow (no using script task) to data flow

I'm facing an issue with a case where I need to retrieve variable value from controle fow to data flow. The value of the variable in controle flow = 3 but in data flow = 0 as if the value was not ...
Joe's user avatar
  • 1
0 votes
0 answers
42 views

ignore_dup_key vs SSIS Lookup in a SQL Server Batch import

I have to do a Import of my live table (25M rows) to a new table with Identity column before I cutover. I implemented two set of process. Batch import SP which will import records whose creation ...
udhayan dharmalingam's user avatar
0 votes
0 answers
315 views

Validate Excel File data source in SSIS package

I need to load a number of Excel files using SSIS package into a SQL Server table. I am able to successfully loop through and load my Excel files into my table I do not have any issue doing that, BUT ...
Alex ghulami's user avatar
0 votes
1 answer
139 views

Installing SSIS, SSAS and SSRS on a separate Server

Please is there any benefit from installing SSIS, SSAS and SSRS on a separate server from the SQL Engine instance? Apart from additional license implications, are there any other considerations for ...
PTL_SQL's user avatar
  • 341
2 votes
1 answer
114 views

Performant Loop or Alternatives

My current data set looks like following [Table 1] Key Group Amount Sequence 1 1 50 1 2 1 60 2 3 1 70 3 4 1 90 4 5 2 120 1 I have a second table that records a "Rolling rank" of each ...
Caz1224's user avatar
  • 121
0 votes
1 answer
63 views

SSISDB rename for maintenance

We have an SSISDB database that has become too large and we wanted to do some maintenance on it. I've read that you shouldn't rename the SSISDB database as it would break links to existing packages, ...
Nolan St. Martin's user avatar
0 votes
0 answers
164 views

SSIS Data Flow Task indicates it wrote x rows, and reported no errors, but none of the rows appear in destination

This package had worked in the past but, for whatever reason, hasn't been working as intended recently. The package has a script task that sets a file path variable to the file path for the most ...
user3799279's user avatar
0 votes
1 answer
669 views

Using SSIS Project Parameters in SQL Agent Jobs

I'm using SQL Server 2019 and attempting to set up project parameters for my SSIS projects. I've set up project-level parameters within the package itself and those parameters do appear in SSMS for me ...
Nathan C's user avatar
  • 167

1
2 3 4 5
23