SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,655 questions
1 answer
Unable to access SQL over VPN
We have an on-premises Active Directory with Azure AD synchronization (ie: a hybrid environment). Our on-prem includes two separate AD forests that are connected with a two-way trust. For name sake, i'll call these: AD1.local and AD2.local. All client…
asked 2025-02-27T12:04:55.5+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 90%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Philip Preece
41
Reputation points
answered 2025-02-28T09:02:26.6666667+00:00
Philip Preece
41
Reputation points
1 answer
One of the answers was accepted by the question author.
Compatibility Issues Power BI Desktop / SQL (version mismatch?)
Hello, I am working on building a set of SharePoint sites, each will have a dashboard generated by Power BI (source of data -> ERP: Vista from Viewpoint) While testing the connectivity of Power BI Desktop using the most recent version (v…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 34%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
0 answers
always encrypted with secure enclave not working for DETERMINISTIC in JDBC
I'm using commercial Azure SQL, the database created via the portal, with secure enclaves enabled. I created the CMK and CEK using MSSQL_JAVA_KEYSTORE with keystore jks file. when using jdbc to test query for like and =, if the encrypted column is of…
asked 2025-02-24T12:03:24.69+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 39%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
John Woo
0
Reputation points
commented 2025-02-26T22:09:11.99+00:00
Erland Sommarskog
117.8K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
How to enable dark mode
How to enable dark mode in SSMS？ I could not find the option to do that.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 62%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
0 answers
SSMS Not allowing me to filter Databases
Hi. I am running a SQL EXPRESS Server on SSMS 2018. Normally on other VMs I can filter by Database Name, on this server which is my new main server, that option is greyed out with no reason why. I currently cannot find any resources that explain why!
asked 2025-02-25T16:18:04.6933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 25%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHK%3C/text%3E%3C/svg%3E)
Huxley Kendell
0
Reputation points
commented 2025-02-26T01:38:58.88+00:00
ZoeHui-MSFT
41,126
Reputation points
1 answer
One of the answers was accepted by the question author.
Fail to install sql 2022
FFail to install sql server2022 dev on my machine. I have install and reinstall for several times. It always said that error corrupted.
2 answers
SQL Server 2022 error when downloading – taking more than 24 hours and still not resolved!
From my research, it seems that everyone is facing this issue, yet there is still no solution. I’m not sure what Microsoft is waiting for to fix this problem. I have completely uninstalled and reinstalled it, but I keep encountering the same issue. I…
asked 2025-02-21T15:45:18.37+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 68%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
James Flush
0
Reputation points
commented 2025-02-24T21:44:05.29+00:00
Erland Sommarskog
117.8K
Reputation points MVP
3 answers
One of the answers was accepted by the question author.
SSIS An error occurred while attempting to perform a type cast.
The SQL Server has been updated to SQL 2022 (compatibility mode 150). The same file that works in production, now gives an error in Stage Error: 0xC0049064 at Load Flat File, Derived Column File [2]: An error occurred while attempting to perform a type…
asked 2025-02-20T16:35:43.11+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 31%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Naomi Nosonovsky
8,191
Reputation points
accepted 2025-02-21T11:46:26.7+00:00
Naomi Nosonovsky
8,191
Reputation points
0 answers
Assistance Needed with SQL Server Installation and Setup
I am experiencing difficulties while trying to install SQL Server 2019 on my machine. Despite following all necessary steps, I am encountering issues that prevent me from successfully setting up the server. Specifically, I am facing challenges when…
asked 2025-02-20T14:54:12.08+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 24%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
David Dimitrov
0
Reputation points
commented 2025-02-21T02:39:14.3833333+00:00
LiHongMSFT-4306
30,826
Reputation points
1 answer
ODBC Source Task - KISAM ODBC Driver - Unable to retrieve list of tables or run SQL script
I'm attempting to upgrade a package from SSDT_BI 2013 to Microsoft SQL Server Data Tools for Visual Studio 2017 (SSDT) with version 15.1.62002.01090. However, I'm encountering an issue where I cannot retrieve the list of tables or execute SQL scripts…
asked 2023-08-24T06:49:50.4433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 34%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
Vani Priya
5
Reputation points
commented 2025-02-20T17:31:33.77+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 9%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Mark Lund
0
Reputation points
1 answer
Migrate SSISDB Integration Service Catalog
Hi Expert, My organization plan to migrate SQL instance to new system, there is many project folder in Integration Service Catalogs - SSISDB I've got idea to migrate project folder on this part at once to minimizing migration time duration if any, is…
asked 2025-02-20T03:37:24.2233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 96%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
UrBel
220
Reputation points
answered 2025-02-20T05:20:05.9266667+00:00
ZoeHui-MSFT
41,126
Reputation points
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…
asked 2021-11-19T14:32:00.537+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 41%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Alex Fletcher
61
Reputation points
commented 2025-02-19T14:46:42.1566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 52%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jeffrey Howard
20
Reputation points
2 answers
An integration services catalog was not found on this server instance
Hi, One of our developers is getting the error in the title when trying to deploy an integration services package from his laptop using VS 2019. The SQL server is also 2019 (I think) We can confirm the catalog exists as other developers can connect and…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 92%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
about the SQL code in SSIS-Tutorial-Lesson-1-6
Hello There, I recently started practicing SSIS-tutorial, and am in Tutorial -- Lesson 1-6; While executing the steps in the document, under the Heading "Add and configure the Lookup Currency Key transformation" I couldn't…
asked 2021-05-18T19:47:03.91+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 74%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
ArunRaaman
1,001
Reputation points
edited an answer 2025-02-19T09:22:42.3666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 37%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EER%3C/text%3E%3C/svg%3E)
Edmund Roux
0
Reputation points
1 answer
Could not load file or assembly 'Newtonsoft.Json, Version=13.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed
Hi I have added a NewtonSoft. JSON dll in Script task, it is working locally, when deployed and trying to run through SQL Agent Job, getting error as "Could not load file or assembly 'Newtonsoft.Json, Version=13.0.0.0, Culture=neutral,…
asked 2025-02-18T13:42:53.2+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 37%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Ajay Jha
0
Reputation points
answered 2025-02-19T02:43:09.49+00:00
ZoeHui-MSFT
41,126
Reputation points
1 answer
SSIS Customs connections are not getting fetched as part of Microsoft.SqlServer.Dts.Runtime.Connections using sql version 2022
Hi Team, I am using custom component for ssis . It works fine for sql 2016 using vs2019 but as soon as i change the target sql version to 2022 ,it doesn't worked. While debugging i found that the connection which i created using custom connection…
asked 2023-02-18T09:42:43.23+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 77%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sanjay Sharma
0
Reputation points
commented 2025-02-17T18:07:47.7233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 60%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tyler Sand
0
Reputation points
8 answers
Custom ConnectionManager always returns null at runtime
I have written a very simple custom connection manager inheriting from ConnectionManagerBase. My acquireconnections and release works as it should in design time on my source component. The issue is when I try and execute it in Visual Studio. I associate…
asked 2021-03-13T06:35:27.367+00:00
ManicFarmer
16
Reputation points
commented 2025-02-17T17:18:59.2366667+00:00
Tyler Sand
0
Reputation points
8 answers
SQL Server 2022 Developer Edition - Installation of the SSIS Integration Services
Hello to all, I have been trying to do the one Integration Services installation on my SQL Server 2022 Developer Edition environment. Unfortunately I always get errors during the installation, these are mainly related to the installation of Microsoft OLE…
asked 2023-02-20T09:37:55.24+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 97%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Alessandro Di Pasquale
15
Reputation points
commented 2025-02-13T22:18:09.2833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 30%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jindra
0
Reputation points
2 answers
Minimum Cost to run just a SQL Server Single DB
I have a SQL server basic DB. It is supposed to cost $7.20USD per month. Why after 2 days do I have bill of $50USD. $48 for Sql Server Core and $1.56 for storage and $0.36 for DTU? Th DTU sounds close (but we only did 3000 inserts of 2 doubles and 3…
asked 2025-02-12T23:19:39.6733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 57.99999999999999%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGK%3C/text%3E%3C/svg%3E)
Glen Kleidon
0
Reputation points
answered 2025-02-13T01:16:42.2433333+00:00
ZoeHui-MSFT
41,126
Reputation points
2 answers
One of the answers was accepted by the question author.
SSIS Data from SQL Server into an Excel File Using SSIS
Good day, I have data like the below: CREATE TABLE [dbo].[test_data]( [Local_Site] [varchar] NULL, [LM_Company] [int] NULL, [TotalStaff] [int] NOT NULL, [NewOpp] [nvarchar] NULL, [ExistOpp] [nvarchar] NULL, [EasyTarget] [int] NOT NULL, [GoldTarget] [int]…
asked 2025-01-30T10:30:43.9133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 39%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rontech10111
161
Reputation points
accepted 2025-02-12T06:52:47.22+00:00
Rontech10111
161
Reputation points