using System;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime;
using System.Windows.Forms;
using System.Data.OleDb;
using System.IO;
using System.Runtime;

namespace ST_52bc4feca08c4987967f59f239d33e4a.csproj
{
    [System.AddIn.AddIn("ScriptMain", Version = "1.0", Publisher = "", Description = "")]
    public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase
    {

        #region VSTA generated code
        enum ScriptResults
        {
            Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success,
            Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure
        };
        #endregion

        public void Main()
        {
            DataTable dt;
            String sheetName;
            Dts.Connections["Sales"].AcquireConnection(null);
            String connString = Dts.Connections["Sales"].ConnectionString;
            Dts.Connections["Sales"].Dispose();
            OleDbConnection excelConn = new OleDbConnection(connString);

            excelConn.ConnectionString = connString;
            excelConn.Open();

            dt = excelConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

            sheetName = dt.Rows[ 0 ]["TABLE_NAME"].ToString();

            Dts.Variables["SheetName"].Value = sheetName;


            //dt = null;
            dt.Clear();
            dt.Dispose();
            excelConn.Dispose();
            excelConn.Close();
            //excelConn = null;


            Dts.TaskResult = (int)ScriptResults.Success;
            
        }
    }
}