Post reply

Is it possible to make a form feed the row delimiter?

  • August 21, 2006 at 1:08 pm

    #67619

    I'm trying to create a DTS package under SQL Server 2000.

    I'm using a plain text file as my destination. (my end users need a REALLY easy way to read the export file)

    Because I'm exporting resumes, I need a form feed as my row delimiter.

    The DTS "options" tab allows me to manually type in "{FF}", but then ignores it when creating the file.

    I also tried appending various versions of "0x0C" to the field I'm exporting, but the resume field is ntext, and doesn't play well with varchar.

    I do understand that a text file won't "show" the form feed, but I was hoping that it would still accept the ASCII character when they open the file in MS Word.  Is there something I'm missing, or am I just attempting the impossible?

    Thanks,

    Dan

  • August 22, 2006 at 7:17 am

    #656102

    Dan, I think what you need is a ActiveX Script Task added in the workflow before your DTS transformation.  Use can use a vbCrLf as a line feed or vbFormFeed as a form feed. 

    Here is some example code using hte vbCrLf (the Control Line feed can also be accomplished in the gui by using {CR}{LF}.

    '**********************************************************************

    '  Visual Basic ActiveX Script

    '************************************************************************

    Function Main()

     Dim oConn

     Set oConn = DTSGlobalVariables.Parent.Connections("Text File (Destination)")

     oConn.ConnectionProperties("Row Delimiter").Value = vbCrLf

     Set oConn = Nothing

     Main = DTSTaskExecResult_Success

    End Function

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • August 22, 2006 at 9:05 am

    #656129

    Excellent, just what I needed.

    Thanks Luke!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply