SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,487 questions
0 answers
How to Implement Late Arriving Dimensions in SSIS 2022
Hello, I'm looking for end-to-end documentation, if possible, with demo packages on implementing Late Arriving Dimensions use case leveraging the Inferred Flag approach in SSIS 2019/2022. I've been researching this for a while, and although there are…
![](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, 10%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
1 answer
Getting error while bulk insert: Cannot bulk load because the file "WK48.csv" could not be opened. Operating system error code 1346(Either a required impersonation level was not provided, or the the provided impersonation level is invalid.)
The issue arises when attempting to execute a BULK INSERT operation in SQL Server, encountering an "Operating system error code 1346" stating the file "C:\Intel\Data\OMS.csv" cannot be opened. I have given the permissions to the…
asked 2024-06-16T16:32:40.12+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(57.599999999999994, 83%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENJ%3C/text%3E%3C/svg%3E)
Nitin Jena
0
Reputation points
answered 2024-06-16T17:39:50.63+00:00
Erland Sommarskog
103.5K
Reputation points MVP
4 answers
Cant import Excel into SQL Management Studio
I too can't import Excel files using the SSMS Wizard. I get the following error message The 'Microsoft.ACE.OLEDB.15.0' provider is not registered on the local machine. (System.Data) I am running Office 2013 that doesn't include 'Access' on Windows10. I…
asked 2024-06-14T14:21:45.66+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, 16%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Keith Banbury
0
Reputation points
commented 2024-06-16T14:19:43.2666667+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,381
Reputation points
2 answers
One of the answers was accepted by the question author.
Unexpected truncation error when inserting from UTF8 to non-UTF8 collation
I believe I am hitting a bug with moving data from a UTF8 to a non-UTF8 collations in SQL Server 2022 CU13 (running under Linux but assuming for now this issue is not related). The issue is that MSSQL appears to be determining the width of a string for…
asked 2024-06-11T00:42:42.9533333+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(9.6, 79%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Ben
25
Reputation points
commented 2024-06-16T11:57:19.33+00:00
Erland Sommarskog
103.5K
Reputation points MVP
0 answers
Cannot connect to SQL Database. No process is on the other end of the pipe
I am trying to create a Linked Service on ADF for SHIR (this is up and connected to ADF) and when i fill in all details and click Test Connection. I get this error message: Cannot connect to SQL Database. Please contact SQL server team for further…
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,070 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,070 questions
asked 2024-06-16T07:17:35.5833333+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, 22%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVD%3C/text%3E%3C/svg%3E)
Vijaykumar Dinni
0
Reputation points
commented 2024-06-16T09:29:32.9+00:00
Erland Sommarskog
103.5K
Reputation points MVP
0 answers
How do I configure OLE DB connection settings in Visual Studio?
While I tries to connect OLE DB in visual studio, i am getting error as TITLE: Connection Manager Please select .Net Provider. BUTTONS: OK
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,767 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,487 questions
asked 2024-06-14T07:28:37.46+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(224.00000000000003, 31%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Revathy D R
0
Reputation points
commented 2024-06-16T06:03:05.6666667+00:00
Olaf Helper
42,386
Reputation points
0 answers
ServerCertificate DSN property mentioned in system_odbc.ini is not honored by Microsoft ODBC Driver 18 for SQL Server version 18.3 in linux
Hi all, I have installed SQL Server instance in Windows and enabled SSL connections. Now I have installed ODBC SQL Server Native Client on Rhel 9 VM and configured a DSN in system_odbc.ini…
asked 2024-06-14T20:07:00.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(316.8, 74%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Srikanth G
0
Reputation points
commented 2024-06-16T03:29:10.8266667+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(236.8, 96%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOF%3C/text%3E%3C/svg%3E)
Obaid Farooqi MSFT
591
Reputation points Microsoft Employee
4 answers
how to solve the error "Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - La chaîne de certificats a été"
Hi I try to connect my asp.net core api to a sql server database I encounter an error like: "Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login…
asked 2023-05-23T09:49:55.54+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(224.00000000000003, 96%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Marnelle M'BENGUET
20
Reputation points
commented 2024-06-15T08:15:42.27+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(60.8, 3%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Pankaj Kumar Mishra
0
Reputation points
2 answers
Visual studio 2022 crash when i create SSIS package
I installed VS 2022.. and create SSIS package for project. When i create the package VS 2022 unexpectedly close several times . why this happen the error is "A previous session ended unexpectedly. Disabling the extension SQL Server 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,767 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,487 questions
asked 2024-03-14T05:42:23.9166667+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, 33%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Bakhtawar
1
Reputation point
commented 2024-06-14T23:25:00.45+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(83.2, 17%, 18%)' 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)
Amy Southworth
0
Reputation points
1 answer
Does ADO.NET support multi-subnet failover for SQL connections, and how does this feature compare to ODBC's multi-subnet failover support?
I am using ADO.NET for SQL connections. Does ADO.NET support multi-subnet failover? I understand that ODBC supports multi-subnet failover. Can you explain the difference between ADO.NET and ODBC in this regard?
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,525 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,070 questions
Windows Network
Windows Network
Windows: A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.Network: A group of devices that communicate either wirelessly or via a physical connection.
681 questions
asked 2024-06-10T10:06:11.2266667+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, 48%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYC%3C/text%3E%3C/svg%3E)
YONG Chee Wee
1
Reputation point
commented 2024-06-14T21:51:51.7333333+00:00
Erland Sommarskog
103.5K
Reputation points MVP
3 answers
Data (of 15GB) from SQL 2000 to SQL 2012 via SQL 2008 - Express okay? Trial versions?
I'm trying to move a backup data (of 15gb) from SQL 2000 to SQL 2012. To do so, I must go thru SQL 2008 (or 2005), that is, A. Restore 2000-backup-file into 2008. B. Create 2008-backup-file. C. Restore 2008-backup-file into 2012. I've been looking for…
asked 2024-06-13T22:16:33.8266667+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(144, 69%, 23%)' 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)
David
0
Reputation points
answered 2024-06-14T21:36:53.56+00:00
Erland Sommarskog
103.5K
Reputation points MVP
1 answer
SQL Server Licensing
Hi Team, My customer has SQL server 2017 Enterprise licensing. He needs to upgrade the SQl server to 2022. Is he able to use the Existing License for SQL 2022 and he doesn't have Software assurance.
asked 2024-06-14T06:49:27.6033333+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, 49%, 14%)' 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)
suthan speed
0
Reputation points
commented 2024-06-14T21:28:48.3+00:00
Erland Sommarskog
103.5K
Reputation points MVP
1 answer
Received the prompt "CPU speed isn't qualified." when install SQL Server 2019
Hi there During the SQL server 2019 upgrade installation, I received a prompt stating "CPU speed isn't qualified". The corresponding requirements are: SQL Server requires: Minimum: x64 Processor: 1.4 GHz SQL Server Management Studio requires:…
asked 2024-06-14T07:47:30.32+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, 35%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMY%3C/text%3E%3C/svg%3E)
Mark Yang
0
Reputation points
commented 2024-06-14T21:25:57.02+00:00
Erland Sommarskog
103.5K
Reputation points MVP
1 answer
Querying table index stats not working
I am trying to query my tables index fragmentation in Azure Synapse studio with query: SELECT IPS.Index_type_desc, IPS.avg_fragmentation_in_percent, IPS.avg_fragment_size_in_pages, IPS.avg_page_space_used_in_percent, …
asked 2024-06-14T09:17:01.14+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(28.799999999999997, 7.000000000000001%, 12%)' 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)
Jani Hämäläinen
20
Reputation points
answered 2024-06-14T21:25:10.3566667+00:00
Erland Sommarskog
103.5K
Reputation points MVP
0 answers
Error code: 1639
Overall summary: Final result: Failed: see details below Exit code (Decimal): -2068052377 Start time: 2024-06-14 16:10:09 End time: 2024-06-14 16:18:53 Requested action: …
asked 2024-06-14T19:25:43.3766667+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, 85%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJO%3C/text%3E%3C/svg%3E)
João Pedro Handle
0
Reputation points
commented 2024-06-14T21:21:43.5766667+00:00
Erland Sommarskog
103.5K
Reputation points MVP
2 answers
How to fix '1639' error SQL Server 2022? Error: "Invalid command line argument. Consult the Windows Installer SDK for detailed command line help."
I have deleted remnant past failed installation files, including media and registry keys. This is my error log: Detail.txt
asked 2024-06-14T10:40:47.4466667+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, 12%, 32%)' 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)
Franko
0
Reputation points
answered 2024-06-14T21:15:59.8833333+00:00
Erland Sommarskog
103.5K
Reputation points MVP
3 answers
One of the answers was accepted by the question author.
Partition by filter
Hey Team I have table where A values comes then E value should be filter or else E value should be there partition by data and mpr column expected values
asked 2024-06-14T14:34:28.8633333+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
225
Reputation points
edited an answer 2024-06-14T21:11:05.9233333+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
405
Reputation points
1 answer
Banco de dados Corrompido
Estamos com banco de dados corrompido. Tentamos rodar DBCC CHECKDB (nomeDB,REPAIR_REBUILD) WITH NO_INFOMSGS, ALL_ERRORMSGS; porém ocorreu erro: Object ID 351340316, index ID 0, partition ID 72057594102874112, alloc unit ID 72057594136494080 (type In-row…
asked 2024-06-14T16:05:20.2733333+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, 56.00000000000001%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETJ%3C/text%3E%3C/svg%3E)
Tatiana Jandira
0
Reputation points
answered 2024-06-14T21:00:04.83+00:00
Erland Sommarskog
103.5K
Reputation points MVP
1 answer
What is stored procedure vs sql loader
I'm reviewing some system setup on SQL server and for inbound data we use a stored procedure and outbound we are using the something called SQL Loader. Like a definition of both and tools that could be used. I'm the business analyst and lot of…
asked 2024-06-14T18:48:46.0466667+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, 82%, 38%)' 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)
Jonathan Brotto
160
Reputation points
edited the question 2024-06-14T20:50:30.9066667+00:00
Erland Sommarskog
103.5K
Reputation points MVP
2 answers
How to read pdf,jpeg,gif document using tesseract OCR with C# asp.net MVC
Currently we have one page and this page contains one file-upload and one submit button, then the user will select a file from file-upload and submit the pdf,jpeg,gif file. Now my requirement is the user will upload pdf,jpeg,gif read the content of the…
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,363 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,070 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,484 questions
asked 2023-11-11T21:00:28.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(179.20000000000002, 39%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
coder rock
216
Reputation points
commented 2024-06-14T20:03:04.34+00:00
coder rock
216
Reputation points