Post reply

How to run ssis package by sql query without using dtexec and xp_cmdshell commands

  • October 5, 2007 at 2:56 am

    #120638

    hi ,

    i run dts package by using these following methods in store procedure ---

    sp_OACreate 'DTS.Package' --- create object

    sp_OAMethod --- loads the dts package

    sp_OASetProperty --- set package property

    sp_OAMethod --- Executes package

    sp_OADestroy --- Destroy package

    BUT , now in sql server 2005, dts are replace by ssis packages..

    i have made a simple ssis package i wanted it to run in store procedure without using dtexec and xp_cmdshell commands .:exclamationmark:

    hope these task will be an interesting one ................

    thks in advances

  • October 5, 2007 at 3:14 am

    #739439

    Hi,

    Check this link: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=61765&SiteID=1. Hope you find your answer here...

  • October 5, 2007 at 10:21 am

    #739626

    its not working,

    but it is returning sucessfull value 0.

    i.e dtsx is execute or not no idea

  • October 19, 2007 at 8:59 am

    #743660

    ITs NOT working friend , hav u tried it

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply