HI,

   I want to execute a package in ssis from sql server.Instead of using SQL SERVER AGENT  UI ,i need  script.

I can execute the package only through command prompt by using the command DTEXEC /f <package path>...

How can i execute a package by using script or any code or any t-sql commands..explain in detail about how to implement this..

Which version of SSIS are you on?

If its 2012 its possible to directly create an execution in SSIS catalog using system procedures

see

http://thinknook.com/execute-ssis-via-stored-procedure-ssis-2012-2012-08-13/

I AM using 2012.

I GOT AN ERROR

Msg 27123, Level 16, State 1, Procedure create_execution, Line 38
The operation cannot be started by an account that uses SQL Server Authentication. Start the operation with an account that uses Windows Authentication.

What will i do?I am accessing my manager's server

IS THERE ANY ANOTHER WAY TO EXECUTE A PACKAGE WITH OUT USING THIS SSISDB

Hi sachin,

According to your description, it seems that you want to execute a package stored in the file system by using T-SQL commands and without using SSISDB in SQL Server.

To achieve your requirement, we can enable xp_cmdshell extended stored procedure, and using it you can execute DTEXEC utility to execute your SSIS package. The following command is for your reference:
EXEC xp_cmdshell 'dtexec /f "C:\UpsertData.dtsx"'

References:
Executing a SSIS Package from Stored Procedure in SQL Server
dtexec Utility

Thanks,
Katherine Xiong