C# Application.LoadFromSqlServer方法代码示例

        protected override Package Load(IEtl etl, Application app)
        {
            var server = etl.Server.Replace(" ", "");
            if(server.ToLower()=="(local)")
                server=".";

            var packageName = etl.Path + etl.Name;
            if (!packageName.ToLower().EndsWith(".dtsx"))
                packageName += ".dtsx";

            var events = new PackageEvents();
            var package = app.LoadFromSqlServer(packageName, server, etl.UserName, etl.Password, events);
            return package;
        }

    protected void btnBulkCopy_Click(object sender, EventArgs e)
    {
        try
        {

            Package pkg;
            Application app;
            DTSExecResult pkgResults;

            MyEventListener eventListener = new MyEventListener();

            //pkgLocation = "D:\\dts\\TestDataPKG.dtsx";
            app = new Application();

            //Load Package from File system.
            //pkg = app.LoadPackage(pkgLocation, eventListener);
            //app.SaveToXml("D:\\test.xml", pkg, eventListener);

            //pkgResults = pkg.Validate(null, null, null, null);
            //pkgResults = pkg.Execute(null, null, eventListener, null, null);

            string pkgName = String.Empty;
            string sqlServer = String.Empty;
            string userID = String.Empty;
            string pwd = String.Empty;

            pkgName = ConfigurationManager.AppSettings["PackageName"];    // Give the Name of the DTS Package in SQL Server.
            sqlServer = ConfigurationManager.AppSettings["ServerName"];  // Name of the SQL Server.
            userID = ConfigurationManager.AppSettings["UserName"];      // Sql Server User ID.
            pwd = ConfigurationManager.AppSettings["Password"];        // Sql Server Password.

            //Load Package from sql server.
            pkg = app.LoadFromSqlServer(pkgName, sqlServer, userID, pwd, eventListener);
            pkgResults = pkg.Execute(null, null, eventListener, null, null);

            lblResult.Text = "DTS Package Executed Successfully...";
            btnBulkCopy.Visible = false;
            btnImportData.Visible = true;
        }
        catch (Exception ex)
        {
            lblResult.Text = "Exception: " + ex.Message;
        }
    }

        private static IEnumerable<PackageDescriptor> LoadSqlPackages(IContext context, ProgressRecord progressRecord, Application application, string serverName, string path)
        {
            progressRecord.CurrentOperation = "Processing SQL path " + path + "...";
            context.WriteProgress(progressRecord);

            var packageInfos = application.GetPackageInfos(path, serverName, null, null);
            var packageItems = packageInfos.Cast<PackageInfo>();
            var folders = from p in packageItems
                          where p.Flags == DTSPackageInfoFlags.Folder
                          select p;
            packageItems = from p in packageItems
                           where p.Flags == DTSPackageInfoFlags.Package
                           select p;
            var packages = packageItems.ToList()
                                       .ConvertAll(
                                           p =>application.LoadFromSqlServer(p.Folder + "\\" + p.Name, serverName, null, null, null)
                                       )
                                       .ConvertAll(p => new PackageDescriptor(p, path))
                                       .ToList();

            if (folders.Any())
            {
                var children = folders.ToList()
                    .ConvertAll(f => LoadSqlPackages(context, progressRecord, application, serverName, f.Folder + "\\" + f.Name));

                children.ForEach(packages.AddRange);
            }

            return packages;
        }