Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,566 questions
1 answer
I got an error that I cannot connect to SQL while demoing olap.Help me repair this error,please.
Please help me fix the following error
asked 2024-10-02T10:16:50.4933333+00:00
võ thị tuyết ngân
20
Reputation points
edited the question 2024-10-03T01:03:17.45+00:00
Tianyu Sun-MSFT
30,561
Reputation points Microsoft Vendor
1 answer
VBscript not running on windows server 2019
Hi All, Our VB Script has been integrated with SSIS package as script task and it work in fine in visual studio IDE . However, it is getting failed to run same VB script block in windows server 2019 environment inside SSISB as a SSIS Package. Please…
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,771 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.
532 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,722 questions
0 answers
SSMA for Oracle error ROW-00001 Unable to Allocate Memory
Hi, I am migrating from Oracle to Azure SQL Server Managed Instance. Some of my tables have 100+ million rows so I have partitioned those tables in the source Oracle database so I am only migrating smaller tables to Managed Instance (typically between 3M…
asked 2024-09-26T17:38:21.1166667+00:00
Vincent Molloy
0
Reputation points
commented 2024-10-01T18:07:53.1633333+00:00
NIKHILA NETHIKUNTA
2,395
Reputation points Microsoft Vendor
1 answer
Testing migration of SQL/SSAS from 2017 to 2019, when editing an SSAS database connection in SSMS 18.12.1 results in an error - Object reference not set to an instance of an object. (Microsoft.AnalysisServices.SsmsManagementDialogs)
After updating connection string properties, SSMS returns TITLE: Microsoft SQL Server Management Studio ------------------------------ Object reference not set to an instance of an object. (Microsoft.AnalysisServices.SsmsManagementDialogs) …
asked 2022-07-13T15:04:26.47+00:00
Spencer-Jones, Mike
6
Reputation points
commented 2024-09-26T10:16:56.4066667+00:00
Silviu Vladutu BCR
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Number of query values and destination fields are not the same
Hello friends, I received text (.txt) files from our external vendor every morning. My objective is to convert this text files to excel (.xlsx) per our customer's request. I am using SSIS Package, and I am using Script Task to do my conversion from text…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 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.
532 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,904 questions
asked 2024-09-19T18:56:39.9633333+00:00
Villa
231
Reputation points
commented 2024-09-23T09:27:25.9233333+00:00
Jiale Xue - MSFT
44,926
Reputation points Microsoft Vendor
0 answers
SSMA says my SQL Server agent isn't running, but it is.
When connecting to my target SQL instance, on the same server as SSMA, it gives me a warning that SQL Server Agent isn't running and must be up. However, it is up and running. What is it looking for, and how do I get it to recognize the actual status?
asked 2024-09-22T17:06:40.97+00:00
Kevin Slack
0
Reputation points
asked 2024-09-22T17:06:40.97+00:00
Kevin Slack
0
Reputation points
0 answers
How to fix error Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host?
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host, I need to get data from microsoft project on line to moicrosoft SQL database
asked 2024-06-03T11:52:47.1866667+00:00
Mostafa Elframawy
0
Reputation points
commented 2024-09-18T14:57:04.6233333+00:00
Sai Kiran Bandi (LTIMINDTREE LIMITED)
0
Reputation points Microsoft Vendor
4 answers
Azure Data Studio - Azure SQL Migration extension thinks the Managed Instance is still in 'Creating' state.
In step 3 of the Azure SQL Migration where the user chooses the managed instance: Error: The managed instance 'managedinstance' is unavailable for migration because it is currently in the 'Creating' state. To continue, select an available managed…
asked 2023-02-28T11:28:45.1133333+00:00
Vlasopoulos V
10
Reputation points
answered 2024-09-11T20:29:01.65+00:00
ROHTASHV GEHLLOT
5
Reputation points
1 answer
One of the answers was accepted by the question author.
Which dot net frame is used by SQL server 2016 SSIS packages
Which dot net frame is used by SQL server 2016 SSIS packages
asked 2024-09-09T14:23:34.13+00:00
Kallavi, Vasudeva Gururaja
20
Reputation points
accepted 2024-09-09T20:10:19.57+00:00
Kallavi, Vasudeva Gururaja
20
Reputation points
0 answers
SSMA Db2 to Sql Server Save workspace error
When saving my workspace on Sql Server Migration Assistant for DB2 the following error show on the log: [Error: Gui] [1072400/38] [2022-08-18 11:24:40]: Inner Exception #1: The surrogate pair (0xD9E3, 0xC9D5) is invalid. A high surrogate character…
asked 2022-08-18T09:27:25.26+00:00
Xavier Klausener
6
Reputation points
commented 2024-09-09T19:13:05.6533333+00:00
PETER TOWNSEND
0
Reputation points
0 answers
How to connect DB2 to SQL Server Migration Assistant (SSMA) for DB2
I have been unable to fully connect to DB2 using Microsoft's SSMA for DB2 client (DB2ToSQL). After making sure all pre-requisites were in place and following the connection instructions, SSMA just shows it's "connecting", however, netstat…
asked 2024-09-07T23:05:45.7766667+00:00
Robin Glass
0
Reputation points
commented 2024-09-08T18:58:14.27+00:00
Erland Sommarskog
111.1K
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
How to migrate some databases sources from a directory active to another
I need to migrate two SQL databases from a subscription located in one Azure Active Directory (tenant) to another directory (tenant). The databases are live, receiving incoming data. I initially attempted to use Azure Database Migration Service (DMS) and…
asked 2024-09-05T15:31:20.43+00:00
Laura Alvarez
20
Reputation points
accepted 2024-09-06T18:26:18.37+00:00
Laura Alvarez
20
Reputation points
0 answers
Azure Managed Instance Migration offline mode. Cannot find full back up error
I am trying to my migrate my on-prm sql server to SQL managed instance via Azure Data Studio Managed instance. I am using the offline mode to migrate the server and my back up files are saved in blob starage account. When i initate the migration i get an…
asked 2024-08-02T18:55:23.06+00:00
Hossain, Shakir
21
Reputation points
edited the question 2024-09-03T03:19:36.95+00:00
Sumarigo-MSFT
46,046
Reputation points Microsoft Employee
1 answer
Azure SQL Migration tool (from Azure Data Studio) does not catch cross database query in Extended Event trace
Hello all, we are running a migrazion assessment using Azure SQL Migration extension from Azure Data Studio. We need to migrate from SQL Server to Azure (Elastic pool or Managed instance). We have upload in the tool an Extended Event trace which…
asked 2024-08-30T16:30:38.66+00:00
Alessandro Colombi
0
Reputation points
answered 2024-08-30T21:43:07.2266667+00:00
Erland Sommarskog
111.1K
Reputation points MVP
5 answers
Oracle SSMA : Problems with hidden columns (DDL optimization)
Hi, Under Oracle (v12), i add a new column : ALTER TABLE TABLE_TEST ADD (TST_FLG_PMO NUMBER(1) DEFAULT 0); When I use SSMA, the script SQL show : CREATE TABLE SCHEMA.TABLE_TEST ( ... TST_FLG_PMO NUMBER(1, 0) DEFAULT 0, SYS_NC00109$ RAW(126)…
asked 2021-07-08T10:17:41.507+00:00
PM
1
Reputation point
edited an answer 2024-08-28T14:35:43.7966667+00:00
ChristovamCursinodeOliveira-4351
0
Reputation points
1 answer
How to Install SQL server correctly?
I tried installing sequel server on my pc, I got errors and a summary of the errors. Feature: Data Quality Client Status: Failed Reason for failure: An error occurred during the setup process…
asked 2024-08-24T02:06:22.1866667+00:00
Rita Ewoigbokhan
0
Reputation points
commented 2024-08-28T08:45:52.63+00:00
MikeyQiaoMSFT-0444
2,950
Reputation points
2 answers
Database Mail Stopping
Currently having issues on two separate SQL 2022 servers with Database Mail. The service won't auto start up as it should do - I can manually start it and it seems to run for just less than an hour or so and then shuts down and won't restart itself…
asked 2024-08-26T11:16:49.03+00:00
Rabia Kurnaz
386
Reputation points
commented 2024-08-28T05:52:18.7333333+00:00
CathyJi-MSFT
22,201
Reputation points Microsoft Vendor
1 answer
Data validation tools while migrating on-prem oracle DB to Azure SQL DB
I have to migrate/copy data from oracle database in on-premise to azure SQL database. May I know if Microsoft provides a tool or utility that helps data validation, schema validation and checksum validation of data between oracle database and Azure SQL…
asked 2024-08-27T05:54:02.57+00:00
Raja
1
Reputation point
answered 2024-08-27T07:40:18.0766667+00:00
ShaktiSingh-MSFT
15,301
Reputation points
3 answers
Install downgrade SQL Ent. 2022 to 2019
I ran into a problem with the upgrade to SQL 2019 on my Server. Even though buying a license for SQL 2022 does then let us install SQL 2019 as a downgrade option, we still have to have a 2019 license Key. The 2022 License key did not work for the SQL…
asked 2023-03-20T15:22:45.11+00:00
Randy Clark
0
Reputation points
commented 2024-08-23T06:09:42.57+00:00
Rune Bruhn Harding
0
Reputation points
2 answers
One of the answers was accepted by the question author.
SQL Server Integration Services Projects 2022 exe for VS2022 is not detecting VS2022 and hence unable to install it
When i install SQL Server Integration Services Projects 2022, it does not detect my installed VS 2022. Hence, unable to select any VS and install. I tried from different machines.. in some machines its getting detected, but disabled, doesn't allow me to…
asked 2024-04-29T10:52:06.8966667+00:00
SAILANATHAN Balaji
50
Reputation points
answered 2024-08-21T04:21:19.6066667+00:00
omid zare
0
Reputation points