jobs
3/21/2007 8:02:00 PM
Perhaps the wrong group, but figured many of you have played with SSIS/
DTS
I'm trying to read a file into a string.. this code has worked in
vb.net/asp.net.. but won't an ssis script task.
Imports system.io
...
Dim FILENAME as String = Server.MapPath("readme.txt")
Dim objStreamReader as StreamReader
objStreamReader = File.OpenText(FILENAME)
Dim contents as String = objStreamReader.ReadToEnd()
chat.text=contents
objStreamReader.Close()
I'm trying the same code in an ssis script task, and double checked
that I have system.io as a reference as well, but get compile error:
Name "Server" is not declared.
If I remove the mappath and try to open the string, I get :
The given path's format is not supported.
Thanks for any help or information!