Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
DT_NTEXT unicode text field becomes DT_WSTR string, thus NULL data |
Author |
Message |
|
Posted : 2008-08-18 16:33:16 |
Downloaded SQL 2008 to be installed as another instance. SSIS package works in SQL 2005 suddenly stop working right. Had to strip out both SQL 2005 and SQL 2008 installations, reinstall SQL 2005 from scratch to make it back.
Use another server with only SQL 2008 to test, we can recreate the problem. It seems that , for some reason, every text columns maps to string columns in destination table. Without ending zeros, those ListID fields are nothing but NULL in the SQL tables now. Could it be the nvarchar data type?
Please help. We do need SQL 2008 for the new Tablix feature in Report Server 2008.
Thanks a lot.
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-08-18 19:46:40 |
Based on what I've seen so far with Visual Studio 2008, Microsoft now defaults its products to operate in 64 bit mode. Check that there isn't an explicit option or setting for 32 bit drivers like QODBC. |
|
|
|
|
Posted : 2009-02-19 09:03:01 |
Did you ever resolve this issue? I am having the same problem. I have installed SQL 2008 32 bit on a 32 bit version of windows so I don't think I'm having x64 mode issue? |
|
|
|
|