I am exporting my data to a .txt file, and then trying to
run VBScript that would open that file and read it. VB
script works great outside the DTS if I have the file
created. When I run it in DTS it gives me the following
error "Permission Denied". Do I have to do anything
special??? The .txt file is in the correct location and
there.

I am using MSSLQ7.

Thanks,
BB

I forgot to add - i have a VB script run either on
completion or success of export.. this is all done via
the designer.

thanks,
branka

I do not know what script you are running to execute against the file but
here is mine.

In the Workflow properties of the datapump task I have "Close Connection On
Completion" set.

Here is my script


Function Main()

DIM fso
DIM tStream
DIM strOutput


SET fso = CREATEOBJECT("Scripting.FileSystemObject")

IF fso.FileExists("c:\DelMeAfterThis.txt") THEN
Msgbox "File Exists"
SET tStream = fso.OpenTextFile("c:\DelMeAfterThis.txt",1)
msgbox "File open"
strOutput = tStream.ReadLine
msgbox strOutput
ELSE
Msgbox "File Not There"
END IF


Main = DTSTaskExecResult_Success
End Function

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"branka" <B (AT) nomail (DOT) com> wrote

Thank you tons! You made my day.

I wasn't clositng the connection (had no clue i had to do
that).

Branka