Darren wrote:

Then I wrote:

>This is a "repost" continuing where a post left off. The subject has
>changed. The original post was "bas file does nothing".
>I get the following error when executing a package from vb script:
>Source: Microsoft Data Transformation Services Flat File Rowset Provider
>Description: Incomplete file format information - file cannot be opened.
>
>Darren wrote:
>Flat File Rowset Provider is the text file driver, so that is the error
>source basically. Sounds like something if wrong in that area, or just missing
>information, maybe a record terminator.
>
>Then I wrote:
>Darrel, this is not all that surprising. The record terminator is a
>pipe + a return character that appears as a square in notepad. It
>translates to chr(10) in visual basic. I can't get bulk copy to
>recognized it to save my life, which is why I'm trying to make it
>happen with DTS. MS Access can deal with it. DTS has no problem with
>the file when I run the local package from within Enterprise manager.
>Why does it cough when I run it from the VB script? (The vb script was
>created when I saved the package as visual basic from the DTS wizard.)
>Also, is there a spot in the code where I can define the record
>terminator?...I could not find one in the bas that Ent Mgr created.
>