Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 sql server job schedule error

Author  Topic 

kond.mohan
Posting Yak Master

213 Posts

Posted - 2011-11-14 : 06:00:56

i have to run job with ssis pkg i just created new job in sql server 2005 and create the only one step
----step name :first step
----type : sql server integration services
-----run as : sql agent service
----pkg source : file system
----pkg path :c:\users ........(location of ssis package)
i receive these error

THE SPECIFIED '@SUBSYSTEM' IS INVALID
( Microsoft sql server error :14234)


pls provide direction



mohan

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2011-11-14 : 06:21:14
Did you install Integration Services on the SQL Server machine?
Go to Top of Page

kond.mohan
Posting Yak Master

213 Posts

Posted - 2011-11-14 : 06:23:05
I WORKED ON VS2005(BIDS) SSIS,SSRS,SSAS INSTALLED

mohan
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2011-11-14 : 11:34:48
Not Visual Studio, please open SSMS and try to connect to Integration Services, can you connect?
Go to Top of Page
   

- Advertisement -