Hello,

I have seen examples of executing DTS packages in ASP or VB applications, which there are examples at:

http://www.sqldts.com/default.aspx?207
http://www.sqldts.com/default.aspx?208

Can you execute a DTS package in .NET, and in what namespace are the objects to do this in?

Thanks,

Brian Mains

__________________
Brian

Visual C#

using System;
using System.Runtime.InteropServices;
using DTS;

namespace DTS
{
    /// <summary>
    /// Summary description for ExecPkg.
    /// </summary>
    class ExecPkg
    {
        [MTAThread]
        static void Main(string[] args)
        {
            try
            {
                Package2Class package = new Package2Class();
                object pVarPersistStgOfHost = null;

                /* if you need to load from file
                package.LoadFromStorageFile(
                    "c:\\TestPackage.dts",
                    null,
                    null,
                    null,
                    "Test Package",
                    ref pVarPersistStgOfHost);
                */

                package.LoadFromSQLServer(
                    "(local)\\dev",
                    null,
                    null,
                    DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedC onnection,
                    null,
                    null,
                    null,
                    "Hello DTS",
                    ref pVarPersistStgOfHost);

                package.Execute();
                package.UnInitialize();

                                // force Release() on COM object
                //
                System.Runtime.InteropServices.Marshal.ReleaseComO bject(package);
                package = null;
            }
            catch(System.Runtime.InteropServices.COMException e)
            {
                Console.WriteLine("COMException {0}", e.ErrorCode.ToString() );
                Console.WriteLine("{0}", e.Message);
                Console.WriteLine("{0}", e.Source);
                Console.WriteLine("Stack dump\n{0}\n", e.StackTrace);
            }
            catch(System.Exception e)
            {
                Console.WriteLine("Exception");
                Console.WriteLine("{0}", e.Message);
                Console.WriteLine("{0}", e.Source);
                Console.WriteLine("Stack dump\n{0}\n", e.StackTrace);
            }
       } // main
    } // class ExecPkg
} // namespace DTS

hiroki wu

The code above though still uses the DTS.Package VB6 class, as denoted by the ReleaseCOMObject method. I was wondering if there was a .NET library that could invoke this, but I guess there isn't.

Thanks for your assistance.