Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: READING NVARCHAR(MAX) fields

READING NVARCHAR(MAX) fields 3 months 2 days ago #19545

  • mdspeirs
  • Topic Author
  • Offline
  • Expert Boarder
  • Expert Boarder
  • Posts: 112
  • Karma: 1
  • Thank you received: 1
AETLE 6.3.5.7
WINDOWS SERVER 2012 R2
AZURE SQL SERVER database

When attempting read in data from an Azure hosted SQL SERVER database, the data populates when "Browsing" the data but doesn't render in the reader preview or get passed through in the transformation.


Some fields don't have a defined width in the database.


These show as zero width in the reader definition Size/Precision column and can't be adjusted.


Ideas on how to address?
Attachments:

Please Log in or Create an account to join the conversation.

READING NVARCHAR(MAX) fields 3 months 2 days ago #19546

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7736
  • Karma: 33
  • Thank you received: 450
Hi.

Can you try rewriting the query as described here:
www.etl-tools.com/wiki/knowledgebase/blob_field_is_empty
Mike

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 229 guests and one member online