2,625 questions with SQL Server Integration Services tags

Sort by: Updated
1 answer

How to export data from SQL Server SSIS to Parquet file format and compress it using Snappy

the challenge is to export data from SQL Server SSIS to Parquet file format and compress it using Snappy. The expected list of tables to exported to Parquet file are 650.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 questions
asked Jan 7, 2025, 6:57 PM
Mohammed Aslam Yousuf Hussain 0 Reputation points
answered Jan 8, 2025, 2:33 AM
ZoeHui-MSFT 39,271 Reputation points
2 answers

SSIS Support for JIRA REST API

Hello, I am using SQL Server 2017 with SSIS 2017. Does SSIS support importing data using JIRA REST API directly or do we have to install/add some third-party connectors or drivers to SSIS first? Thanks

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 questions
asked Oct 10, 2021, 10:01 AM
Anonymous
edited a comment Jan 7, 2025, 6:11 AM
pankaj (ZappySys Team) 5 Reputation points
1 answer

SSIS : How to access SharePoint site and load data from SharePoint using SSIS to SQL database ?

Hi All - I am looking for help. I have an requirement of pulling the data from Sharepoint site into SQL database using SSIS. What could be the pre-requisites to build the SSIS package ? Do i need the sharepoint site username and password ? …

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,402 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.
14,254 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,025 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 questions
asked Apr 11, 2023, 10:08 PM
kkran 831 Reputation points
edited a comment Jan 7, 2025, 5:39 AM
pankaj (ZappySys Team) 5 Reputation points
1 answer

How to modify SSIS "Flexible File Source" character limit

Hello everyone, I use SSIS to pour CSV data into a database. I use the "Flexible File Source" package to get data from Azure Blob Storage. When trying to do that with a rather big CSV file, I got one of my values that got truncated. I did a bit…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 questions
asked Jan 3, 2025, 2:05 PM
D2d3d4d5 0 Reputation points
answered Jan 6, 2025, 1:55 AM
ZoeHui-MSFT 39,271 Reputation points
2 answers

Access denied SSIS

Hi, While i am trying to access SSIS through Visual Studio, i am getting below error *connecting to the integration services service on computer "abcdef" failed with following error :"Access denied". I gave the permission in the DCOM…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 questions
asked Jan 1, 2025, 4:42 AM
Bilal H. Bhatt 116 Reputation points
edited an answer Jan 5, 2025, 10:11 PM
Yitzhak Khabinsky 26,296 Reputation points
1 answer

SSIS package that supposed to export data from SQL to Excel stopped working after upgrading to SQL2022

Hello. We have multiple SSIS packages that import data from Excel into SQL and export results back to Excel. All those SSIS packages were designed in VS 2012, connecting to SQL 2012 and Excel 2013, and we can run it successfully as a part of SQL job or…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,063 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.
14,254 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 questions
asked Oct 30, 2024, 7:46 PM
Alla 0 Reputation points
commented Jan 4, 2025, 12:47 PM
Tim Freeman 0 Reputation points
0 answers

MSSQL 2022 - SSISDB ETL returning "...failed with the following error: "An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. "

Full error from the Integration Catalog in question: SQL Load Queue List into Object:Error: Executing the query "EXEC [My PROC name]" failed with the following error: "An error occurred in the Microsoft .NET Framework while trying 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.
14,254 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 questions
asked Dec 26, 2024, 4:44 PM
Fred Bartley 0 Reputation points
commented Jan 2, 2025, 10:14 PM
Fred Bartley 0 Reputation points
1 answer

How to Force SSIS in Visual Studio 2022 to use ODBC Version 2.5 Connection

Hi, I have to migrate SQL Server SSIS packages from a legacy machine onto a new one. The legacy machine used - as the IDE - Visual Studio 2017. These packages copied data from an existing 3rd-party system using their ODBC driver as the source…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 questions
asked Dec 9, 2024, 2:17 PM
Mr. C 0 Reputation points
commented Jan 2, 2025, 2:42 PM
Mr. C 0 Reputation points
2 answers

Enabling OAuth 2.0 for SQL Server Database Mail System

Hello Team, I previously encountered an issue with sending emails from SQL Server where I received an authentication error due to basic authentication being disabled. The team suggested implementing OAuth 2.0, but I struggled to find proper articles or…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,254 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 questions
asked Dec 26, 2024, 10:43 AM
Avinash 20 Reputation points
commented Jan 2, 2025, 6:33 AM
NIKHILA NETHIKUNTA 4,010 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Visual Studio Community Integration Services and Licensing

Hello, My questions probably been asked before but I need to be sure and would like to know, what is the difference using community and enterprise version? Let say i have a limited resource , what if I purchase SQL Server License, made a SSIS package…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,254 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
238 questions
asked Dec 30, 2024, 1:23 PM
Rino Yaohari 20 Reputation points
accepted Jan 1, 2025, 2:03 PM
Rino Yaohari 20 Reputation points
1 answer

SQL Server Enterprise 2019 not core 21 up to

Currently, I am using Windows Server 2016 and SQL Server Enterprise 2019, but the SQL system only utilizes 20 cores, even though I have allocated 60 cores to the server. I have tried the following commands: EXEC sp_configure 'affinity mask', 0; EXEC…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,254 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,517 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 questions
asked Dec 26, 2024, 4:30 AM
Nguyen ngoc giang 0 Reputation points
edited an answer Dec 31, 2024, 5:54 PM
Jon Gurgul 6 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

ssis develop with VS2019

Where can i download VS2019 to design my ssis2019 package?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 questions
asked Dec 30, 2024, 7:57 AM
Jefferson-2765 566 Reputation points
accepted Dec 30, 2024, 8:32 AM
Jefferson-2765 566 Reputation points
6 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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,254 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 questions
asked Nov 23, 2022, 12:01 AM
Nelson Nwachia 61 Reputation points
commented Dec 27, 2024, 3:30 AM
Kunal Singh 0 Reputation points
1 answer One of the answers was accepted by the question author.

Unable to Send Emails from SQL Server

There is an issue with sending emails from SQL Server, accompanied by the following error message: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2024-12-03T11:05:46). Exception Message:…

SQL Server on Azure Virtual Machines
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,254 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 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,302 questions
asked Dec 23, 2024, 8:38 AM
Avinash 20 Reputation points
commented Dec 23, 2024, 11:44 AM
Naveen Kumar M 75 Reputation points
2 answers One of the answers was accepted by the question author.

How to share my SHIR (Self Host Integration Runtime) service with different azure services

I have created a SHIR service for my Azure Synapse Analytics service where I used to perform data operation from Azure Synapse to my On prem SQL Server using my SHIR service. However I wanted to use the data of my on prem SQL with Azure data factory…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,113 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,082 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 questions
asked Dec 17, 2024, 7:34 AM
Sayeed Ahmed 20 Reputation points
accepted Dec 19, 2024, 1:24 PM
Sayeed Ahmed 20 Reputation points
2 answers One of the answers was accepted by the question author.

SQL Server 2022 installation error- Cannot find the path specified

I am trying to install MS SQL SERVER 2022 in my Windows 11 hp laptop. Getting this error Unable to install SQL Server (setup.exe). Exit code (Decimal): -2147467259Error description: The system cannot find the path specified i tried express installation…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,254 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 questions
asked Dec 2, 2024, 8:28 AM
Ashutosh Kumar Yadav 20 Reputation points
commented Dec 18, 2024, 10:11 PM
Erland Sommarskog 114.9K Reputation points MVP
6 answers

SQL Server Excel Import - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

I'm trying to do a simple Excel import into a local SQL Server instance installed on my machine (to do some analysis), I'm attempting to use the wizard through SSMS. This worked a few days ago and I imported a couple of thousand tabs into tables in SQL…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,254 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 questions
asked Nov 19, 2021, 2:32 PM
Alex Fletcher 61 Reputation points
commented Dec 18, 2024, 8:37 PM
Cassandra Lopez 0 Reputation points
1 answer

Trying to connect to the Fabric Lakehouse from the SSIS Package. However it is failing when executing the package

I have Fabric Lakehouse as a Source , I am able to connect to the Fabric Lakehouse via Authentication as "ActiveDirectoryPassword" from SSMS without any issue. I am creating the SSIS package and created the ADO.NET connection Manager and…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,519 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 questions
asked Dec 12, 2024, 10:39 PM
Vineeta Trivedi 0 Reputation points
commented Dec 16, 2024, 1:42 AM
Chandra Boorla 6,130 Reputation points Microsoft Vendor
1 answer

SSIS Incremental Extract and Load for Multiple Tables in one Job / Pipeline

Greetings, We have one Source System DB (SQL) which had 120 Tables. I want to Extract all Tables (120) from Source Database and then Load them in Target Database (which is also SQL). Key Requirements: I want to run this as Job, one time daily …

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 questions
asked Dec 12, 2024, 12:02 PM
Dinesh Kumar Sharma 20 Reputation points
answered Dec 13, 2024, 5:22 AM
ZoeHui-MSFT 39,271 Reputation points
2 answers

User access failure SQL integration

Hi, im having this issue. How can I grant myself the proper access to pass this stage? I tried everything but it still running into same issue. A screenshot of the issue I'm having is below. How can I resolve this

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,254 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 questions
asked Dec 11, 2024, 8:09 PM
ZM-3283 40 Reputation points
answered Dec 12, 2024, 7:33 AM
Olaf Helper 45,381 Reputation points