none
nsmespace is not found RRS feed

  • Question

  • how to get this namespace in win form, web app

    using Microsoft.SqlServer.Dts.Runtime;


    --Himanshu Kulkarni

    Tuesday, August 14, 2012 10:23 AM

Answers

  • Hi,

    you have to add a reference to Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll) inside your project first.

    With kind regards,

    Konrad

    • Proposed as answer by Sachin P Tuesday, August 14, 2012 10:38 AM
    • Marked as answer by Himanshu_Kulkarni Tuesday, August 14, 2012 10:51 AM
    Tuesday, August 14, 2012 10:35 AM

All replies

  • Hi,

    you have to add a reference to Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll) inside your project first.

    With kind regards,

    Konrad

    • Proposed as answer by Sachin P Tuesday, August 14, 2012 10:38 AM
    • Marked as answer by Himanshu_Kulkarni Tuesday, August 14, 2012 10:51 AM
    Tuesday, August 14, 2012 10:35 AM
  • thanks

    Could not load file or assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

    getting error on below code regarding adding above dll

    namespace SSIS_call
    {
        class Program
        {
            static void Main(string[] args)
            {
                string pkgLocation;
                Package pkg;
                Application app;
                DTSExecResult pkgResults;
                pkgLocation = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services" + @"\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx";
                app = new Application();       // err comes here
                pkg = app.LoadPackage(pkgLocation, null);
                pkgResults = pkg.Execute();
                Console.WriteLine(pkgResults.ToString());
                Console.ReadKey();
            }
        }
    }
    I am not getting this dll in 2010, above getting in 2008 just now I am checked

    --Himanshu Kulkarni



    Tuesday, August 14, 2012 11:02 AM
  • What was the location you referenced this asssembly from? check if its installed in GAC c:\windows\assembly

    What is the framework you are trying to build this assembly on you can see that on the project properties in BIDS

    You will find the .dll as Microsoft.SqlServer.DTSRuntimeWrap inside the GAC_64 or GAC_32 if you are using Visual Studio 2010 and respective folder depending on your bitness on the server


    Abhinav
    http://bishtabhinav.wordpress.com/


    • Edited by AB82 Tuesday, August 14, 2012 11:33 AM Added the .dll reference
    Tuesday, August 14, 2012 11:06 AM