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.
| Author |
Topic |
|
adityavasisthh
Starting Member
1 Post |
 Posted - 2009-06-11 : 05:10:13
|
| Hi,The SQl Server 2008 provides apis to load, execute a package but does not seems to provide the apis to execute a single task within that package. I am looking for some apis via which I would be able to execute a specified task within a package. I need this so as to unit test a task within a package. Without such apis I would have to use the test hooks before and after each task and for some reasons I cannot go with that way. So are there any apis via which I would be able to execute a specified task within a package?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-06-14 : 04:33:14
|
| you can always open the package using sql business intelligence studio and then see as well as test the individual tasks inside the package and execute one task alone by right clicking on it and then selecting execute task. |
 |
|
|
|
|
|
Executing a single task of a package