Can we schedule SSIS packages using SQL Agent on a server where SSIS is not installed

Question

Can we schedule SSIS packages using SQL Agent on a server where SSIS is not installed

sree-879715

SSCommitted

Points: 1794
More actions
August 10, 2010 at 11:54 am

#387546

Hi,
Is there a way to create a package on the server where I have SSIS installed and export it to another server where we dont have SSIS and schedule there to run ?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Baskar B.V SSCrazy Points: 2823 More actions · Answer 1

sree-879715 (8/10/2010)
Hi,
Is there a way to create a package on the server where I have SSIS installed and export it to another server where we dont have SSIS and schedule there to run ?

You can export it to file system in another server and it does not make any difference since it is just a file.

For scheduling, i hope you can't use SQL Agent to schedule it but if you are using some other schedulers like ctrl-m or Argent you can schedule it but the node from which SSIS would get executed should be a different server where SSIS is installed.

[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

Adiga One Orange Chip Points: 27284 More actions · Answer 2

No. You need to have SSIS installed to run it as a job.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

sree-879715 SSCommitted Points: 1794 More actions · Answer 3

Thank you for the replies.

I tried to export the package to another server and created a job to run this package but I am getting this error message :

Executed as user: <SEVERNAME>\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:59:44 PM Error: 2010-08-10 13:59:52.67 Code: 0xC00470FE Source: Data Flow Task DTS.Pipeline Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Destination - AuditHeader_txt" (55). End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:59:44 PM Finished: 1:59:52 PM Elapsed: 7.984 seconds. The package execution failed. The step failed.

We don't use control-M on these servers so I need to use SQL Agent to run this package. Is there any way other then installing SSIS ???

Adiga One Orange Chip Points: 27284 More actions · Answer 4

You may find these links useful.

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/289d0bbb-1d06-4856-9c66-8d3e540d7be9/

https://connect.microsoft.com/SQLServer/feedback/details/217596/ssis-error-the-product-level-is-insufficient-for-component-w-enterprise-edition?wa=wsignin1.0

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Phil Parkin SSC Guru Points: 246963 More actions · Answer 5

We don't use control-M on these servers so I need to use SQL Agent to run this package. Is there any way other then installing SSIS ?

Not that I know of.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin