May 8, 2006 at 3:14 am
Hi,
Is there any option to delete DTS Package using VB Application?
Thanks in advance
Sajan
May 8, 2006 at 9:01 am
Sajan,
You could look at sp_drop_dtspackage in msdb. Remember that only the package owner or a member of sysadmin can drop a package.
Greg
Greg
May 9, 2006 at 6:17 am
Greg,
Thanks for your reply, But I have some doubts. please help me to clarify these things
Am creating the DTS package through a VB Application using the Structured Storage File. Am giving this program to clients. I have no access to their machine. So how can I get the Unique Id and Version Id of that DTS Package? With out that I can't use the sp_drop_dtspackage.
Regards,
Sajan
May 9, 2006 at 9:24 am
If the package will reside on the client's machine that you can't access, I can't think how you will be able to find the package let alone delete it.
Greg
Greg
May 9, 2006 at 10:50 pm
Gerg,
Thanks for your response
Regards,
Sajan
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply