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 2005 Forums
 SSIS and Import/Export (2005)
 Change Startup Task

Author  Topic 

rosgood52
Starting Member

5 Posts

Posted - 2008-12-23 : 15:03:31
Ok.... This should be easy but....

I have a package that has multiple Script tasks in it. I have modified it to add a new script task. I want the execution of the package to start with my new script task but cannot see where to force this to happen. Please point me in the right direction.

thanks

basicconfiguration
Constraint Violating Yak Guru

358 Posts

Posted - 2008-12-23 : 15:21:14
right click the package and "set as startup package".
Go to Top of Page

rosgood52
Starting Member

5 Posts

Posted - 2008-12-23 : 15:24:53
Did you mean "Set as StartUp Object"? That's the only choice when right-clicking the package in Solution Explorer.
Go to Top of Page

rgombina
Constraint Violating Yak Guru

319 Posts

Posted - 2008-12-23 : 15:47:12
You mean have one Script Task as starting/execution point?
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-12-23 : 15:51:36
Didn't get that.
Many Tasks in one package.
So what is the problem here?
Drag new task to a pole position and then the workflow arrow to the task that was previously the starting task.

Webfred


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

rosgood52
Starting Member

5 Posts

Posted - 2008-12-23 : 15:53:17
Yep. You would think that would work but it does not. The task that incorrectly starts is the last one in the chain. Driving me nuts
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-12-23 : 16:01:24
I've never heard of this behavior before.
I always did it in the way I've posted and it works fine.
curious ...

Webfred


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -