Installing a SSIS package. Slightly confused
Ok - this is probably a silly question but what the hell.
I've created a SSIS package with configuration and a deployment manifest. When I copied this over to the server and double clicked it, the Package Wizard returned an error - that Integration Services wasn't installed - bad.
But when I did an export data task via SSMS, I noticed I could save this task as a package. When I set up a job I noticed I could actually select an SSIS package to schedule - even though SSIS is not installed(!?!) Does this mean I could just point to my earlier package and schedule that?
If so, do you only need Integration Services installed in order to install packages w开发者_StackOverflowithin SQL Server - its fine to run them from the file system?
Cheers
Here is a good article on different ways to execute a package programmatically: http://blogs.msdn.com/b/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx
精彩评论