SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
1 answer
One of the answers was accepted by the question author.
Web service with SQL server lost connection
I have a complicated SSIS package with child packages, and it scheduled as a SQL agent ETL job. One of the steps is to call a .net application that calls a web service. The web service is hosted on a web server, then it queries the database on the…
![](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(147.20000000000002, 18%, 24%)' 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)
3 answers
SSIS Error "Could not create a managed connection manager." in VS2022
I just upgrade MSSQL and VS to 2022 and I have a data flow where the destination is an Always encrypted table in SQL Server. I switched the cllient provider to the Microsoft SQLClient Data provider, The connection test is successfull, the data preview…
asked 2024-03-09T03:39:39.3033333+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(307.2, 4%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Ricardo Silva
6
Reputation points
answered 2024-03-12T22:51:08.1933333+00:00
Ricardo Silva
6
Reputation points
0 answers
SSIS script task SMO call fails when running from Windows 2016 Server (sql server agent) but succeeds when run from Visual Studio or Windows 2012
This SSIS package is part of the scheduled process that worked fine for years. It started failing after we upgraded OS of SSIS SQL Server (application server) from Windows Server 2012 to Windows Server 2016. Note that this SSIS package (contentious…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,643 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,809 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
asked 2023-03-24T15:48:11.8233333+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(307.2, 68%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
Ed
41
Reputation points
commented 2024-03-12T12:45:11.2066667+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, 77%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Richard Swinbank
372
Reputation points MVP
2 answers
Run SSIS package through Server its working fine but that package I am running on my local system its not working.
I am using 2016 SSMS client on my local system [SSMS-Setup-ENU.exe] . I am using 2017 visual studio. I created a package on Visual Studio 2017 , this package is based on package deployment model, I'm running this package through powershell and call the…
asked 2024-03-06T11:49:24.4166667+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(51.2, 38%, 14%)' 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)
Jerry_2424
0
Reputation points
commented 2024-03-08T06:09:01.2533333+00:00
Jerry_2424
0
Reputation points
1 answer
Why does performance degrad when inserting into columnstore based on guidance?
With reference to this article, https://learn.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-data-loading-guidance?view=sql-server-2016, it is suggested to have bulk load sizes (no of rows) between 102,400-1,048,576. Based on…
asked 2024-03-06T10:10:21.3966667+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(48, 65%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Sunil Mathew
0
Reputation points
answered 2024-03-08T01:44:32.7766667+00:00
ZoeHui-MSFT
33,296
Reputation points
0 answers
Compilation Error in SSIS script Task
Dear Expert, I have gotten the script to change the data type of the excel using C#. The code is working when I use the console app in visual studio. But its not working when using SSIS script task in visual studio. Its have the compilation error. I'm…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 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.
10,308 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,532 questions
asked 2024-03-06T09:06:19.43+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(19.2, 96%, 11%)' 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)
jn93
651
Reputation points
edited the question 2024-03-07T06:26:21.2166667+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(64, 85%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJX%3C/text%3E%3C/svg%3E)
Jiale Xue - MSFT
34,276
Reputation points Microsoft Vendor
1 answer
Extracting real-time data from API to SQL Server database using SSIS
I'm new to SSIS and trying to extract real-time data from an API into an SQL Server database for ETL processing. While I have written C# code that fetches data, it saves it to a JSON file. However, the API has over 20 different routes to access each…
asked 2024-03-01T11:36:48.6533333+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, 11%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
rania mbarki
0
Reputation points
answered 2024-03-05T03:11:04.8+00:00
Greg Low
1,495
Reputation points Microsoft Regional Director
1 answer
timestamp manupulation
Hey, here is the table & it contains timestamp at the end. check the output create table customer (CustomerName char(22), ContactName char(22), Address char(22), City char(22) , PostalCode char(22), Country char(22),time DATETIME DEFAULT…
asked 2024-02-26T04:40:10.3066667+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
165
Reputation points
edited the question 2024-03-04T17:56:13.4133333+00:00
Oury Ba-MSFT
16,636
Reputation points Microsoft Employee
1 answer
Can Azure Migrate handle other SQL Server components?
Hello, I have just started to work on a migration project for a client that has the current onpremise environment on Win/SQL 2012 and want to replatform (migrate & upgrade) to Win/SQL 2019. They have cubes (SSAS), Reports (SSRS) and SSIS that need to…
asked 2024-02-26T17:48:38.31+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, 55.00000000000001%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Abimbola Adeniran
21
Reputation points
commented 2024-03-01T23:20:13.1033333+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(291.2, 38%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Marcin Policht
12,165
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
json file in sql server
could you please explain how we can load below curly bracket files in sql server when there are multiple unwanted curly brackets are there apart from main data? in this case data is available in till Result only { "Generic": { …
asked 2024-03-01T02:01:10.4466667+00:00
Vineet S
165
Reputation points
edited an answer 2024-03-01T03:09:35.2533333+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
25,116
Reputation points
1 answer
One of the answers was accepted by the question author.
Is SQL Server Integration Services Oracle Connector free?
Is the "SQL Server Integration Services Oracle Connector" free or do I have to pay for a SQL Server license when I use the connector? Regards, Roger
asked 2024-02-27T11:21:06.25+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(19.2, 40%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Roger Sijstermans
20
Reputation points
accepted 2024-02-29T08:23:07.65+00:00
Roger Sijstermans
20
Reputation points
2 answers
How to handle Inavlid Date Columns in Source while Loading Data into tables in SSIS?
Hi All, I received data from Data Lake. I need to load the data from DL to Stage tables using SSIS. Recently, I received data in DL having some invalid date columns. Actual Data in Date column looks like '1900-01-01:00:00:000" But for records the…
asked 2024-02-26T03:47:07.4066667+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(208, 71%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Ramana Kopparapu
226
Reputation points
commented 2024-02-29T07:56:27.87+00:00
ZoeHui-MSFT
33,296
Reputation points
asked 2024-02-29T05:28:21.43+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, 72%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECA%3C/text%3E%3C/svg%3E)
Cedric Alcaraz
0
Reputation points
commented 2024-02-29T07:03:41.18+00:00
Cedric Alcaraz
0
Reputation points
3 answers
Cannot connect to SQL Management studio 19.3
Hi Microsoft team, I have been trying to connect to the SQL server for a long time now and i have been getting error message cannot connect to.... How can i overcome this challenge?
asked 2024-02-08T16:10:07.1266667+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(291.2, 8%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBO%3C/text%3E%3C/svg%3E)
Boluwaji Olusegun
0
Reputation points
commented 2024-02-29T05:56:26.4866667+00:00
CosmogHong-MSFT
23,321
Reputation points Microsoft Vendor
2 answers
How to find SSIS package that's calling / Executing a stored procedure?
May I know a SQL query OR some other way to know which SSIS package is calling / executing a stored procedure? Thanks, Kumar
asked 2024-02-05T21:57:23.22+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, 82%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKR%3C/text%3E%3C/svg%3E)
Kumar Rnd
0
Reputation points
commented 2024-02-29T05:51:13.8833333+00:00
CosmogHong-MSFT
23,321
Reputation points Microsoft Vendor
1 answer
Adapting Excel formula to Calculated Measure for % of Fiscal Year Elapsed
I have an Excel formula that calculates % of fiscal year elapsed, and I want to use it in a calculated measure to add it as a dimension field on a PivotTable Cube. However, Copilot generated an error when I tried to adapt it to a calculated measure.…
asked 2024-02-27T23:49:02.5433333+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(169.60000000000002, 11%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
James Stone
0
Reputation points
answered 2024-02-28T07:30:08.97+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(147.20000000000002, 13%, 24%)' 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)
Jiajing Hua-MFST
5,305
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
multiple merge condition
Hey, due to multiple merged condition in same query, it is taking lots of time to run in sql tried partition but did not work . what can be best approach?
1 answer
One of the answers was accepted by the question author.
How to load XMLs from a directory into the database
Hello, I want to load XMLs from a directory containing over 12000 files into SQL Server database. To be precize I actually need to extract just two column values from these XMLs into a table. I thought I'd try to load the whole XML into XML column of…
asked 2024-02-23T14:44:19.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(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
335
Reputation points
commented 2024-02-27T19:51:44.99+00:00
Yitzhak Khabinsky
25,116
Reputation points
1 answer
Test Connection failure in Linked Service in data factory while connecting to DB2
Expectation: Data transfer from DB2 to SQL Server Details : While providing all details in the linked service the test connection it getting failed, can you please let me know if whitelisting my IR public IP will resolve it? ERROR details : Cannot…
asked 2024-02-22T09:59:55.43+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(25.6, 47%, 12%)' 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)
ADMMMLIFEADFADMIN
0
Reputation points
commented 2024-02-26T20:01:57.92+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(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
BhargavaGunnam-MSFT
26,496
Reputation points Microsoft Employee
4 answers
One of the answers was accepted by the question author.
ERROR: Method not found: 'Void Microsoft.NetEnterpriseServers.ExceptionMessageBox.SetButtonText(System.String[])'. (Microsoft.DataWarehouse)
Hello, When I want to edit the configuration file at Package Configuration Wizard, I get this error: Method not found: 'Void Microsoft.NetEnterpriseServers.ExceptionMessageBox.SetButtonText(System.String[])'. (Microsoft.DataWarehouse) Please refer to the…
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,415 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,643 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,809 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
.NET Runtime
.NET Runtime
.NET: Microsoft Technologies based on the .NET software framework.Runtime: An environment required to run apps that aren't compiled to machine language.
1,126 questions
asked 2023-02-08T07:25:00.0866667+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(131.20000000000002, 77%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
syazwan amir
20
Reputation points
answered 2024-02-26T13:57:57.98+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, 70%, 17%)' 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)
Rakesh
0
Reputation points