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…
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…
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…
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?
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.
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…
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…
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…
Can't restore databse on Microsoft SQL server management studio
=================================== Restore of database 'AdventureWorks2019' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks) Program Location: at…
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…
create an azure serverless database
Customer currently has much of the cloud environment in AWS and they will start to migrate to Azure
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.
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…
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…