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
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…
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…
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)?
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.
Date Datatype Issue in the Lookup in SSIS
Hello, I map "date" information obtained from the Excel source in SSIS (1.3.2 version) through the Data Conversion Transformation Editor with the 'database date' data type In Date Lookup Transformation Editor, I use the Date_Dim table and the…
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…
SSMS not installing
I have downloaded SSMS-Setup-ENU But when I double click to install nothing happens. Even when I try to run as an administrator nothing pops up
Error Add-Migration ?
I'am student and I learn ASP.NET.CORE 6 MVC so I use Add-Migration in the Packed Manager Console. I see error No suitable constructor was found for entity type 'FilterDescriptor'. The following constructors had parameters that could not be bound to…