-
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'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 "Invalid row delimiter". Any advice on this part is greatly appreciated, too.
-
in dts environment it runs, at command line it dies (reply)
>>> "1111,1111,1111,|"
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
-
Forum Rules
|
|