Pipeline component has returned HRESULT error code 0xC0208457 from a method call.
Please assist, is this code correct?
use marketing;
CREATE TABLE App_menu_filters9( uid BIGINT NULL, tenant_uid INT NULL, label VARCHAR(50) NULL, sub_copy VARCHAR(300) NULL, opt_order INT NULL, level INT NULL, icon VARCHAR(100) NULL, header VARCHAR(50) NULL, parent_uid INT NULL, minimum_stock_balance numeric(10, 2) NULL, atp_percent numeric(10, 2) NULL, margin_percent numeric(10, 4) NULL, partner VARCHAR(50) NULL, datetime_updated datetime NULL, status VARCHAR(1) NULL)
I am trying to connect maria db as a destination in ssis, i am getting this error:
TITLE: Microsoft Visual Studio ------------------------------
Pipeline component has returned HRESULT error code 0xC0208457 from a method call. Error at Data Flow Task [ADO NET Destination [220]]: Failed to get properties of external columns. The table name you entered may not exist, or you do not have SELECT permission on the table object and an alternative attempt to get column properties through connection has failed. Detailed error messages are: ERROR [42000] [MySQL][ODBC 8.0(a) Driver][mysqld-5.5.5-10.4.21-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"app_menu_filters91"' at line 1 Could not load provider specific information because the specified directory "C:\Program Files (x86)\Microsoft SQL Server\150\DTS\ProviderDescriptors\" does not exist.
------------------------------ BUTTONS:
OK ------------------------------
Answer Answered by Marko Mäkelä in this comment.
The statement does not correspond to the error message, because the identifier "app_menu_filters91" only occurs in the error message but not in the SQL statement.
