Scheduling SSIS package as a Job

Question

Post reply

Scheduling SSIS package as a Job

SQLBuddy123

One Orange Chip

Points: 28294
More actions
July 13, 2009 at 3:52 pm

#134254

Hi,
Could any one tell me how to schedule a SSIS package as a SQL Server Agent job on a 64 bit Windows machine with 64 Bit SQL Server installed?
Thank You,
Yours
SQL Buddy.

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

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

Jayakumar Krishnan SSCarpal Tunnel Points: 4710 More actions · Answer 1

Check this link.

http://www.mssqltips.com/tip.asp?tip=1180

Thanks
Jay
http://www.sqldbops.com

Ghanta Hall of Fame Points: 3999 More actions · Answer 2

Exec Xp_cmdshell 'dtexec /sq pkgOne /ser productionServer'

Search for dtexec in help for more info.

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

Hi JayaKumar,

Thank you very much for your reply.

But the issue is even more complex than what the article says on a 64-bit machine.

Yours

SQLBuddy.

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

Hi Ghanta,

Thanks a lot for your reply.

I think xp_cmdshell is to execute the SSIS pkg through a stored procedure and I am not using any stored procedure to execute the SSIS packages as part of a job.

Yours

SQLBuddy.