Help to understand "Define Columns Type Quotable"

• EE02757

  SSC Veteran

  Points: 210

  More actions

  September 5, 2007 at 2:26 am

  #70231

  Hi everybody,

   

  i would like to have help to understand a data type properties i have seen on a Transform Data Task. I precise that i am not american or english so it is more difficult for me to understand...

  I have a dts (made by another guy) that put data from a table on a file text. The thing i don't understand is what is data type "Quotable" ?

  For example if i have from the source this data 79898 what is the difference to the destination if the type of the column is quotable or not?

  Morever i would like to know about the size, i can see a field called "size" but what is the data type (varchar,integer...)? 

  Ex: Name : id Type : Quotable Size : 128  

  If anybody could help me that would be great

  Thanks.

  Bye

• Johan Bijnens

  SSC Guru

  Points: 135369

  More actions

  September 5, 2007 at 5:09 am

  #731442

  IMHO your "quotable" datatype is a user defined datatype

  Easyest way to find out is to use Enterprise Manager, connect to the database and browse to the "user defined datatypes" section.

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me