I'm new to MYSQL and need to export data from MYSQL into SQL Server. I have tried downloading a ODBC driver onto the machine however I get an architecture mis match message when trying to use SSIS to create the connection or using import/export method from SQL Server.
I have also tried using a linked server however get this message:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "CODA_IMPACT".
OLE DB provider "MSDASQL" for linked server "CODA_IMPACT" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". (Microsoft SQL Server, Error: 7303)
Can you please advise what the best method is for this. I am a SQL server DBA and have very little experience of MYSQL!
Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…