March 28, 2012 at 12:47 pm
We have a database that we pull records out of daily from MYSQL to SQL. Some fields populated in MYSQL show as blank in SQL.
Example - Dialednumber (Unicode string [DT_WSTR]) goes to SQL - Dialednumber nvachar(97)
other fields come through just fine.
Any ideas?
March 28, 2012 at 2:19 pm
What is the source definition for the affected columns?
Do you get any errors?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 28, 2012 at 2:25 pm
I get no errors, just blank fields. Brings in all the records. If I use mysql browser and select the records from the table I can see the field populated.
from mysql field is unicode string [DT_WSTR] Length of 97
I don't usually use mysql, just sql and use SSIS about once a month so my skills are a little rusty.
May 7, 2012 at 2:59 pm
Sadly, expect to do a data conversion on every MySQL field you bring over. SSIS can be so touchy about its own data types that bringing them in from other databases is even more of an issue.
Adding the data conversion step to my packages has resolved any errors due to data types.
May 8, 2012 at 12:17 am
How exactly do you transfer the rows? Can you describe the dataflow?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply