I am trying to Create barcodes from intranet site(can't
use commercial app):
1) Create barcode script on client (based on user
selections in page)
2) click print and send various information for
documentation (including script) to SQL server per Stored
procedure, which:
a) inserts data in table
b) executes second stored procedure to print, which:
1. bcp (per query) barcode command to .txt file
2a. dtsrun package to execute .bat file to send
barcode script (in .txt direct to printer
(without windows drivers, which interefer
with barcode script)
2b. direct to printer with xp_cmdshell and print
command

So, I can get as far as getting the barcode script into
the .txt file. When the batch file is run (from dts per
dtsrun in SQL server), I get a message that the .txt file
(which was created in the previous step)is not found (I do
make it to the batch file!).

With the 2b option, I also get that the file is not
found.

Note: If I run the dts package alone (click play) the
barcode from the .txt is printed fine). dtsrunf from
command line outside of SQL server also works.

I have read the MSKB 269074 at least once a day for the
past week. The SQL Server Agent is running as me, system
admin. The package also belongs to me. The dtsrun is
either as "sa" or with parameter /E (neither work). I
have a shiney Euro for anyone with the solution (or
suggestions where I might find one).**

Thanks for any help
Lenz

**You won't really recieve a shiney Euro. Or any Euro. I
will however wish the best for you and your family. Sorry.