SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,970 questions
1 answer
SSMA for Sybase truncating image data type to 32768
Hi, I am using SSMA for Sybase to migrate Sybase ASE 16 database to MS SQL Server 2022 on Linux. A table with image type column is migrated but the data in this column limited to 32768. I believe if this data migration program is using bcp - it might be…
asked 2024-10-22T21:05:20.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(153.6, 40%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETK%3C/text%3E%3C/svg%3E)
Tahir Khalil
61
Reputation points
commented 2024-11-05T22:09:26.0866667+00:00
Tahir Khalil
61
Reputation points
1 answer
One of the answers was accepted by the question author.
How to migrate large Sybase database using SSMA for Sybase
We are on Sybase/SAP ASE database of various sizes the larges one contains about 1TB of data. We are testing the migration it to on-premise MS SQL Server 2022 Linux, using SSMA for Sybase. Our concern is to move the full data during the downtime which…
asked 2024-11-04T17:31:34.44+00:00
Tahir Khalil
61
Reputation points
accepted 2024-11-05T12:25:11.78+00:00
Tahir Khalil
61
Reputation points
1 answer
DMA tool compliance
Hi Team, We are planning to do some assessments using DMA but i am unable to find any good document for compliance issues for DMA. Can you please help to find the DMA compliance. How to make sure DMA is compliance and safe tool for assessments.
asked 2024-11-01T06:26:36.4866667+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(214.4, 52%, 30%)' 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)
Sanjeev Reddy
30
Reputation points
commented 2024-11-04T06:23:46.93+00:00
Sanjeev Reddy
30
Reputation points
2 answers
Error at oled destination
TITLE: Package Validation Error Package Validation Error ADDITIONAL INFORMATION: Error at Package: The connection "{ED0A6B78-CF34-429E-86CF-4E157EE8CD5E}" is not found. This error is thrown by Connections collection when the specific…
asked 2024-10-23T17:40:08.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(22.400000000000002, 34%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESZ%3C/text%3E%3C/svg%3E)
Siqi Zhao
0
Reputation points
edited an answer 2024-10-27T01:57:45.6966667+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,956
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
![](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(105.60000000000001, 84%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Hossain, Shakir
21
Reputation points
commented 2024-10-23T22:03:30.4533333+00:00
Oury Ba-MSFT
19,506
Reputation points Microsoft Employee
2 answers
we are trying to migrate the database from 2019 express edition to 2017 enterprise edition , pls suggest which POA is best , how we will do this activity without any error .
we are trying to migrate the database from 2019 express edition to 2017 enterprise edition , pls suggest which POA is best , how we will do this activity with any error . we will plan for migration through data tier application but we have one issue…
asked 2024-10-17T09:40:46.94+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(6.4, 44%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Srinivas Naraipeddi
40
Reputation points
commented 2024-10-22T21:36:22.71+00:00
Erland Sommarskog
112.7K
Reputation points MVP
1 answer
How to run SSIS packages using Execute package activity in ADF Pipeline, When the package contains a script file that uses .exe files
Hi Team, we are migrating our on-prem databases to Azure Sql managed Instance and as a part of migration we wanted to run our ssis packages in ADF using Execute SSIS package activity. But in our SSIS packages we have some script task which are using…
asked 2024-10-09T08:48:16.89+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, 89%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIL%3C/text%3E%3C/svg%3E)
Indra Lakshmi Rupa Madhuri Boddeda
0
Reputation points
commented 2024-10-14T18:59:08.2966667+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, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chandra Boorla
2,605
Reputation points Microsoft Vendor
5 answers
Issues in using Microsoft.Data.SqlClient in SSIS project
I have installed visual studio 2022 image and installed SQL Server Integration Services Projects 2022. I am trying to implement functionality of ado.net using Microsoft.Data.SqlClient and running into below issues. ADO NET Destination has failed to…
asked 2023-11-07T23:13:16.0566667+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, 1%, 36%)' 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)
veera
0
Reputation points
answered 2024-10-08T15:47:17.0333333+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, 17%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Luis Martinez
0
Reputation points
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,970 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.
538 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,734 questions
asked 2024-10-01T22:49:57.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(131.20000000000002, 69%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
MasterSQL
0
Reputation points
commented 2024-10-07T02:25:35.6066667+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
46,296
Reputation points Microsoft Vendor
2 answers
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
![](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, 43%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVT%3C/text%3E%3C/svg%3E)
võ thị tuyết ngân
20
Reputation points
answered 2024-10-07T01:45:23.6366667+00:00
ZoeHui-MSFT
37,441
Reputation points
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
![](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, 50%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Vincent Molloy
0
Reputation points
commented 2024-10-01T18:07:53.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(227.2, 46%, 32%)' 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)
NIKHILA NETHIKUNTA
2,950
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
![](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, 57.99999999999999%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Spencer-Jones, Mike
6
Reputation points
commented 2024-09-26T10:16:56.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(16, 70%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
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,590 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.
538 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.
11,005 questions
asked 2024-09-19T18:56:39.9633333+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, 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)
Villa
231
Reputation points
commented 2024-09-23T09:27:25.9233333+00:00
Jiale Xue - MSFT
46,296
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
![](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(185.6, 88%, 27%)' 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)
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
![](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(297.6, 9%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EME%3C/text%3E%3C/svg%3E)
Mostafa Elframawy
0
Reputation points
commented 2024-09-18T14:57:04.6233333+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(185.6, 1%, 27%)' 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)
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
![](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, 31%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVV%3C/text%3E%3C/svg%3E)
Vlasopoulos V
10
Reputation points
answered 2024-09-11T20:29:01.65+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(35.2, 68%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
ROHTASHV GEHLLOT
10
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
![](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(214.4, 65%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKV%3C/text%3E%3C/svg%3E)
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
![](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(105.60000000000001, 7.000000000000001%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXK%3C/text%3E%3C/svg%3E)
Xavier Klausener
6
Reputation points
commented 2024-09-09T19:13:05.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(41.6, 72%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
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
![](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, 98%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Robin Glass
0
Reputation points
commented 2024-09-08T18:58:14.27+00:00
Erland Sommarskog
112.7K
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
![](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, 18%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
Laura Alvarez
20
Reputation points
accepted 2024-09-06T18:26:18.37+00:00
Laura Alvarez
20
Reputation points