Thanks thats I want.

http://blog.sqlauthority.com/2011/05/23/sql-server-running-ssis-package-in-scheduled-job/

Yes I am able to see it in windows explorer

From which Explorer ??

It is saved in file system.

Ok leave it.

My main issue is "to run a batch file from trigger" any solution is there?

The package is not visble when connecting using the database engine.

I want to add this package in a job.

How can I do this...

Why this package is not showing in File system in ssms(Integartion services).

Hi,

Thanks,

Now My package is not showing in Management studio when I am selecting 'Integration sevices' option from connection windpw.

This can be possible but i my actual scenario I have to call the batch file from a trigger.

Therefore I am trying it using SSMS first.

It has full control...as I am the local server admin of the db server and file is created in c:\users\dbadmin\te.bat

and I have checked the security tab also. full permissions...

Actually I am using Execute Process Task in Control Flow.

Yes it has enabled from sp_configure and changed to value 1.

Hi,

Thanks,

I am using XP_CMDSHELL.

On running: Exec XP_CMDSHELL 'c:\te.bat';

It continuosly goes to executing query state.

I have stop the sql server agent and then remove the table from articles.

Do the changes and add the table into articles and reinitialize all subscriptions Successfully..

I have shared it with everyone full permission.