开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜