Azure SQL Database
An Azure relational database service.
5,452 questions
1 answer
Failed to authenticate the user NT Authority\Anonymous Logon in Active Directory (Authentication=ActiveDirectoryIntegrated).
I'm working on configuring Azure SQL Server authentication using Microsoft Entra Integrated. Here’s my setup: I have an Azure SQL Server with an active database. My laptop is connected to Azure AD. I’ve opened SQL Server Management Studio (SSMS),…
asked 2024-07-29T14:52:57.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(67.2, 76%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Sam H
0
Reputation points
answered 2024-07-29T16:18:39.9633333+00:00
hossein jalilian
5,715
Reputation points
2 answers
Looping through excel files
I am trying to load multiple excel files using for each loop container. In my 'Excel Connection Manger' I am accessing the data through 'SQL Command from variable'. I am getting an error message when I try to make the filename dynamic in the connection…
1 answer
Query dtexec package executions
We have a SQL Server where several packages are executed using dtexec, and I would like to retrieve the execution information and from which machines they are executed, but I can’t figure out where to find it. In the executions view, there are only the…
asked 2024-07-29T07:11:08.7466667+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(195.2, 80%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Simone Bottani
0
Reputation points
commented 2024-07-29T07:28:31.5533333+00:00
Simone Bottani
0
Reputation points
1 answer
Cannot uninstall SQL Server Integration Services Projects after VS version 16.0.0 (offline) update
Hi MS, We got a Visual Studio version 16.0.0 (Offline) and SQL Server Integration Services Projects installed. I updated VS to version 16.11.0 from an offline layout. I moved on to trying to update the SQL Server Integration Services Projects version…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,895 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,528 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.
194 questions
asked 2024-07-24T06:47:23.6766667+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(76.8, 1%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Mary T
0
Reputation points
commented 2024-07-26T13:04:12.7533333+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, 10%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAX%3C/text%3E%3C/svg%3E)
Anna Xiu-MSFT
27,966
Reputation points Microsoft Vendor
0 answers
Installing IBMi Access Driver on Azure Data Factory Integration Runtime
Hello, I've been trying to install the Windows version of the IBM i Access Driver on a Data Factory Integration Runtime through adding a script (main.cmd) and the desired installer in a Blob Container This script seems to work perfectly locally but when…
asked 2024-07-24T07:19:18.0966667+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, 97%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Alexandru Moise
0
Reputation points
commented 2024-07-26T09:11:56.3333333+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(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
12,620
Reputation points Microsoft Vendor
2 answers
The scriptmain.cs can not be found in the SSIS package
I have a SSIS package with a script task. I can edit this script taks, but when I add a breakpoint in the C# code and I run the package I get an error that the ScriptMain.cs can not be found. I use Visual studio 2022 with data tools 2017 and integration…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,895 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,528 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,656 questions
asked 2024-07-17T08:24:57.6333333+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(284.8, 54%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEB%3C/text%3E%3C/svg%3E)
Eric Bezemer
196
Reputation points
commented 2024-07-25T15:42:17.6633333+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,731
Reputation points
2 answers
How to send data to an SAP C4C tenant through their OData API using SSIS
Hello, I need to be able to send data from an SQL Server Table (OLE DB Source) to an SAP C4C tenant using their OData API in SSIS. In the toolbox there is an OData Source through which data can be retrieved from the tenant but can't be sent back. Is…
asked 2024-07-22T15:51:14.8166667+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(124.80000000000001, 59%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Amogh Sharma
25
Reputation points
commented 2024-07-23T20:58:33.8966667+00:00
Amogh Sharma
25
Reputation points
2 answers
Protocol Error in TDS Stream in SSIS - connected host has failed to respond
Hello, We are having issue when we are running SSIS package and getting following error: Code: 0xC0202009 Source: Sync Details Data FLow sqlssis OLE DB Source [1] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error…
![](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(252.8, 78%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
"Incompatible" project
(Relatively new to SSIS so apologies if this is an easy one) I set up a data flow in the community version of VS as a proof of concept. Then moved to the enterprise version but opened the old project before installing SSIS and of course it said the…
asked 2024-07-16T14:40:52.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(268.8, 2%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Lusk, Colin
25
Reputation points
accepted 2024-07-22T06:37:42.3233333+00:00
Lusk, Colin
25
Reputation points
1 answer
how to enable the Integration Services Catalogs node
I dont see the "Integration Services Catalogs"node option in my sql sever connection. how to enable this option in my server. i installed the developer edition and also have sql integration service
asked 2024-07-22T02:44:00.19+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(233.6, 5%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPU%3C/text%3E%3C/svg%3E)
Padmanaban U
0
Reputation points
answered 2024-07-22T06:06:27.76+00:00
ZoeHui-MSFT
35,556
Reputation points
3 answers
VS2017 - SSIS Project
Hello Team, We are using VS2017 with SSDT installed (PFB the screenshot) We cannot find BI projects, unable to create SSIS projects. Please advice. Regards, Nagesh CL
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,895 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,528 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,822 questions
asked 2024-06-24T16:16:33.29+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(179.20000000000002, 53%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Nagesh CL
641
Reputation points
edited the question 2024-07-19T20:15:41.65+00:00
Oury Ba-MSFT
18,026
Reputation points Microsoft Employee
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
51
Reputation points
commented 2024-07-19T18:06:09.3933333+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(118.4, 23%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Janya Lee Erwin
246
Reputation points
1 answer
One of the answers was accepted by the question author.
Getting errors trying to import data from an SAP Cloud for Customer tenant using OData API in SSIS
Hello, So, I am attempting to import data from an SAP Cloud for Customer (C4C) System into an SQL Server Table using SSIS on Visual Studio 2022. I am using the Odata Source tool to connect to the system and the connection is successful. I can even see…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,895 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.
13,375 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,528 questions
asked 2024-07-18T15:55:39.1166667+00:00
Amogh Sharma
25
Reputation points
accepted 2024-07-19T15:09:19.19+00:00
Amogh Sharma
25
Reputation points
2 answers
How to handle pipe delimiter file in SSIS?
|Col1| |Col2|Col3|Col| |101| |A|21|DC| The values in the file starts with vertical bar(|). The first column's values are moved to 2nd column and 2nd column's values to 3rd when I tried delimiter approach. How should I deal with it in SSIS to…
asked 2024-07-17T16:22:21.96+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, 13%, 39%)' 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)
Sanjeev Kumar B G
0
Reputation points
edited an answer 2024-07-19T02:05:54.21+00:00
Greg Low
1,685
Reputation points Microsoft Regional Director
7 answers
Microsoft.DataTools.IntegrationServices setup fails in Visual Studio Professional 2022 (Version: 17.10.4) Error Code: MainViewModel.OnBundleAction: Bundle action failed: Unknown error (0xe0434352) (0xE0434352)
I was trying to set up SSIS and SSAS extensions in Visual Studio Professional 2022 on Osirius PAM. The SSAS package was completed successfully, but for the SSIS package, I am still getting the same error: Unknown error (0xe0434352) (0xE0434352). Here are…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,528 questions
Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
1,009 questions
asked 2024-07-16T13:45:52.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(294.40000000000003, 17%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKU%3C/text%3E%3C/svg%3E)
Kaan Çullu
5
Reputation points
commented 2024-07-19T01:59:12.4433333+00:00
ZoeHui-MSFT
35,556
Reputation points
2 answers
ApplicationName in project connection manager
We have a large number of packages within an SSIS project and these make use of project connection managers. I would like to change the ApplicationName property of the connection string to reflect which package it is coming from as this will be useful…
asked 2024-07-18T13:24:58.9766667+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(44.800000000000004, 59%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Peter Bishop
161
Reputation points
edited an answer 2024-07-18T16:45:30.0733333+00:00
Yitzhak Khabinsky
25,731
Reputation points
1 answer
VS2019 - Connection Managers not saving passwords
I have an issue where passwords are not saving in the connection managers in my solution. I am able to add in the password and test it, then I ok it, however, when I go back in the password has disappeared. I have done some reading on this and one…
asked 2021-06-25T13:57:46.62+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(278.4, 55.00000000000001%, 36%)' 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)
Jacob Walker
1
Reputation point
commented 2024-07-18T14:17:28.51+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(44.800000000000004, 7.000000000000001%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
P. Nicole
5
Reputation points
2 answers
unable to convert unique identifier
Hi Team, unable to convert this value as an unique identifier and getting null values SELECT try_convert(uniqueidentifier,''9UIC32D1-932-4V03-45E9-FGSGDASASDATY'')testid
asked 2024-06-12T07:17:37.1633333+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
445
Reputation points
edited the question 2024-07-18T08:49:02.3533333+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(220.8, 4%, 31%)' 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)
ShaktiSingh-MSFT
14,481
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
left and right join
Hi, table 1 Table 2 select A.* from table1a LEFT join table2 b on a.col1=b.col1 output: which is correct but on right join it shows above results how to calculate this join and how it will react on NULL and blank
asked 2024-06-23T11:34:41.0833333+00:00
Vineet S
445
Reputation points
edited the question 2024-07-18T07:23:47.01+00:00
ShaktiSingh-MSFT
14,481
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
~|~ Delimiter. Has anyone seen ~|~ as a delimiter?
I received the text files from our vendor every morning. The file contains ~|~ as a delimiter. Has anyone ever seen this kind of delimiter and if so, how do you handle this kind of delimiter? I am using SSIS Package to import the text file into SQL…
![](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, 72%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)