SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,645 questions
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…
asked 2025-02-17T08:47:10.6066667+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(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)
Farid Ali
0
Reputation points
commented 2025-02-18T17:13:35.42+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, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
26,376
Reputation points
0 answers
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,…
![](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)
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
40,661
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
2 answers
One of the answers was accepted by the question author.
TITLE: Microsoft Visual Studio ------------------------------ Cannot map the input column, 'CurrencyDate', to the lookup column, 'FullDateAlternateKey', because the data types do not match. ------------------------------ BUTTONS: OK -------------------
i have changed the data types to DT_DBDATE as instructed but when trying to map the fields, it keeps saying I cannot map the currencyDate to the lookup column, FulldatealternateKey, because datatypes do not match
asked 2024-08-14T12:50:28.01+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(204.8, 60%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Joel Manhede
20
Reputation points
commented 2025-02-11T23:21:11.71+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(217.60000000000002, 95%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMF%3C/text%3E%3C/svg%3E)
MD Friedman
0
Reputation points
3 answers
SSIS - package working only when there is breakpoint
I have a SSIS package which contains different sequence container, the problem is when I execute the whole package, it executes first 2-3 containers then gets Index out of bound error in next container (In a script task inside a data flow task). But…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,645 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
11,306 questions
asked 2021-09-03T14:21:23.33+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(256, 1%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
SUNGHOON Kritesh
6
Reputation points
commented 2025-02-11T22:17:14.7433333+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(32, 6%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jeff Ballard
0
Reputation points
2 answers
ODBC Native Client 10 Performance Issues After Windows 11 Update
A legacy application using ODBC Native Client 10 has encountered significant performance issues following the latest Windows 11 update. The application previously worked well, but now it is unacceptably slow. The environment includes an in-house MSSQL…
asked 2025-02-10T18:36:21.1833333+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(6.4, 32%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
Darwin Weyh
0
Reputation points
commented 2025-02-11T22:11:13.4033333+00:00
Erland Sommarskog
117.2K
Reputation points MVP
1 answer
how to migrate SSIS integration packages from SQL 2008 to 2019
Hi, i wanted to migrate my sql server from 2008 to SQL 2019, it also has SSIS packages, how can i migrate them from SQL 2008 to SQL 2019 Thanks
asked 2023-01-17T17:16:25.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(22.400000000000002, 86%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SaikrishnaE
51
Reputation points
commented 2025-02-11T15:18:25.4766667+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(3.2, 17%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELJ%3C/text%3E%3C/svg%3E)
Lourdusamy, Julliet
0
Reputation points
2 answers
VS - How to fix "Could not load file or assembly 'Newtonsoft.Json, Version=13.0.0.0"
Hi, I have created a new SSIS project in Visual Studio, and there is a Script Task built in the SSIS package. This Script Task is used get a bearer token from an API website, this C# script run successfully in C# Console. When I run the Script Task…
asked 2025-01-31T11:58:33.4366667+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(246.4, 9%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
Jocelyn Kwong
0
Reputation points
commented 2025-02-06T17:09:14.7066667+00:00
Jocelyn Kwong
0
Reputation points
1 answer
One of the answers was accepted by the question author.
ADF - CSV file with more than 2000 columns, need to create multiple tables in the sqlserver using Azure Data factory
I have csv file with more than 2000 columns and 20gb file size. Have to create multiple tables in sqlserver from the csv file using Azure Data factory. here is the file columns col1 col2 col3 col4 col5 col5 ...... i have to create tables with below…
asked 2025-01-31T13:53:58.33+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(156.8, 56.00000000000001%, 25%)' 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)
Anil
40
Reputation points
edited the question 2025-02-05T01:22:59.58+00:00
ZoeHui-MSFT
40,661
Reputation points
2 answers
SqlServer.ManagedDTS DLL Reference Error for Visual Studio 2019
Hello Everybody; Visual Studio 2019 Enterprise v16.11.15 Sql Server Integration services v3.16 I try to Load my DTSX Package as File from Framework C# solution. I add reference Microsoft.SqlServer.Dts.Runtime to my project throwing…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,645 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
11,306 questions
asked 2022-10-06T12:51:04.557+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(73.60000000000001, 2%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKJ%3C/text%3E%3C/svg%3E)
Kamel Jtita
1
Reputation point
commented 2025-02-05T00:13:38.2333333+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(188.79999999999998, 54%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWB%3C/text%3E%3C/svg%3E)
Wendell Beverly
0
Reputation points
3 answers
One of the answers was accepted by the question author.
SSIS pkgs not showing
Hello, I migrated some SSIS packages from instance A to Instance B where SSIS catalog and SSISDB is already there. Now When i connect to SQL Server Instance B using Visual Studio, i cannot see the packges/projects... Or if connect to SSIS on instance…
asked 2025-02-04T05:51:42.21+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(12.8, 21%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBH%3C/text%3E%3C/svg%3E)
Bilal H. Bhatt
136
Reputation points
accepted 2025-02-04T10:07:37.8133333+00:00
Bilal H. Bhatt
136
Reputation points
2 answers
One of the answers was accepted by the question author.
ssis is missing
I can not find the SSIS toolbox option on my ssis project. Tried restarting VS and machine many times, pls help
![](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(272, 45%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
What is the best Azure Integration if I want to have an active synchronization between an on premise database and Azure cloud database
I would like to integrate my on premise SQL Server database with the Azure cloud database such that there both contain the same data. If there is no internet, users can connect to the on premise database and continue to work.
asked 2025-01-21T12:47:36.09+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, 0%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFS%3C/text%3E%3C/svg%3E)
Fortified Solutions P/L
20
Reputation points
edited the question 2025-02-04T07:54:35.9766667+00:00
Prrudram-MSFT
27,786
Reputation points
1 answer
SSIS Ole DB Source Editor - Error: No Column Information Returned by SQL Command
The Ole DB Source Editor was functioning correctly with the Data Access Mode set to SQL command, using a query that included a parameter. Sample Query: SELECT * FROM view_CUSTOMER_DATA WHERE ACTIVE = 'Y' and LAST_SHOPPING_DATE = ? A parameter with a…
asked 2025-01-28T05:06:39.1+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(35.2, 77%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVO%3C/text%3E%3C/svg%3E)
Vikram Oza
0
Reputation points
commented 2025-02-04T02:58:50.98+00:00
LiHongMSFT-4306
30,751
Reputation points
1 answer
How can I get any Registry Entry for SSMS 21 where I can modify any plugins.
For all the versions till SSMS v20, there is registry entry as follows: Computer\HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\<SSMS.Version>.0_IsoShell_Config\ where we can configure customized items like menu, toolwindow,…
asked 2025-01-30T12:36:16.67+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, 32%, 19%)' 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)
Vaibhav Pol
50
Reputation points
answered 2025-02-03T05:26:27.2733333+00:00
ZoeHui-MSFT
40,661
Reputation points
1 answer
One of the answers was accepted by the question author.
self join in ssis
HI Expert, If i want to run pipeline for table1 which has self join with same table and updating flag on created and updated on target table... how this this can be done in ssis
asked 2025-01-30T18:20:16.8766667+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(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vineet S
1,370
Reputation points
commented 2025-02-03T03:30:17.9333333+00:00
ZoeHui-MSFT
40,661
Reputation points