Results 1 to 2 of 2

Thread: in dts environment it runs, at command line it dies

  1. #1
    steve Guest

    in dts environment it runs, at command line it dies


    I have a simple dts package that takes a text file and populates a single row in a sql7 table. When I run the package from within sql7 it runs properly. When I run it from the command line, calling it through a .bat file using dtsrun, I'm told the row delimiter was not found. This is my test file,"1111,1111,1111,|". The vertical bar is my row delimiter.
    Actually, I don&#39;t even want to use a row delimiter, since the file being input is data for one single row. But when I try to create the dts package with <none> selected as my row delimiter, it tells me &#34;Invalid row delimiter&#34;. Any advice on this part is greatly appreciated, too.

  2. #2
    Dale Shaw Guest

    in dts environment it runs, at command line it dies (reply)

    >>> &#34;1111,1111,1111,|&#34;

    My first guess would be the last comma (before the bar) but I have no clue as to why DTSrun is different!


    Dale


Posting Permissions

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