Tuesday, May 28, 2013

Run time SSIS

Refer :http://www.selectsifiso.net/?p=82
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138216

This sample creates a data flow package with an OleDB Source component which reads from a local AdventureWorksDW2008 database, and writes to a different table in the same database using an OleDB Destination.
Items of interest:
  • The AccessMode property is an int value which controls how you’re retrieving/sending data. Once you set a value, you need to set a value for the related property (see the table below). For example, if you set the AccessMode for the OLEDB Source to 2 (SQL Command), you should set a SQL statement value for the SqlCommand property.
OLEDB Source
ValueTextRelated PropertyDescription
0Open RowsetOpenRowsetYou provide the name of a table or view.
1Open Rowset from VariableOpenRowsetVariableYou provide the name of a variable that contains the name of a table or view.
2SQL CommandSqlCommand
You provide a SQL statement.
3SQL Command from VariableSqlCommandVariableYou provide the name of a variable that contains the SQL statement you wish to execute.
OLEDB Destination
ValueTextRelated PropertyDescription
0Open RowsetOpenRowset
You provide the name of a table or view.
1Open Rowset from VariableOpenRowsetVariableYou provide the name of a variable that contains the name of a table or view.
2SQL CommandSqlCommand
You provide a SQL statement.
3Open Rowset Using FastloadOpenRowsetYou provide the name of a table or view.
4Open Rowset Using Fastload from VariableOpenRowsetVariable
You provide the name of a variable that contains the name of a table or view.
  • Calling ReinitializeMetadata() causes the component to fetch the table metadata. This should only be called after setting the AccessMode and related property.


Code to do the Task.
---------------------------------------------------------------------------------------------------------


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
using Microsoft.SqlServer.Dts.Pipeline.Wrapper;



namespace DataFlow_Task_Program
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create a package
            Package package = new Package();
           
            // Add a Executable data flow task
            Executable dataFlowTask = package.Executables.Add("STOCK:PipelineTask");
           
            // Setting the name of the data flow task
            TaskHost taskHost = dataFlowTask as TaskHost;
            taskHost.Name = "Data Flow Task";

            // Reference to the InnerObject to add items to the data flow
            MainPipe pipeline = taskHost.InnerObject as MainPipe;


            IDTSComponentMetaData100 srcComponent = pipeline.ComponentMetaDataCollection.New();
            IDTSComponentMetaData100 destComponent = pipeline.ComponentMetaDataCollection.New();
            ConnectionManager connection = package.Connections.Add("OLEDB");
            IDTSDesigntimeComponent100 destDesignTimeComponent = destComponent.Instantiate();



            // Connection Managers
            #region Section for adding Connection Managers
            try
            {

                // ConnectionManager connection = package.Connections.Add("OLEDB");
                connection.Name = "localhost";
                connection.ConnectionString = "Data Source=localhost;Initial Catalog=TestDb;Integrated Security=True";
            }
            catch { }

            #endregion
        

            // OLEDB Source Connection Manager
            #region Section for Adding an OLEDB Source
            // Source for OLEDB Connection
            try
            {
               // IDTSComponentMetaData100 srcComponent = pipeline.ComponentMetaDataCollection.New();
                srcComponent.ComponentClassID = "DTSAdapter.OleDbSource";
                srcComponent.ValidateExternalMetadata = true;
                IDTSDesigntimeComponent100 srcDesignTimeComponent = srcComponent.Instantiate();
                srcDesignTimeComponent.ProvideComponentProperties();
                srcComponent.Name = "OleDb Source";

                // Configuring  it to read from the given table
                srcDesignTimeComponent.SetComponentProperty("AccessMode", 0);
                srcDesignTimeComponent.SetComponentProperty("OpenRowset", "[Test1]");

                // Setting the connection manager
                srcComponent.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.GetExtendedInterface(connection);
                srcComponent.RuntimeConnectionCollection[0].ConnectionManagerID = connection.ID;

                // Retrieveing the column metadata
                srcDesignTimeComponent.AcquireConnections(null);
                srcDesignTimeComponent.ReinitializeMetaData();
                srcDesignTimeComponent.ReleaseConnections();
            }
            catch { }
            #endregion

            //OLEDB Destination Connection Manager
            #region Section for Adding OLEDB Destination
            try
            {

                //IDTSComponentMetaData100 destComponent = pipeline.ComponentMetaDataCollection.New();
                destComponent.ComponentClassID = "DTSAdapter.OleDbDestination";
                destComponent.ValidateExternalMetadata = true;

                //IDTSDesigntimeComponent100 destDesignTimeComponent = destComponent.Instantiate();
                destDesignTimeComponent.ProvideComponentProperties();
                destComponent.Name = "OleDb Destination";

                destDesignTimeComponent.SetComponentProperty("AccessMode", 3);
                destDesignTimeComponent.SetComponentProperty("OpenRowset", "[Test2]");

                // Setting the connection
                destComponent.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.GetExtendedInterface(connection);
                destComponent.RuntimeConnectionCollection[0].ConnectionManagerID = connection.ID;

                // Geting metadata
                destDesignTimeComponent.AcquireConnections(null);
                destDesignTimeComponent.ReinitializeMetaData();
                destDesignTimeComponent.ReleaseConnections();
            }
            catch { }
            #endregion


            // Connecting the source and Destination OLEDB Connetction
            try
            {
                IDTSPath100 path = pipeline.PathCollection.New();
                path.AttachPathAndPropagateNotifications(srcComponent.OutputCollection[0], destComponent.InputCollection[0]);

                // Configuring the Destination

                IDTSInput100 destInput = destComponent.InputCollection[0];
                IDTSVirtualInput100 destVirInput = destInput.GetVirtualInput();
                IDTSInputColumnCollection100 destInputCols = destInput.InputColumnCollection;
                IDTSExternalMetadataColumnCollection100 destExtCols = destInput.ExternalMetadataColumnCollection;
                IDTSOutputColumnCollection100 sourceColumns = srcComponent.OutputCollection[0].OutputColumnCollection;

                // The OLEDB destination requires you to hook up the external columns
                foreach (IDTSOutputColumn100 outputCol in sourceColumns)
                {
                    // Get the external column id
                    IDTSExternalMetadataColumn100 extCol = (IDTSExternalMetadataColumn100)destExtCols[outputCol.Name];
                    if (extCol != null)
                    {
                        // Create an input column from an output col of previous component.
                        destVirInput.SetUsageType(outputCol.ID, DTSUsageType.UT_READONLY);
                        IDTSInputColumn100 inputCol = destInputCols.GetInputColumnByLineageID(outputCol.ID);
                        if (inputCol != null)
                        {
                            // map the input column with an external metadata column
                            destDesignTimeComponent.MapInputColumn(destInput.ID, inputCol.ID, extCol.ID);
                        }
                    }
                }
            }
            catch { }


        }
    }
}




Create SSIS Package with SQL Tasks using C#


 private void button2_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                Microsoft.SqlServer.Dts.Runtime.Application SIFISO_app = new Microsoft.SqlServer.Dts.Runtime.Application();


                //Adding Connection Manger
                Package package = new Package();
                ConnectionManager ConMgr = package.Connections.Add("OLEDB");
                ConMgr.ConnectionString = "Provider=SQLOLEDB.1;" +
                "Integrated Security=SSPI;Initial Catalog=Tracker;" +
                "Data Source=S4UAGP-PC\\ASHOKINSTANCE;";
                ConMgr.Name = "SourceConnectionOLEDB";
                ConMgr.Description = "OLE DB connection to the AdventureWorks2008R2 database.";
               

               
                Executable e1 = package.Executables.Add("STOCK:PipelineTask");
                TaskHost thMainPipe = e1 as TaskHost;
                thMainPipe.Name = "Data Flow Task 1";
                //thMainPipe.Properties["Connection"].SetValue(thMainPipe, "SourceConnectionOLEDB");
                MainPipe dataFlowTask = thMainPipe.InnerObject as MainPipe;

               // string Conn = "Data Source=S4UAGP-PC\\ASHOKINSTANCE;Initial Catalog=MMBD;Integrated Security=True";
                // Create the source component.  


                ///Adding Source
                ///
                IDTSComponentMetaData100 srcComponent =   dataFlowTask.ComponentMetaDataCollection.New();
                srcComponent.ComponentClassID = "DTSAdapter.OleDbSource";
                CManagedComponentWrapper srcDesignTime = srcComponent.Instantiate();
                srcComponent.Name = "Source - MMBD_LN_MSTR1";
                srcComponent.Description = "OLE DB Source";
                IDTSDesigntimeComponent100 srcDesignTimeComponent = srcComponent.Instantiate();
                srcDesignTimeComponent.ProvideComponentProperties();

                // Configuring  it to read from the given table
                //srcDesignTimeComponent.SetComponentProperty("AccessMode", 2);
                //srcDesignTimeComponent.SetComponentProperty("SqlCommand", "SELECT  * FROM   [MMBD_LN_MSTR]");

                srcDesignTimeComponent.SetComponentProperty("AccessMode", 0);
                srcDesignTimeComponent.SetComponentProperty("OpenRowset", "[dbo].[MMBD_LN_MSTR1]");

                // Setting the connection manager
                srcComponent.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.GetExtendedInterface(ConMgr);
                srcComponent.RuntimeConnectionCollection[0].ConnectionManagerID = ConMgr.ID;
                srcDesignTime.AcquireConnections(null);
                srcDesignTime.ReinitializeMetaData();

               

                //Adding Data Conversion

                IDTSComponentMetaData100 dataConvertComponent = dataFlowTask.ComponentMetaDataCollection.New();
                dataConvertComponent.ComponentClassID = "DTSTransform.DataConvert";
                dataConvertComponent.Name = "Data Convert";
                dataConvertComponent.Description = "Data Conversion Component";

                CManagedComponentWrapper conversionInstance = dataConvertComponent.Instantiate();
                conversionInstance.ProvideComponentProperties();

                conversionInstance.AcquireConnections(null);
                conversionInstance.ReinitializeMetaData();

                // Connect the source and the transform
                dataFlowTask.PathCollection.New().AttachPathAndPropagateNotifications(srcComponent.OutputCollection[0],   dataConvertComponent.InputCollection[0]);

                IDTSOutput100 output = dataConvertComponent.OutputCollection[0];

                IDTSVirtualInput100 virtualInput = dataConvertComponent.InputCollection[0].GetVirtualInput();

                int inputId = dataConvertComponent.InputCollection[0].ID;

              

                foreach (IDTSVirtualInputColumn100 vColumn in virtualInput.VirtualInputColumnCollection)
                {
                    string test = vColumn.DataType.ToString();
                    if (vColumn.Name == "LN_DRVD_RMNG_TERM") MessageBox.Show("ff");
                    Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType dtype = new Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType();
                    dtype = getSSISDataTypes(vColumn.DataType);
                    if (dtype != Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_STR)
                    {
                        IDTSInputColumn100 inputColumn = conversionInstance.SetUsageType(inputId, virtualInput, vColumn.LineageID, DTSUsageType.UT_READONLY);
                        IDTSOutputColumn100 outputColumn = conversionInstance.InsertOutputColumnAt(output.ID, 0, vColumn.Name, string.Empty);
                        //conversionInstance.SetOutputColumnDataTypeProperties(output.ID, outputColumn.ID, dtype, vColumn.Length, 0, 0, 0);
                        conversionInstance.SetOutputColumnDataTypeProperties(output.ID, outputColumn.ID, dtype, 1000, 0, 0, 0);
                        outputColumn.CustomPropertyCollection[0].Value = inputColumn.LineageID;
                    }
                }

                conversionInstance.ReleaseConnections();
               

                //Adding Destination
                ConnectionManager SconMgr = package.Connections.Add("EXCEL");
                SconMgr.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\tesing.xls;Extended Properties=""Excel 8.0;HDR=Yes""";
                SconMgr.Name = "ExcelConnection";
              

                IDTSComponentMetaData100 destComponent = dataFlowTask.ComponentMetaDataCollection.New();
                destComponent.ComponentClassID = "DTSAdapter.ExcelDestination";
                CManagedComponentWrapper srcDesignTime1 = destComponent.Instantiate();
                destComponent.Name = "Source - MMBD_LN_MSTR1";
                destComponent.Description = "OLE DB Source";
                IDTSDesigntimeComponent100 srcDesignTimeComponentdest = destComponent.Instantiate();
                srcDesignTimeComponentdest.ProvideComponentProperties();

                srcDesignTimeComponentdest.SetComponentProperty("AccessMode", 0);
                srcDesignTimeComponentdest.SetComponentProperty("OpenRowset", "[MMBD_LN_MSTR]");

                destComponent.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.GetExtendedInterface(SconMgr);
                destComponent.RuntimeConnectionCollection[0].ConnectionManagerID = SconMgr.ID;

                dataFlowTask.PathCollection.New().AttachPathAndPropagateNotifications(dataConvertComponent.OutputCollection[0], destComponent.InputCollection[0]);

                //Mapping

                //IDTSOutput100 outputdest = destComponent.OutputCollection[0];
                //IDTSOutput100 inputputdest = dataConvertComponent.OutputCollection[0];

                //IDTSVirtualInput100 virtualInputdest = destComponent.InputCollection[0].GetVirtualInput();
             
                //foreach (IDTSVirtualInputColumn100 vColumn in virtualInput.VirtualInputColumnCollection)
                //{
                //    IDTSExternalMetadataColumn100 exMetaColumn = inputputdest.ExternalMetadataColumnCollection.New();
                //    srcDesignTimeComponentdest.MapInputColumn(inputputdest.ID, vColumn.ID, exMetaColumn.ID);
                //}


                // Iterate through the inputs of the component.
                foreach (IDTSInput100 input in destComponent.InputCollection)
                {
                    // Get the virtual input column collection for the input.
                    IDTSVirtualInput100 vInput = input.GetVirtualInput();

                    // Iterate through the virtual column collection.
                    foreach (IDTSVirtualInputColumn100 vColumn in vInput.VirtualInputColumnCollection)
                    {
                        // Call the SetUsageType method of the design time instance of the component.

                        srcDesignTime1.SetUsageType(input.ID, vInput, vColumn.LineageID, DTSUsageType.UT_READONLY);


                    }
                    //map external metadata to the inputcolumn
                    //int index = 0;
                    foreach (IDTSInputColumn100 inputColumn in input.InputColumnCollection)
                    {

                        IDTSExternalMetadataColumn100 exMetaColumn = input.ExternalMetadataColumnCollection.New();
                        exMetaColumn.CodePage = inputColumn.CodePage;
                        exMetaColumn.DataType = inputColumn.DataType;
                        exMetaColumn.Length = inputColumn.Length;
                        exMetaColumn.Name = inputColumn.Name;
                        inputColumn.ExternalMetadataColumnID = exMetaColumn.ID;
                        srcDesignTime1.MapInputColumn(input.ID, inputColumn.ID, exMetaColumn.ID);
                    }
                }


                SIFISO_app.SaveToXml("D:\\C Drive\\Desktop\\DataExportWizard_Source\\SSIS\\SSIS\\pkg_Execute_Sql_Tasks.dtsx", package, null);

               
                DTSExecResult pkgResults = package.Execute();

                if (pkgResults == DTSExecResult.Success)
                    Console.WriteLine("Package ran successfully");
                else
                    Console.WriteLine("Package failed");
            }
            catch (Exception ex)
            { 
            }
        }

        public Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType getSSISDataTypes(Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType DataType)
        {
            int codepage = 0; ;
            int length = 0; ;
            int scale = 0;
            int precision = 0;


            Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType Dtype = Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_WSTR;
            switch (DataType)
            {
            
                case  Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_STR:
                    codepage = 0;
                    length = 3000;
                    scale = 0;
                    precision = 0;
                    Dtype = Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType.DT_STR;
                    break;

            }
          
            return Dtype;
        }
        

why do we still use Visual studio version more than 5 yrs

http://support.microsoft.com/lifecycle/search/?sort=PN&alpha=Visual+Studio&wa=wsignin1.0

roducts ReleasedLifecycle Start DateMainstream Support End DateExtended Support End DateService Pack Support End DateNotes
Team Explorer for Microsoft Visual Studio 201210/31/20121/9/20181/10/2023
Visual Studio .NET 2002 Academic Edition4/15/20027/10/20077/14/20092/28/2006
Visual Studio .NET 2002 Enterprise Architect4/15/20027/10/20077/14/20092/28/2006
Visual Studio .NET 2002 Enterprise Developer4/15/20027/10/20077/14/20092/28/2006
Visual Studio .NET 2002 Professional Edition4/15/20027/10/20077/14/20092/28/2006
Visual Studio .NET 2002 Service Pack 13/8/2005Review NoteReview NoteSupport ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport.
Visual Studio .NET 2003 Enterprise Architect7/10/200310/14/200810/8/201310/9/2007
Visual Studio .NET 2003 Enterprise Developer7/10/200310/14/200810/8/201310/9/2007
Visual Studio .NET 2003 Professional Edition7/10/200310/14/200810/8/201310/9/2007
Visual Studio .NET 2003 Service Pack 19/15/2006Review NoteReview NoteSupport ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport.
Visual Studio 2005 Professional Edition1/27/20064/12/20114/12/20161/8/2008
Visual Studio 2005 Service Pack 112/14/2006Review NoteReview NoteSupport ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport.
Visual Studio 2005 Standard Edition1/27/20064/12/20114/12/20161/8/2008
Visual Studio 2005 Standard Edition academic license1/27/20064/12/20114/12/20161/8/2008
Visual Studio 2005 Team Edition for Database Professionals3/2/20074/10/20124/11/2017
Visual Studio 2005 Team Edition for Software Architects1/27/20064/12/20114/12/2016
Visual Studio 2005 Team Edition for Software Developers1/27/20064/12/20114/12/2016
Visual Studio 2005 Team Edition for Software Testers1/27/20064/12/20114/12/2016
Visual Studio 2005 Team Foundation Server6/17/20067/12/20117/12/20161/8/2008
Visual Studio 2005 Team Foundation Server Service Pack 112/14/2006Review NoteReview NoteSupport ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport.
Visual Studio 2005 Team Suite1/27/20064/12/20114/12/2016
Visual Studio 2005 Team Test Load Agent1/25/20064/12/20114/12/2016
Visual Studio 2005 Tools for the Microsoft Office System1/27/20064/12/20114/12/2016
Visual Studio 2008 Academic Edition2/19/20084/9/20134/10/201810/13/2009
Visual Studio 2008 Express Edition Service Pack 18/11/2008Review NoteReview NoteSupport ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport.
Visual Studio 2008 Professional Edition2/19/20084/9/20134/10/201810/13/2009
Visual Studio 2008 Service Pack 18/11/2008Review NoteReview NoteSupport ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport.
Visual Studio 2008 Standard Edition2/19/20084/9/20134/10/201810/13/2009
Visual Studio 2010 Premium6/29/20107/14/20159/8/20204/10/2012
Visual Studio 2010 Professional6/29/20107/14/20159/8/20204/10/2012
Visual Studio 2010 Professional with MSDN6/29/20107/14/20159/8/20204/10/2012
Visual Studio 2010 Professional with MSDN Embedded6/29/20107/14/20159/8/20204/10/2012
Visual Studio 2010 Remote Debugger6/29/20107/14/20159/8/2020
Visual Studio 2010 Service Pack 13/8/2011Review NoteReview NoteSupport ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport.
Visual Studio 2010 Shell (Integrated)6/29/20107/14/20159/8/2020
Visual Studio 2010 Shell (Isolated)6/29/20107/14/20159/8/2020
Visual Studio 2010 Software Development Kit6/29/20107/14/20159/8/2020
Visual Studio 2010 Ultimate6/29/20107/14/20159/8/20204/10/2012
Visual Studio 2010 Ultimate with MSDN6/29/20107/14/20159/8/20204/10/2012
Visual Studio 2012 Remote Tools10/31/20121/9/20181/10/2023
Visual Studio 2012 Software Development Kit10/31/20121/9/20181/10/2023
Visual Studio 2012 Tools for Applications Software Development Kit7/28/20131/9/20181/10/2023
Visual Studio 6.0 Enterprise Edition8/10/1998Review NoteReview NoteThe support date for Visual Studio 6.0 is determined by its component product’s individual support life cycles. Please look up the individual product to determine its length of support.
Visual Studio 6.0 Professional Edition9/2/1998Review NoteReview NoteThe support date for Visual Studio 6.0 is determined by its component product’s individual support life cycles. Please look up the individual product to determine its length of support.
Visual Studio 6.0 Service Pack 110/27/1998Not ApplicableNot Applicable4/11/2000
Visual Studio 6.0 Service Pack 21/21/1999Not ApplicableNot Applicable6/13/2000
Visual Studio 6.0 Service Pack 35/21/1999Not ApplicableNot Applicable10/9/2001
Visual Studio 6.0 Service Pack 46/15/2000Not ApplicableNot Applicable3/31/2002
Visual Studio 6.0 Service Pack 52/26/2001Not ApplicableNot Applicable4/12/2005
Visual Studio 6.0 Service Pack 63/29/2004Review NoteReview NoteSupport ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport.
Visual Studio Express 2012 for Windows Desktop12/11/20121/9/20181/10/2023
Visual Studio Lab Management 20106/29/20107/14/20159/8/2020
Visual Studio LightSwitch 201110/30/20111/10/20171/11/2022
Visual Studio Premium 201210/31/20121/9/20181/10/2023
Visual Studio Team Agents 20106/29/20107/14/20159/8/2020
Visual Studio Team Explorer 20107/11/20107/14/20159/8/2020
Visual Studio Team Explorer Everywhere 20107/11/20107/14/20159/8/20204/10/2012
Visual Studio Team Foundation Server 20106/29/20107/14/20159/8/2020
Visual Studio Team Foundation Server 2010 Service Pack 13/3/2011Review NoteReview NoteSupport ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport.
Visual Studio Team Foundation Server 201210/31/20121/9/201810/1/2023
Visual Studio Team Foundation Server Express 201210/31/20121/9/20181/10/2023
Visual Studio Team System 2008 Architecture Edition2/19/20084/9/20134/10/2018
Visual Studio Team System 2008 Database Edition2/19/20084/9/20134/10/2018
Visual Studio Team System 2008 Development Edition2/19/20084/9/20134/10/2018
Visual Studio Team System 2008 Team Explorer2/14/20084/9/20134/10/2018
Visual Studio Team System 2008 Team Foundation Server2/19/20084/9/20134/10/201810/13/2009
Visual Studio Team System 2008 Team Foundation Server Service Pack 18/11/2008Review NoteReview NoteSupport ends 12 months after the next service pack releases or at the end of the product's support lifecycle, whichever comes first. For more information, please see the service pack policy at http://support.microsoft.com/lifecycle/#ServicePackSupport.
Visual Studio Team System 2008 Team Suite2/19/20084/9/20134/10/2018
Visual Studio Team System 2008 Test Edition2/19/20084/9/20134/10/2018
Visual Studio Team System 2008 Test Load Agent2/19/20084/9/20134/10/2018
Visual Studio Test Professional 20106/29/20107/14/20159/8/2020
Visual Studio Test Professional 201210/31/20121/9/20181/10/2023
Visual Studio Tools for the Microsoft Office System version 200312/4/20031/13/20091/14/2014
Visual Studio Ultimate 201210/31/20121/9/20181/10/2023
Workflow Manager Tools for Visual Studio 201210/18/20121/9/20181/10/2023