DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: DTS export

  1. #1
    justin Guest

    DTS export


    I designed a dts export that exports data from several tables into a

    text file. when designing the DTS package in the DTS GUI it asks for

    the text file properties for the output ascii file. I need the row

    delimiter to be two carriage returns. The only option I see is one

    carriage return or a carriage return and line feed. How do I configure

    two carriage returns as the row delimiter.

  2. #2
    Francisco Guest

    Re: DTS export


    Try editing the script generated by the DTS wizzard

    Francisco




    "justin" <jhandel@eagleusa.com> wrote:
    >
    >I designed a dts export that exports data from several tables into a
    >
    >text file. when designing the DTS package in the DTS GUI it asks for
    >
    >the text file properties for the output ascii file. I need the row
    >
    >delimiter to be two carriage returns. The only option I see is one
    >
    >carriage return or a carriage return and line feed. How do I configure


    >
    >two carriage returns as the row delimiter.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center