2,462 questions with SQL Server Integration Services tags

Sort by: Updated
Updated Created Answers
5 answers

Error Fix (Database engine service failed in sql server 2022 and 2019)

Hello i am having troubles installing sql server 2022. my error is sql database engine fails to starts steps taken to install the sql on my laptop, was that i changed the account name of database engine service ( i did this because i have tried…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,858 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2022-11-23T00:01:59.227+00:00
Nelson Nwachia 36 Reputation points
answered 2024-05-18T08:36:47.0033333+00:00
Alok Jha 0 Reputation points
1 answer

Issue with Excel Destination character size in SSIS

I am trying to export data from a database table in SQL server 19.1 version to a Excel file using SSIS excel destination task. One of the fields 'External Notes' coming from SQL database is VARCHAR(5000). I can export everything to excel but the…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,518 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2024-05-17T11:41:58.3833333+00:00
Dhanvi Bansal 0 Reputation points
answered 2024-05-17T17:56:33.1666667+00:00
Olaf Helper 41,006 Reputation points
4 answers

SSIS Error: The AcquireConnection method call to the connection manager Source failed with error code 0xC0014009.

Hello, We have a Job in MS SQL Server Management Studio. This job runs several Visual Studio SSIS packages. When we launch the job it fails at step one. Step one is to retrieve data from a AS400 DB and place it in some ODS tables within our…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2021-06-17T10:50:35.957+00:00
Romeo Isfan 11 Reputation points
answered 2024-05-17T16:29:25.6866667+00:00
Larry Carrethers 0 Reputation points
6 answers

SQL SERVER 2022 - certificate error when creating a job for integration services

In a test environment with SQL Server 2022 Developer Edition, I am trying to create a job to run an SSIS package. These same packages have been successfully tested in SQL 2019. When trying to create the job, configuring it as follows: General / Owner :…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,858 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2024-04-10T03:35:21.82+00:00
Marcio Matos 30 Reputation points
answered 2024-05-17T16:24:25.9966667+00:00
Carl BRUBAKER 0 Reputation points
1 answer

SSIS - Flat File Destination Fixed Width Columns Appear to be Ragged

I am trying to create a flat file export, the spec is fixed width column, no headers or delimiters. There are 16 columns, the total width of all the columns combined is 624 characters. i have attempted two methodologies, both yield the same result where…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,858 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2024-05-16T22:31:35.1166667+00:00
Ken Wenze 0 Reputation points
commented 2024-05-17T14:26:43.1933333+00:00
Ken Wenze 0 Reputation points
2 answers

Msg 319, Level 15, State 1, Line 88 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.

Create Table #percentpopulationvaccination ( continent nvarchar(255), location nvarchar(255), date numeric, population numeric, New_vaccinations numeric, rollingpeoplevaccinated numeric, ); Insert Into #percentpopulationvaccination select dea.continent,…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,858 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2023-03-31T12:41:12.3266667+00:00
pruthvi salian 0 Reputation points
answered 2024-05-13T06:18:08.44+00:00
Sahil 0 Reputation points
1 answer

query taking long time to match

Hi Team, how to split the query to check data missmatch fint.eabl column if there multiple left joint and taking time to match it query attached

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,858 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,559 questions
asked 2024-05-10T13:40:44.6133333+00:00
Vineet S 185 Reputation points
commented 2024-05-13T02:39:20.27+00:00
CosmogHong-MSFT 23,556 Reputation points Microsoft Vendor
3 answers

An error occurred while extracting the result into a variable of type (DBTYPE_I4) error

I have a simple sql statement which outputs a few columns, whch one of them is a column with an int datatype, but I get the following error when I execute the package, I tried to change the datatype in the flat file but it doesn't seem to work: [Execute…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2023-04-07T12:17:55.7433333+00:00
sql dev 6 Reputation points
answered 2024-05-10T19:35:56.48+00:00
Sai Teja Mikkilineni 0 Reputation points
2 answers

"Could not find the Database Engine startup handle" while trying to install SQL server 2022 Express Edition

Hello, I upgraded my computer to Windows 11 and that's why there was a problem in my SQL server. I deleted the SQL Server 2022 application and restarted the computer. Later, I encountered an error while trying to install SQL Server 2022 Express. Unable…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,858 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,819 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
Microsoft Configuration Manager
asked 2024-04-12T12:42:24.9666667+00:00
Hakan KARATEKE 0 Reputation points
commented 2024-05-10T05:47:47.7+00:00
MikeyQiao-MSFT 575 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

SSMS 20.1 Unable to see SSIS Execution Properties

Ever since I installed SSMS 20.1, I've been unable to look up the properties in SSIS jobs. I'm aware that 20.1 has changed the way connections are made but my connection is set up with "Trust server certificate" and multiple menus error…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,858 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2024-05-07T12:59:51.8066667+00:00
Michel Lalancette 20 Reputation points
commented 2024-05-08T12:12:19.7933333+00:00
Michel Lalancette 20 Reputation points
2 answers

Text delimiter file

Hi, I have two tables: one for headers with 9 fields and another for lines with 6 fields. Both header and lines are highlited in yellow. I need to combine both the headers and lines using a UNION operation to display the result below. From the line…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,858 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
48 questions
asked 2024-05-06T14:48:13.48+00:00
Vicki 46 Reputation points
answered 2024-05-07T02:18:28.6533333+00:00
CosmogHong-MSFT 23,556 Reputation points Microsoft Vendor
4 answers One of the answers was accepted by the question author.

SSIS Error when deploying package, the locale identifier LCID is not supported by SQL Server

Hi I am unable to deploy my project from Visual Studio to SSISDB. I have tried to change my localename and locale as well as my region. I have also made MYSQL Server login local but the below error still persists. Can anyone provide guidance TITLE: SQL…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
722 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,858 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2021-05-03T11:51:51.583+00:00
Lynn Carelse 21 Reputation points
answered 2024-05-06T23:54:14.06+00:00
Santiago Guerrero Toro 0 Reputation points
1 answer One of the answers was accepted by the question author.

SQL SSIS on Separate Server

Hi, I'd like to confirm if we need a another SQL license for the server where SSIS will be installed aside from the primary SQL Server? Thank you, Jovsp

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,858 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2024-05-06T02:30:31.79+00:00
ovsp 166 Reputation points
accepted 2024-05-06T05:39:01.97+00:00
ovsp 166 Reputation points
2 answers

SSIS task through SQL Agent showing OLEDB 16.0 not registered after install

Hi all, we're currently having issues trying to have a job run on a schedule via SQL Agent using the OLEDB 16.0 64-bit connector using an excel file. The job runs fine locally in Visual Studio, where I have the 64-bit OLEDB 16.0 installed. However when…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,858 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2024-04-30T09:09:43.8766667+00:00
Thomas Davies 20 Reputation points
answered 2024-05-06T02:19:10.93+00:00
ZoeHui-MSFT 33,386 Reputation points
2 answers One of the answers was accepted by the question author.

How to handle text file with delimiter as ~|~ in SSIS Package

I received text file from external vendor with appears to be Pipe Delimited but it has very unusual character before and after Pipe (|). I am using SSIS Package (VS 2019) to import the data into SQL Server database 2019. I am using SQL Agent Job to…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,858 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2024-05-04T00:46:30.9766667+00:00
Villa 186 Reputation points
accepted 2024-05-06T01:03:42.22+00:00
Villa 186 Reputation points
1 answer One of the answers was accepted by the question author.

Problem with FINDSTRING in SSIS Expression

Best regards. I have a problem when I am trying to use the FINDSTRING function in SSIS of Visual Studio 2022. It gives me the following error, even when I try to use the reference examples from the Microsoft page…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2024-05-02T21:57:47.1666667+00:00
Jorge Hernán Ramírez Jaramillo 20 Reputation points
commented 2024-05-03T15:00:17.74+00:00
Jorge Hernán Ramírez Jaramillo 20 Reputation points
8 answers

SSIS Data Flow Task error - The version of the Flat File destination is not compatible with this version of the dataflow.

I am trying to edit an SSIS package and getting the error "The version of the Flat File destination is not compatible with this version of the dataflow." when trying to run it from a SQL Agent Job or when performing a validation on the SSIS…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2020-10-15T14:09:43.287+00:00
WMB853 6 Reputation points
commented 2024-05-02T18:12:14.9+00:00
Mike Murphy 0 Reputation points
1 answer

We are using windows 2022 server with SQL 2022, the problem is that after sysprep execute ,sql analysis failed with Error:Failed to encrypt sensitive data. Possibly the encryption key is inaccessible because of improper service account change

After upgrade the image to win22 and sql22. Not able to run bam Analysis service getting error Microsoft.BizTalk.Bam.Management.BamManagerException: The BAM deployment failed. ---> Microsoft.AnalysisServices.OperationException: Errors in the…

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,239 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,248 questions
asked 2024-02-09T08:23:31.9833333+00:00
Kasireddy Alekhya Alekhya (MINDTREE LIMITED) 0 Reputation points
commented 2024-05-02T04:35:23.5833333+00:00
gijs reijn 0 Reputation points
1 answer

Microsoft connector for Teradata source doesnt work within VS2019 SSIS package development

Hi there, I installed 'Microsoft connector for Teradata' to use 'teradata Source' component within dataflow task but its not working when I try to add this : TITLE: Microsoft Visual Studio The component could not be added to the Data Flow task. Could…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2021-07-02T10:53:21.133+00:00
Kikot, Pavel 11 Reputation points
commented 2024-05-01T13:44:58.01+00:00
Jason-3733 0 Reputation points
2 answers One of the answers was accepted by the question author.

Download link for Microsoft.ACE.OLEDB.12.0

We need the Microsoft.ACE.OLEDB.12.0 32 bit install, can someone please provide a link. We need the functionality to import excel files in via SSMS so the 32 bit driver is required

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,858 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2024-04-19T14:09:09.57+00:00
Thomas Davies 20 Reputation points
commented 2024-04-30T08:34:46.6166667+00:00
Thomas Davies 20 Reputation points