I am using SQL Server 2005 on a Windows XP (sp2) PC. Whenever I run a DTS
Package that has an ActiveX Script Task in it, which contains the line

Set fso = CreateObject("scripting.
filesystemobject")

I get the following error:

ActiveX Component can't create object:'scripting.
filesystemobject'

I can run the DTS from inside a SQL Server Agent and I can run the DTS
Package from someone else's PC. I have also tried running the DTS Script
Task Step while logged in as Administrator on my PC and it still doesn't work.


Any ideas?