|
| I recently installed SQL 2005 Developer Edition, and ODBC access is only
supported via ADO.net wrapper. Did MS take out native ODBC support? In the
past I'm able to select existing ODBC connections and import data from Cache
(intersystems database) with no problem, but now with ADO.net ODBC, it does
not let me select tables, I must write a SQL query and import data one table
at a time, which is really cumbersome, and I'm running into a error importing
text fields:
TITLE: SQL Server Import and Export Wizard
------------------------------
Could not connect source component.
Error 0xc0204016: DTS.Pipeline: The "output column " Path_Referral_Declin
ed"
(66)" has a length that is not valid. The length must be between 0 and 4000.
For some reason it's seeing the field as varchar, and I can't work around it
(tried assigning field as text, vtext, use substring to trunc import data all
with no luck).
Did I miss any critical component during installation???
Thanks,
Nan
|
|