Use SSMA for DB2 to Migrate AIX DB2 11.5.9 to SQL Server 2019
Is it possible to use the SSMA tool to migrate an AIX DB2 (Big endian) to Windows SQL Server 2019 (little endian)?
Is it Possible or is there a way to use the database you have been working on the developer option for production?
Can I migrate the database I made on the developer version to the express version or is there a way to use the database you created using the developer version for production purposes, say if you can transfer my database to the express version or pay for…
Unable to start Microsoft SQL Server Migration Assistant for Access
I have installed SQL Server Migration Assistant for Access, but it will not start up. When I launch the program, it displays the splash screen and as it is displaying the message "Configuring Telemetry...", the program throws an exception. How…
best approach to migrating a table from system to another
I have a test system where we update entries on a table for cross refence purpose and was wondering the best approach for this.
Could you please suggest the list of software needed to register and use a custom component in data tools tool box using VS2019 in x64
Issue Description: Facing issue in setting up and running SSIS in debug mode in VS2015 that can recognize 64-Bit C# custom components in Data Tools Tool box. Created MyCustomComponent.dll by referencing below dlls. Took the dlls from…
Best way to learn SSIS
I got a new role where we will use SSIS to migrate data from test system to production. What would be the best way to learn SSIS as I have worked with T-SQL and SSMS. It will be on premise 2019 edition.
where can I find Microsoft.ACE.OLEDB.12.0 Provider 64-bit
hello, We need the driver "Microsoft.ACE.OLEDB.12.0 Provider 64-bit", but it is no longer available! Could you provide me with a download link? Regards
Lift Azure SSIS to adf , Can we mount blob storage in SSIS integration Runtime
In SSIS we are reading multiple files from D:(local drive) In azure all the file are available in blob Is it possible to mount blob storage with ssis integration run time? so that with minimal changes we can do lift and shift or else we need to work…
SS Migration Assistant (SSMA) for Oracle: BLOBS larger than 2GB and SSMA Support for FILESTREAM columns
Hi. I'm trying to determine if the SSMA utility for Oracle to SQL Server supports the migration of BLOB data larger than 2GB in size. I tried running a test SSMA run, and during the Convert step, it looks like the target SQL Server table creation…
SSIS package running fine in visual studio but when trying to run same package its failing.
Dear Team, I want to do simple copy activity using Data flow task in SSIS package, in which my source is a old database using visual fox bro and tables are saved as dbf files . I am using OLE DB connector for visual fox pro to get data from source dbf…
ORA-01017 Error in SSMA for Oracle
I am trying to leverage SSMA for Oracle and am running to an ORA-01017: Invalid username/password; logon denied error when trying to connect to the Oracle dB. A UDL connection to the Oracle dB from the same machine and with the same credentials works…
SSIS Send Mail Task Fails on Out of office
I have a simple Send Mail Task that sends an email to a list of dynamic users. If one of those users has "out of office" set, the SSIS flow fails. The next day, when it sends again, it works, because "out of office" doesnt respond…
Connection to ACCESS database fails with exception: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
Connection to ACCESS database fails with exception: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine How can i solve this problem ? Please guide me
unable to uninstall sql server 2019
while uninstalling sql server the below error is popping up kindly help
Struggling with SSIS lookup date key transformation
How do i fix the below error, i have confirmed a million times that the data type is the same. The date formats are different though. Could that be the problem
Transaction Log is full due to 'ACTIVE_TRANSACTION'
Hi While migrating data from a Sybase SQL server to MS SQL Server uusing SSMA for Sybase v9.4 I found about 40 errors showing: Errors: The transaction log for database 'MyDatabase' is full due to 'ACTIVE_TRANSACTION'. In result I believe the migration…
Not able to add sql server to west europe location, while my azure portal students account is based in the Netherlands.
I'm not able to create a sql server in west europe, but i am able to create servers in other regions using my azure for students account. Using other regions costs too much for data transfer between regions. Would anyone know the solution or why i can't…
Issues with SQL failover cluster on windows 2016 migration
Hi, We are in the process of migrating our windows server 2012 servers to 2019 and we are using failover cluster to maintain our SQL always on. As we know , it's only possible to get to 2019 through windows 2016 for compatibility reasons and i'm familiar…
How upload a file from my pc in sharepoint online
Hi, I create a ssis that produce a file xls test.xlsx, saved in a local directory of my pc. Then I would like to copy this file in a sharepoint online es.…
PC OS clean install. How to transfer SQL license?
Have this SQL server: Microsoft SQL Server 2017 Enterprise Edition: Core-based Licensing (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 17763: ) And trying to update windows to windows 11. Is there a way to transfer the SQL license? Thanks.