> Hi,
>
> New to SSIS... I have created many dts packages in sql server 2000,
> but am having a tough time understanding SSIS...
>
> I know I need to do some learning... what is the best resource book ?
>
> I know people are going to tell me to use dot net code as opposed to
> vbscript when I ask my questions below, well, in the near future I
> will, but for now...
>
> I have several dts packages that are simply vbscripts that I want to
> execute as jobs from SQL server 2005
>
> 1. I was able to create a package be dropping an Active X script Task
> onto the Control Flow tab of a new integration package. I added the
> script code to this task. I noticed that MS does not even support
> the mouse button options to copy and past code into the script box
> (yet another hint to get with the dot net program).
>
> 2. Every time I close the ActiveX Script Task editor, it runs the
> task. How can I stop this ?
>
> 3. I saved the project as Integration Project 1, how can I schedule it
> ? I cannot seem to "see" it from SQL server 2005.
>
> Thanks !
>