SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,367 questions
1 answer
SSMA Presenting ORA-01017: invalid username/password; logon denied
I am trying to leverage SSMA to migrate a oracle database to SQL or atleast get a migration assessment report. However every time I attempt to connect to the database I get the following error: Connection to Oracle failed. ORA-01017: invalid…
asked 2023-11-28T11:49:11.5766667+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(211.20000000000002, 15%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Thomas Doughty
0
Reputation points
commented 2024-02-07T18:31:00.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(64, 84%, 16%)' 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)
Amal Agarwal
5
Reputation points
5 answers
how to update SQL server 2012 to 2019
How do you update from old SQL server 2012 to 2019 without losing data?
asked 2023-02-01T16:02:53.5866667+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, 11%, 18%)' 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)
Jeremy Lopez
0
Reputation points
answered 2024-02-07T16:18:22.6466667+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, 42%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Muhammad Kamran
0
Reputation points
1 answer
Data Migration Assistant Tool- Security Considerations
Hi, I am performing the Data Migration from one sql server to another sql server using the Data Migration assistant tool. I am migrating highly confidential data , hence I want the data at rest and data at transit should be fully secure at each…
asked 2024-02-01T14:13:37.15+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, 68%, 10%)' 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)
Rahul
251
Reputation points
commented 2024-02-05T14:50:06.4266667+00:00
Alberto Morillo
33,426
Reputation points MVP
1 answer
2007 Office System Driver Data Connectivity Components
I need 2007 Office System Driver Data Connectivity Components download but it says Microsoft took it down. I need it because you don't fully support SSIS in Visual studio 2022 yet. So I'm using Visual studio 2017 to build my SSIS packages with Excel…
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,651 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
517 questions
asked 2024-01-31T15:58:06.3566667+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, 22%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Micah Holmes
1
Reputation point
commented 2024-02-01T14:07:10.8666667+00:00
Micah Holmes
1
Reputation point
1 answer
Error in SSIS Package Execution - An error occurred when detecting the document payload kind (Microsoft.SqlServer.ManagedDTS)
I am encountering an issue in a SQL Server Integration Services (SSIS) package execution, and I would like to report the error for further investigation. The error message is as follows, URL sample…
asked 2024-01-25T12:06:46.8833333+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(198.4, 23%, 29%)' 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)
Prabhu
0
Reputation points
commented 2024-01-29T19:40:29.57+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, 4%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
kobulloc-MSFT
26,131
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Visual Studio "no project supported by NuGet" error
I am attempting to create a new SSIS package in Visual Studio and am getting this message when I try to open the NuGet Manager. I am using Visual Studio 2019 Version 16.11.33. This just started happening within the last couple of weeks.
asked 2024-01-23T18:58:37.6266667+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(163.2, 84%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Gronli, Brad
26
Reputation points
accepted 2024-01-24T13:05:34.7533333+00:00
Gronli, Brad
26
Reputation points
1 answer
Download file in AWS S3 bucket using SSIS
Is there a way to download a file from AWS S3 source to local using SSIS? I have files in different formats like json, csv that are sitting in ASW S3 and I would like to load the data in SQL Server On Prem using SSIS. The files comes in different names…
asked 2024-01-21T21:05:43.86+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, 56.00000000000001%, 36%)' 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)
Sinah Molepo
20
Reputation points
edited an answer 2024-01-22T03:43:34.54+00:00
ZoeHui-MSFT
35,556
Reputation points
3 answers
SSIS - when I open a solution, change the file name to load, the package freezes
Open Visual Studio SSIS Select project Click on Solution (mapping) When I do anything after that, I get a message "Visual Studio is busy. We'll automatically report ... " a) Change Excel Source b) Click on Data Flow c) Click on…
asked 2024-01-11T15:33:20.1933333+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(128, 52%, 22%)' 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)
Steve Thiboutot
0
Reputation points
answered 2024-01-12T15:11:21.4833333+00:00
Steve Thiboutot
0
Reputation points
3 answers
How to migrate a database from SQL Server 2000 to SQL server 2022 without paying for all the versions inbetween
Hi, We're currently running Microsoft SQL Server 2000 and would like to migrate to 2022 but to do this we have to iterate the database through multiple version of SQL server. Is it possible to get temporary licenses of all the version we need to…
asked 2024-01-10T12:54:31.9366667+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(288, 97%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELK%3C/text%3E%3C/svg%3E)
Lester Kelly
20
Reputation points
edited an answer 2024-01-11T02:06:10.2733333+00:00
ZoeHui-MSFT
35,556
Reputation points
2 answers
Synchronizing data from Oracle 11.2 to SQL Server 2019
We are currently in the process of migrating from Oracle 11.2 to SQL Server 2019. We need a way to read data in our Oracle database on regular basis (nightly, daily, hourly, etc.) for synchronization purposes so that we can run reports against the SQL…
asked 2023-08-15T18:47:09.5966667+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(80, 44%, 17%)' 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)
Steve Hodgkiss
0
Reputation points
commented 2024-01-02T22:47:04.41+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(121.6, 64%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMZ%3C/text%3E%3C/svg%3E)
Maria Zulfiqar
0
Reputation points
2 answers
One of the answers was accepted by the question author.
sql server migration assistant - mapping varchar to varchar
Hi! I am using SQL Server Migration Assistant for MySQL to migrate a database to SQL Server. However, trying to map the varchar type to varchar only leaves me with the nvarchar type? How do I adjust this?
asked 2023-12-28T12:39:38.2466667+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(163.2, 99%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECT%3C/text%3E%3C/svg%3E)
Cesar Tomita
20
Reputation points
accepted 2023-12-28T17:32:03.8766667+00:00
Cesar Tomita
20
Reputation points
3 answers
One of the answers was accepted by the question author.
SSIS Update unsupported
Hello! I am new to SSIS. I just recently updated my visual studio installer to the Visual Studio Community 2019 16.11.30. Once I updated this, I can no longer access my previous ssis packages. Attached I have a picture of the error of I am receiving.
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,889 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,367 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
517 questions
Visual Studio Debugging
Visual Studio Debugging
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Debugging: The act or process of detecting, locating, and correcting logical or syntactical errors in a program or malfunctions in hardware. In hardware contexts, the term troubleshoot is the term more frequently used, especially if the problem is major.
967 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 2023-09-20T15:31:45.4033333+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, 54%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Smith, Carl
20
Reputation points
accepted 2023-12-22T05:56:13.4166667+00:00
Smith, Carl
20
Reputation points
2 answers
Upgrade SQL Server 2019 (Standard Edition) to SQL Server 2022 (Standard Edition)
I want to upgrade my production SQL Server (2019 Standard Edition) version to SQL Server 2022(Standard Edition) which is hosted on the Azure virtual machine. There are 400-500 databases currently running on the SQL server 2019. So also want to migrate…
asked 2023-12-13T15:08:07.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(73.60000000000001, 84%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
kanav sharma
5
Reputation points
commented 2023-12-20T08:24:17.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(230.39999999999998, 89%, 32%)' 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)
AniyaTang-MSFT
12,421
Reputation points Microsoft Vendor
1 answer
Initialization error while migration assistance for MySQL
I am trying to migrate my MySQL database to MS SQL. I have already installed the ODBC driver and SSMA for MySQL. However I got an initialization error when trying to open SSMA. Cannot start because of an initialization error Try to restart the…
asked 2023-12-14T08:31:07.1233333+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(259.20000000000005, 61%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Chua Camille
0
Reputation points
answered 2023-12-15T02:55:52.5266667+00:00
ZoeHui-MSFT
35,556
Reputation points
1 answer
Error deployment from SSIS to SQL Server
I tried to deploy project from ssis (visual studio) to SQL server and i got this error : TITLE: SQL Server Integration Services ------------------------------ A .NET Framework error occurred during execution of user-defined routine or aggregate…
asked 2023-12-13T13:03:32.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(198.4, 64%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIE%3C/text%3E%3C/svg%3E)
ikram elmbarki
0
Reputation points
answered 2023-12-14T05:28:36.6833333+00:00
ZoeHui-MSFT
35,556
Reputation points
3 answers
Can't restore databse on Microsoft SQL server management studio
=================================== Restore of database 'AdventureWorks2019' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks) Program Location: at…
asked 2022-06-07T02:12:05.533+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, 37%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Manwinder Singh
1
Reputation point
commented 2023-12-08T15:19:19.8833333+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, 18%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
COŞKUN SÜMER
0
Reputation points
1 answer
In Visual studio 2019, SSIS getting a connection issue for Odata connection.
Created a Odata connection with parameters like URL, Password, User name etc, and when I check the preview data, I'm able to see the data and when I run the package I'm getting an error like " Cannot acquire a managed connection from the run-time…
asked 2023-12-05T11:48:49.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(256, 14.000000000000002%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Srinivas Ravi
0
Reputation points
commented 2023-12-08T12:02:19.1+00:00
Srinivas Ravi
0
Reputation points
1 answer
create an azure serverless database
Customer currently has much of the cloud environment in AWS and they will start to migrate to Azure
asked 2023-11-30T21:29:23.59+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, 66%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mario Scott (International Supplier)
0
Reputation points Microsoft Vendor
edited the question 2023-12-04T09:43:34.25+00:00
SadiqhAhmed-MSFT
41,721
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
migrate my MySQL database to SQL Server
Hello. I need to migrate my MySQL database to SQL Server. Where can I download SSMA for MySQL？ Is there any tutorial for me to refer to? Any help will be greatly appreciated.
![](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, 31%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
2 answers
O2SS0013: EXECUTE IMMEDIATE statement was converted, but dynamic string was not converted. It must be converted manually.
Hi, I've checked common conversion errors for Oracle Database to SQL Server 2016 migration with SSMA (https://learn.microsoft.com/en-us/sql/ssma/oracle/messages/o2ss0007?view=sql-server-ver16) however this error is missingO2SS0013, EXECUTE IMMEDIATE…
asked 2023-11-27T10:51:08.5966667+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(38.4, 84%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E6%3C/text%3E%3C/svg%3E)
65877627
0
Reputation points
answered 2023-11-27T22:17:17.48+00:00
Erland Sommarskog
107.2K
Reputation points