Exporting Binary Data from MSSQL to MySQL

I have a MSSQL table with Primary Keys, Company_Id, set as a binary
value. I used the dts Transform Data Task and to create a new table in
MySQL.
The default create code comes up with:
CREATE TABLE `New Table` (
`Web_Edited` tinyint unsigned NULL,
`Company_Id` date NOT NULL,
`Rn_Descriptor` varchar (80) NULL, ...
Why is the Company_Id set to date and not varbinary?
Secondly, if I change the create statement
...`Company_Id` date NOT NULL, ...
to
... `Company_Id` varbinary(8) NOT NULL, ...
then on the Transform Data Task's Destination Tab, the Company_Id is
displayed as longtext. And then I specify that the Company Id column
is the only column I wanted in the transformation, and executed the
trasformation.
I get an error stating this:
The number of failing rows exceeds the maximum specified.
TransformCopy 'DTSTransformation__1' conversion error: General
conversion failure on column pair 1(source column 'Company_Id'
(DBTYPE_BYTES), destination column 'Company_Id' (DBTYPE_STR))
But I already specified the Company_Id column as a binary, and I even
checked the mysql table's strucutre and it was also set to varbinary(8)
Please help.Hi
I don't know much about MYSQL, but this may be a driver issue, are you using
ODBC? If mysql can import text files you may want to try using BCP and then
importing from MYSQL.
John
"datenisis@.gmail.com" wrote:

> I have a MSSQL table with Primary Keys, Company_Id, set as a binary
> value. I used the dts Transform Data Task and to create a new table in
> MySQL.
> The default create code comes up with:
> CREATE TABLE `New Table` (
> `Web_Edited` tinyint unsigned NULL,
> `Company_Id` date NOT NULL,
> `Rn_Descriptor` varchar (80) NULL, ...
> Why is the Company_Id set to date and not varbinary?
> Secondly, if I change the create statement
> ...`Company_Id` date NOT NULL, ...
> to
> ... `Company_Id` varbinary(8) NOT NULL, ...
> then on the Transform Data Task's Destination Tab, the Company_Id is
> displayed as longtext. And then I specify that the Company Id column
> is the only column I wanted in the transformation, and executed the
> trasformation.
> I get an error stating this:
> The number of failing rows exceeds the maximum specified.
> TransformCopy 'DTSTransformation__1' conversion error: General
> conversion failure on column pair 1(source column 'Company_Id'
> (DBTYPE_BYTES), destination column 'Company_Id' (DBTYPE_STR))
> But I already specified the Company_Id column as a binary, and I even
> checked the mysql table's strucutre and it was also set to varbinary(8)
> Please help.
>sql

Exporting Binary Data from MSSQL to MySQL

I have a MSSQL table with Primary Keys, Company_Id, set as a binary
value. I used the dts Transform Data Task and to create a new table in
MySQL.
The default create code comes up with:
CREATE TABLE `New Table` (
`Web_Edited` tinyint unsigned NULL,
`Company_Id` date NOT NULL,
`Rn_Descriptor` varchar (80) NULL, ...
Why is the Company_Id set to date and not varbinary?
Secondly, if I change the create statement
...`Company_Id` date NOT NULL, ...
to
... `Company_Id` varbinary(8) NOT NULL, ...
then on the Transform Data Task's Destination Tab, the Company_Id is
displayed as longtext. And then I specify that the Company Id column
is the only column I wanted in the transformation, and executed the
trasformation.
I get an error stating this:
The number of failing rows exceeds the maximum specified.
TransformCopy 'DTSTransformation__1' conversion error: General
conversion failure on column pair 1(source column 'Company_Id'
(DBTYPE_BYTES), destination column 'Company_Id' (DBTYPE_STR))
But I already specified the Company_Id column as a binary, and I even
checked the MySQL table's strucutre and it was also set to varbinary(8)
Please help.Hi
I don't know much about MYSQL, but this may be a driver issue, are you using
ODBC? If MYSQL can import text files you may want to try using BCP and then
importing from MYSQL.
John
"datenisis@.gmail.com" wrote:
> I have a MSSQL table with Primary Keys, Company_Id, set as a binary
> value. I used the dts Transform Data Task and to create a new table in
> MySQL.
> The default create code comes up with:
> CREATE TABLE `New Table` (
> `Web_Edited` tinyint unsigned NULL,
> `Company_Id` date NOT NULL,
> `Rn_Descriptor` varchar (80) NULL, ...
> Why is the Company_Id set to date and not varbinary?
> Secondly, if I change the create statement
> ...`Company_Id` date NOT NULL, ...
> to
> ... `Company_Id` varbinary(8) NOT NULL, ...
> then on the Transform Data Task's Destination Tab, the Company_Id is
> displayed as longtext. And then I specify that the Company Id column
> is the only column I wanted in the transformation, and executed the
> trasformation.
> I get an error stating this:
> The number of failing rows exceeds the maximum specified.
> TransformCopy 'DTSTransformation__1' conversion error: General
> conversion failure on column pair 1(source column 'Company_Id'
> (DBTYPE_BYTES), destination column 'Company_Id' (DBTYPE_STR))
> But I already specified the Company_Id column as a binary, and I even
> checked the MySQL table's strucutre and it was also set to varbinary(8)
> Please help.
>

Exporting binary data

We're using MS-SQL Sever for a documentation database. One of the tables
stores all the DOC, XLS and PPT documents fed by our users.
We need to export all the files to certain directory and the rest of the
table contents to a spreadsheet. We want to distribute the documents in a
promotional CD.
The data export to a CSV works without a problem but we don't know how to
export the binary data of the files that are stored in the table. How can
this be done?
Thanks in advance,
JT
Jaime Torres wrote:
> We're using MS-SQL Sever for a documentation database. One of the
> tables stores all the DOC, XLS and PPT documents fed by our users.
> We need to export all the files to certain directory and the rest of
> the table contents to a spreadsheet. We want to distribute the
> documents in a promotional CD.
> The data export to a CSV works without a problem but we don't know
> how to export the binary data of the files that are stored in the
> table. How can this be done?
> Thanks in advance,
> JT
Please try not to multi-post. See ".Clients" for the current active
thread.
David Gugick
Quest Software
www.imceda.com
www.quest.com

Exporting binary data

We're using MS-SQL Sever for a documentation database. One of the tables
stores all the DOC, XLS and PPT documents fed by our users.
We need to export all the files to certain directory and the rest of the
table contents to a spreadsheet. We want to distribute the documents in a
promotional CD.
The data export to a CSV works without a problem but we don't know how to
export the binary data of the files that are stored in the table. How can
this be done?
Thanks in advance,
JTJaime Torres wrote:
> We're using MS-SQL Sever for a documentation database. One of the
> tables stores all the DOC, XLS and PPT documents fed by our users.
> We need to export all the files to certain directory and the rest of
> the table contents to a spreadsheet. We want to distribute the
> documents in a promotional CD.
> The data export to a CSV works without a problem but we don't know
> how to export the binary data of the files that are stored in the
> table. How can this be done?
> Thanks in advance,
> JT
Please try not to multi-post. See ".Clients" for the current active
thread.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com

Exporting binary data

We're using MS-SQL Sever for a documentation database. One of the tables
stores all the DOC, XLS and PPT documents fed by our users.
We need to export all the files to certain directory and the rest of the
table contents to a spreadsheet. We want to distribute the documents in a
promotional CD.
The data export to a CSV works without a problem but we don't know how to
export the binary data of the files that are stored in the table. How can
this be done?
Thanks in advance,
JTJaime Torres wrote:
> We're using MS-SQL Sever for a documentation database. One of the
> tables stores all the DOC, XLS and PPT documents fed by our users.
> We need to export all the files to certain directory and the rest of
> the table contents to a spreadsheet. We want to distribute the
> documents in a promotional CD.
> The data export to a CSV works without a problem but we don't know
> how to export the binary data of the files that are stored in the
> table. How can this be done?
> Thanks in advance,
> JT
Please try not to multi-post. See ".Clients" for the current active
thread.
David Gugick
Quest Software
www.imceda.com
www.quest.com