Dear all, How do I to launch a SSIS package from either VB 6.0 or VB .Net languages? Anyone told me that from SMO library you can launch but I haven't idea how would I do too.. Thanks in advance for any input or though, Enric

Lookup "Loading and Running Packages Programmatically" in Books Online (http://msdn2.microsoft.com/en-us/library/ms345155.aspx). You use the Microsoft.SqlServer.Dts.Runtime namespace not SMO. This will certainly work from VB.Net, and in theory it should work from VB6 if there is a PIA (don't know that there is), or just create your own CCW. Never tried, so it may not work, there are some requirements around creating CCW's.

Hi Darren, What does PIA and CCW's mean? What else I need for instantiate SMO model from Vb 6.0?? thanks a lot for any input

PIA - Primary Interop Assembly, but ignore me on that, got myself the wrong way round. A CCW is a COM Callable Wrapper. You create a wrapper around your managed assembly to allow it to be called from COM. These can be auto-generated, I forget the tool now, try searching MSDN. A better way would be to write a wrapper class in managed code and just expose some simple members. Use this to create the CCW as it will probably be cleaner and easier to use. Better stilll upgrade for this bit of work. You do not want SMO though, not for SSIS work.

Thanks for the info. I think that I'll do my best trying with Vb .net and leaving once for all vb 6 and that stuff..

raf Thanks.