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,314
questions
0
votes
0
answers
14
views
Why won't Windows 11 allow an Administrator to run gacutil.exe?
I am creating .dtsx packages with Script Components on a development (DEV) machine using VS2019. DEV is Windows 11 Enterprise 64 Bit and I have local administrator rights.
Because it seems like ...
0
votes
1
answer
16
views
Getting an error with a union in SSIS, "The Metadata for union does not match the metadata for the associated output column." Any ideas?
I am working with SSIS in Visual Studio 2019, and I am trying to do something fairly simple. In the data flow I load data from two flat files (basically, half the data set in each file), union them ...
0
votes
0
answers
43
views
SSIS flat file destination, how to write line ending \\x00\\x00\\x0d\\x0a?
We have a required format of flat file, it's a text file with multiple columns of fixed length, and each record corresponds to one line in the text file. In this format, the line ends with \\x00\\x00\\...
0
votes
0
answers
8
views
SSIS Serialized OnError Tasks logging error on SQL Server and sending email
I do have a quite big project in SSIS, with multiple packages, and some MASTER packages using them.
I want to find the best method to log errors, and send an email on failure.
For that here are some ...
0
votes
0
answers
34
views
Cannot map the input column, 'Date', to the lookup column, 'Date', because the data types do not match
I'm getting this error:
TITLE: Microsoft Visual Studio
Cannot map the input column, 'Date', to the lookup column, 'Date', because the data types do not match.
Data type in SSMS
Changed type to date, ...
0
votes
0
answers
51
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 ...
-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 ...
0
votes
0
answers
20
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
13
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 ...
0
votes
0
answers
21
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]...
0
votes
1
answer
18
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 ...
-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 ...
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 ...
-1
votes
1
answer
39
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 ...
0
votes
1
answer
13
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(...