Script Task error in SSIS - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Script Task error in SSIS

Author

Topic

sanjnep
Posting Yak Master

191 Posts

Posted - 2007-09-13 : 11:48:05

I am trying to create File System Object on Script Task (VB.Net) in SSIS.

Dim fs As New Scripting.FileSystemObject

but I am getting error
Type 'Scripting.FileSystemObject' is not defined.

Do I need to add any reference or add file to work Scripting.FileSystemObject object correctly? If yes how and which dll should I add?
Thanks
Sanjeev

sanjnep
Posting Yak Master

191 Posts

Posted - 2007-09-13 : 12:01:09

Any idea please?

nr
SQLTeam MVY

12543 Posts

Posted - 2007-09-13 : 18:50:23

try
dim fs
set fs = createobject("Scripting.FileSystemObject")

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources