SQL Server Agent

Question

Post reply

SQL Server Agent

SQLBuddy123

One Orange Chip

Points: 28294
More actions
September 2, 2009 at 3:06 pm

#141344

Hi,
Could anyone help me with this?
We know that SSIS service is not required to execute the SSIS packages.
Suppose we deploy SSIS packages on to SQL Server A with no SSIS service. And, if we schedule those SSIS packages to be executed using SQL Server Agent, how are they going to be executed? How does SQL Server agent execute those SSIS packages?
Thank You,
Yours,
SQLBuddy

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

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

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 1

Hi,

Could anyone help me with this?

We know that SSIS service is not required to execute the SSIS packages.

Suppose we deploy SSIS packages on to SQL Server A with no SSIS service. And, if we schedule those SSIS packages to be executed using SQL Server Agent, how are they going to be executed? How does SQL Server agent execute those SSIS packages?

ANY HELP PLEASE!

Thank You,

Yours,

SQLBuddy

Silverfox SSC-Insane Points: 23150 More actions · Answer 2

sqlbuddy123 (9/3/2009)
Hi,
Could anyone help me with this?
We know that SSIS service is not required to execute the SSIS packages.
Suppose we deploy SSIS packages on to SQL Server A with no SSIS service. And, if we schedule those SSIS packages to be executed using SQL Server Agent, how are they going to be executed? How does SQL Server agent execute those SSIS packages?
ANY HELP PLEASE!
Thank You,
Yours,
SQLBuddy

Not sure I understand what the issue is, if you create a job, and specify the type as 'sql server integration services package', you can fill in all the details there to run it. Just because SSIS service is not running, you can still execute SSIS packages. as far as i know, if you create the job and then script it out. you will be see the syntax. remember that maintenance plans are also SSIS packages.

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 3

Hi Silver,

Thank you very much for your reply.

Actually this is not an issue which I got. I know that we can execute SSIS packages using SQL Server agent jobs even without having ssis and I am able able to do that.

But I just wanted to know how an ssis package is executed by the SQL Server Agent Job . I couldn't understand what actually happens behind the scenes when the job is being executed like what tool is being used to execute that package like dtexecui, dtexec.exe etc.. I know that all these utilities are independent of each other. Just I couldn't contemplate. To me it's as clear as mud.

Thank You,

Yours

SQL Buddy.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

If you script out the job, you should be able to see the command that is used to run it.

dtexecui is GUI based and dtexec is cmd line based.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 5

Hi Jason,

Thank you very much. Now I understood the strategy. I really appreciate your help.

Yours

SQLBuddy.