Questions tagged [ssis]
SSIS (Microsoft SQL Server Integration Services) is a platform for building enterprise-level data integration and data transformations solutions. SSIS is used to perform ETL operations; i.e. extract, transform and load data.
21,310
questions
0
votes
0
answers
26
views
Three types of errors occuring when deploying a SSIS package through Azure DevOps
I have a typical SSIS package which contains many loads from source CSV to destination in on-prem SQL Server, the data flows look like this - Data Flow
Outside of data flow its mainly just Logging ...
- 3
-1
votes
0
answers
15
views
C# Signed Overpunch Logic Does Not Produce Negative Values
I'm working with a series of text files that contain signed overpunch values. I've programmed the following logic to replace the values and return a decimal.
public static decimal ...
- 3,171
0
votes
0
answers
18
views
IBMi Driver for Azure Data Factory - Integration Runtime Script
I've been trying to create a script to install a IBMi driver for Azure Data Factory Integration Runtime SSIS Lift and Shift
The driver is named ACS Windows App Pkg English (64bit)
https://www.ibm.com/...
- 1
0
votes
0
answers
16
views
SSIS package export to Sharepoint site
I have an SSIS package, which exports data to an MS Excel spreadsheet.
I want to upload that MS Excel spreadsheet on to a sharepoint site, within the SSIS Package.
Is there a way of doing this without ...
0
votes
0
answers
9
views
+50
Adapting default settings of new SSIS packages
In earlier versions of SSIS I could adapt the file Integration Services Project.dtproj to set some defaults for new packages such as protectionlevel and targetserverversion.
However, I do not seem to ...
- 1,590
0
votes
0
answers
20
views
unpivot and pivot conversion from sql server to postgres
I am trying to perforrm conversion from sqlserver script to postgres
postgres not supporting format,unpivot and pivot function is there any alternate method to convert these to postgres
select [values]...
- 1
0
votes
1
answer
14
views
SSIS Convert time to seconds
I receive an excel file with time fields in the format :00:00, but there are times when the hour will be populated
| Time | Seconds
| --------
| 1:03:48 |
| :52:10 |
I'm having a bit of trouble ...
- 11
-1
votes
0
answers
41
views
C# caused a format change of the German alphabet in SSIS package
In SSIS, i have a "Data Flow", which contains "OLE DB Source" and Flat File Destination (CSV).
The Original CSV is also UTF-8:
The Flat file is UTF8:
When I Run it, data ...
- 85
0
votes
0
answers
34
views
SSIS Package Generates Correct File Name in SSDT, but SQL Server Agent Job Uses Default Name
I have an SSIS package that generates a CSV output file with a dynamically generated name based on the current date and time. The expression for the file name is set in the FilePath variable within ...
- 17
-1
votes
1
answer
32
views
SSIS Script Component Used as Source Does not Write Rows to SQL Destination
I'm using SSIS in Visual Studio 2019 to read fixed width text files. Depending on the first character of each row in the fixed width file, I'm sending the line to one of two specified outputs. Both ...
- 3,171
0
votes
1
answer
12
views
SSIS export SQL result to csv but the column order changed
I am trying to use a Data Flow Task to export a SQL query result into csv file. It's a very simple SQL. The column PTLASTUPDATEDDTTM is a DATETIME type. My SQL have to convert its format:
select rtrim(...
- 101
0
votes
1
answer
32
views
The buffer manager has allocated 104,857,600 bytes, even though memory pressure has been detected and repeated attempts to swap buffers have failed
When I executed the SSIS package, I received the following error:
The buffer manager has allocated 104,857,600 bytes, even though memory pressure has been detected and repeated attempts to swap ...
- 1
0
votes
1
answer
22
views
SSIS dynamically Execute Package Task: Package Name is missing
I want to run multiple packages using Execute Package Task. There is a table in database saves the package names. I create a SQL Query Task first. The query result is a list of package names:
Then I ...
- 101
0
votes
1
answer
31
views
Trying to convert time format 0:00:00 to seconds (integer)
Trying to convert time format 0:00:00 to seconds (integer), to use as a derive column in SSIS. I've tried (DT_I4)TOKEN(column,":",1) * 60 + (DT_I4)TOKEN(column,":",2), but it is ...
- 11
1
vote
1
answer
61
views
Debugger issues with Visual Studio 2022 Community Edition with SSIS Extension
Having an issue debugging in Visual Studio 2022 Community Edition with SSIS SQL Server Integration Services installed.
A Script Task (VB code) runs without issue. However, after placing a BREAKPOINT ...
- 11