TSQL To Maria DB
-
I am trying to load dat from TSQL Into Mysql/Maria DB. I get an aoutamic warning when trying to create the destination table about manually edit data types for destination table. I looked at the TSQL n Maria DB data types. I changed it from
CREATE TABLE "ADO NET Destination" (
"uid" BIGINT,
"order_uid" BIGINT,
"product_uid" BIGINT,
"label" NVARCHAR(150),
"selling_unit" NVARCHAR(80),
"price" NVARCHAR(10),
"quantity" NVARCHAR(10),
"amended_quantity" NVARCHAR(10),
"adjusted_quantity" NVARCHAR(30),
"margin" NVARCHAR(30),
"out_of_stock" NVARCHAR(1),
"comments" NVARCHAR(250),
"edi_cost_price" NVARCHAR(50),
"edi_rsp" NVARCHAR(50),
"edi_promo_price" NVARCHAR(50),
"picked" NVARCHAR(1),
"oos_qty" INT
)
To
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
)
I get an error, please assist?
-
There is something strange going on here.
Are you trying to create a table within a data flow? (I see a Mappings node)
The absence of evidence is not evidence of absence.
Martin ReesYou can lead a horse to water, but a pencil must be lead.
Stan Laurel -
Yes, I can complete thos process easily when i do it within a TSQL DB, but this is giving me errors in thise case, data types differences.
- yrstruly wrote:
Yes, I can complete thos process easily when i do it within a TSQL DB, but this is giving me errors in thise case, data types differences.
Use an ExecuteSQL task to perform DDL (like CREATE TABLE).
Use data flows to move data.
But this is likely to be problematic, as SSIS expects tables to be present at design time.
The absence of evidence is not evidence of absence.
Martin ReesYou can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply