October 5, 2007 at 2:56 am
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
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
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
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