I've never done this before. I currently have a .vbs file I'd like to run at the end of a SSIS package. Do I just drag an ActiveX Script Task onto the IDE and point to it?

Here's what I've tried:

1. dragged an ActiveX Script Task onto the IDE

2. in the 'Script' line I used the Browse button to put my file into the 'Script' line. The actual code now appears on the 'Script' line.

3. I am getting a red X error on my ActiveX Script Task: 'Function not found.'

Am I missing something here?

Oh and btw, hopefully I will be getting the rights to Database Mail and SSRS and I won't have to do things like this in the near future.