Hi,

Well the issue I ran into was, I used EncryptSensitiveDataWithPassword option in my Package so I could not provide the password after \DECRYPT switch while using the type - SSIS.

Guys,

Finally my Web service is working now. I can execute the package and get the status of the sql job as well.

Thanks all for your help.

Hi all,

I finally ended up using the command line option of the SQL Job.

i.e Job Setup Properties -> General -> Type (Operating System (CmdExec)) -> Command line ->

DTExec.exe \FILE "package.dtsx"...

Thanks Greg,

Will try that..

Hi Guys,

I have been trying to execute the stored procedure which in turn calls

Exec msdb.dbo.sp_start_job @jobname

If I run this sp using windows authentication, it works

if I run it using SQL...

Thanks Greg,

I figured that would be the best option. I am currently working that route, I will keep you guys posted as how it goes..