Run SQL SISS package sql 2012

Hi,

I am trying to execute an SISS package that I have stored on the server from a stored procedure using the following ;

EXEC msdb.dbo.sp_start_job @job_name = 'AvantixImport'

but I get the message The specified @job_name ('AvantixImport') does not exist.

I can see the job listed under Integration Services / Stored Packages / MSDB but cannot run it. Any ideas please ?

Thanks
RichardSmeeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
x-menConnect With a Mentor IT super heroCommented:
create a SQL Agent job, that runs the SSIS package in 32bit mode.

execute the SQL Agent Job.
0
 
x-menIT super heroCommented:
Job is not Package. You need to create a Job that runs the SSIS package
0
 
Alpesh PatelAssistant ConsultantCommented:
Did you saved the package in Integration catalog or in SQL server?

Integration catalog is new feature of SQL server 2012.


http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_10949-Integration-Service-Catalog-in-SSIS-2012.html
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
RichardSmeeAuthor Commented:
Hi sorry not understanding your comments. I have a stored package under /integration services / stored packages / msdb and now (after some potching) I also have it under integration services catalogs / SISSDB, neither of which I seem able to execute from transact SQL.
0
 
x-menIT super heroCommented:
can you execute it with DTEXEC ?
0
 
RichardSmeeAuthor Commented:
Yes but only after ;

-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- To enable the feature.
EXEC sp_configure 'xp_cmdshell', 1
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO

to allow you to run cmdshell and then


EXEC xp_cmdshell 'C:\"Program Files (x86)\Microsoft SQL Server"\110\DTS\Binn\DTExec /f "C:\revenueimport\import avantix.dtsx"'

to run the package in 32 mode because it's from an excel spreadsheet.

This Soooooooo grim. Is there a way of running a package stored within SQL on the SQL server without resorting to running it on a command shell and lowering the security - without upgrading to SQL 2005 that is (sarcasm).

Thanks for your patience this is just getting stupidly complicated for such a simple thing.
0
 
RichardSmeeAuthor Commented:
Yep that worked. Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.