Oracle Connector For SSIS
We are migrating our SQL Server to 2021. We currently use the Antiunity driver which can no longer be used with latest version of SQL and SSIS. When we tried to use the "Microsoft Connector for Oracle" the source spooling is very slow and not…
MSB1009: Project file does not exist, Switch: database
My web application is not showing my images because there is an issue with my database I then fixed this as the issue was Caps. When I tried to run 'dotnet ef database update' this is the error I received: Found some duplications and fixed them but the…
Migrating from ADF to SSIS
I have been using the Azure Data Factory as the ETL tool but I would like to downgrade/migrate to the on-prem SSIS due to business decision. Is there a way to go about this except re-writing the pipelines? Maybe a lift and shift solution? All the…
SQL Server 2019 Upgrade Problem
I am attempting to upgrade from SQL Express 2014R2 to SQL 2019 Standard and have run into an issue :: Database Engine Services -FAILED :: SQL Client Connectivity SDK - FAILED We have run out of room with the Database and Express ;;; Thanks in…
raw file source task is unique in SSIS due to which properties associated with it
raw file source task is unique in SSIS due to which properties associated with it. ( choose one or more options, which suitable) a. it is aware of the sort order of the data in the source file b. it doesn't create a connection manager when configured c.…
SSMA for Oracle Crash at Data Migration
Hi, I am working for Oracle to SQL Server Migration through SSMA. i migrated tables structure to sql server. it has around 4800 Tables. it takes lot of time to create structure as well as analyse metadata. Migrating data... Analyzing…
my project team is looking to automatically print food orders from SSIS ...
and it does not provide a method to print (it create for data migration, data transformation, and integrations). Is it possible to send the PDF files to be printed in an automated fashion, as the team was unable to find any APIs for PaperCut that would…
Migrate from DB2 to Azure Database for PostgreSQL/MySQL/MariaDB
Hi, Is it possible to migrate a DB2 database to Azure database for PostgreSQL/MySQL or MariaDB? Thanks for the helping and documentation to do this process. Cordially, Albeiro Jiménez López
PostgreSQL single server to flexible server migration error - permission denied for admin user
When I am doing migration of 3 databses(schemas), between single server and flexible server postgresql I am getting error shown below Data migration could not be started for one or more of the DBSets. Error details: PGv2RestoreError: PG Restore…
How to download older version of SQL Server Migration Assistant for DB2?
We are facing issues with SSMA for DB2 version 9.3 and unfortunately thats the only version that is currently available for download. The tables from DB2 (for i) in the metadata explorer are not showing any column information. We used SSMA for DB2 v9.2…
SQL audit file Rollover is not working
HI all. SQL audit file Rollover is not working I try. The SQL Service account has full permissions to the folder, and I Try disable/enable the audit session to see if it removes the file. and it works for some days. Please give me some advice.
Issue with SSMA for DB2 not displaying table fields and formats
I successfully connected SSMA for DB2 to IBM i DB2 and can see schema names and tables in the DB2 Metadata Explorer. However, clicking on a table does not show the table column/field names and formats under the table tab on the right side. Why is this…
SSMAforSybaseConsole.EXE causes FileIsLockedException
Executing more than 1 or 2 sessions using SSMAforSybaseConsole.EXE in Powershell / cmd causes FileIsLockedException. How to resolve this ? Unhandled Exception: Microsoft.SSMA.Framework.Generic.Factories.Utils.FileIOUtils+FileIsLockedException: The…
How Do I Migrate a Managed Instance of SQL Server to Another Cloud?
How Do I Migrate a SQL Server Managed Instance to Another Cloud?
How to fix data convertion error from string value to int in ssis
Currently, I am working on a task where I am using the "SSIS Integration Toolkit for Microsoft Dynamics 365" to fetch data from online dynamic CRM source and populate this to on prem CRM database(just a copy activity). I am using dynamic crm…
How to fix power function issue while changing db compatibility level change
We are using sql server 2019 server with db 110 compatability. Currently we are changing the DB compatability level from 110 to 150.After changing the compatability level to 150 , we have noticed the breakage there in the power of function and its…
SSMA for Sybase - Schema conversion error
HI, I am using SSMA for Sybase to test migration from SAP ASE 16 to MS SQL Server 2019 on Linux (Microsoft SQL Server 2019 (RTM-CU16-GDR) (KB5014353) - 15.0.4236.7 (X64) May 29 2022 15:55:47 Copyright (C) 2019 Microsoft Corporation Enterprise…
SQL Server Import and Export Wizard: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)
I wish to import data to a SQL Server from an Excel spreadsheet via SQL Server Management Studio Management Studio (SSMS) 2019's Import Data feature. I have: Microsoft SQL Server 2022 Microsoft SQL Server Tools 19 SQL Server Management Studio…
Issues while connecting the oracle to the SSMA
Hi, I am facing the below issue while connecting to the oracle through SSMA. What could be the reason ? I am able to connect to the SSMA with the oracle sql developer perfectly and i feel the oracle user connected has the admin rights
Query on SQL services
Hi I am running Microsoft SQL 2016(SP3-GDR)(KB5021129) v13.0.6430.49 (X64) on Windows Server 2012R2. The VM is in Azure.I want to upgrade the VM to Windows Server 2019. Will this SQL version support Windows Server 2019.Are there any steps which needs to…