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 Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
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 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