April 26, 2021 at 11:51 am
I am having trouble moving data with ssis fromSQL Sever to Maria DB. When i run the following script, the table gets created in Maria DB. But no access to upload the data.
Here is the error: "TITLE: Microsoft Visual Studio ------------------------------
The table name could not be retrieved from the script provided. Select a table or a view from the list.
------------------------------ BUTTONS:
OK ------------------------------ "
SQL:
CREATE TABLE ADO NET Destination ( uid BIGINT, order_uid BIGINT, product_uid BIGINT, label VARCHAR(150), selling_unit VARCHAR(80), price VARCHAR(10), quantity VARCHAR(10), amended_quantity VARCHAR(10), adjusted_quantity VARCHAR(30), margin VARCHAR(30), out_of_stock VARCHAR(1), comments VARCHAR(250), edi_cost_price VARCHAR(50), edi_rsp VARCHAR(50), edi_promo_price VARCHAR(50), picked VARCHAR(1), oos_qty INT )
Please assist?
April 26, 2021 at 12:01 pm
As I suggested in one of your other threads, SSIS needs to 'see' the table it is going to load data into at design time, not at run time.
Do the CREATE TABLE first, outside of SSIS and then build the data transfer in SSIS.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
April 26, 2021 at 8:02 pm
SSIS does not recognise any of my tables in the MySQL/Maria DB. That is the problem.
April 27, 2021 at 2:05 pm
SSIS does not recognise any of my tables in the MySQL/Maria DB. That is the problem.
This is what you should solve first, in my opinion. It's not a technology I have worked with, so I cannot help further in this case.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply