Results 1 to 5 of 5

Thread: DTS question???

  1. 12-12-2003, 12:26 PM #1
    Taz2
    Taz2 is offline Registered User
    Join Date
    Dec 2003
    Posts
    4

    DTS question???

    Hi,

    When using DTS to export I noticed that I lost half of my data, it seems all the row lost all data beyond the 256th character. Is this a limitation of DTS? Can this be changed and how? TIA
    Reply With Quote Reply With Quote
  2. 12-12-2003, 12:37 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    1. Open DTS package in design mode
    2. Click package - Disconnect edit
    3. Expand connection (text connection)
    -OLEDB Properties -
    4 click on "Max character per delimited columns" - double click on "value"
    Change 255 to 1024.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 12-12-2003, 12:41 PM #3
    Taz2
    Taz2 is offline Registered User
    Join Date
    Dec 2003
    Posts
    4
    Thank you.
    Reply With Quote Reply With Quote
  4. 12-12-2003, 12:46 PM #4
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Did you try it?
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  5. 12-12-2003, 12:50 PM #5
    Taz2
    Taz2 is offline Registered User
    Join Date
    Dec 2003
    Posts
    4
    Yes, I did and it work. Thank you again for your help.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules