April 04, 2012

SQL Saturday preparation

Today I started to get some ideas about my presentation in SQL Saturday.
First I will be creating a simple package :

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace LibSQLSaturday
{
    /* Demostration of an Empty SSIS Package */
    public class Demo1
    {
        private Package myPackage;
        private  String FullFilePath;
       

        public Demo1()
        {
           myPackage = new Package();
        }
        public void SavePackage()
        {
            Application app = new Application();
            app.SaveToXml(FullFilePath+"\\"+myPackage.Name.ToString ()+".dtsx",myPackage, null);
       }
    public string Name
    {
        get { return myPackage.Name.ToString (); }
        set { myPackage.Name = value; }
    }
        public String SetFilePath
        {
            set {FullFilePath = value;}
            get { return FullFilePath; }
        }
   }
}
And then continue to add up to it ...So, kind of like Demo1,2,3,etc as a progression and adding components to it.

No comments:

Post a Comment

Contact Form

Name

Email *

Message *