Post reply

Creating the SSIS 2012 package using C#(To run a SSIS package outside of SQL Server Data Tools you must install sourceErrorDesc_LOOKUP_MODE of Integration Services or higher)

  • November 19, 2014 at 6:40 am

    #295239

    I am in upgrading my code written in 2008 to 2013 .net , when I the run the code I get error :To run a SSIS package outside of SQL Server Data Tools you must install sourceErrorDesc_LOOKUP_MODE of Integration Services or higher.

    when I check the pkg.Execute() it say failure , when I see the inner exception I could see the error saying

    "package outside of SQL Server Data Tools you must install sourceErrorDesc_LOOKUP_MODE of Integration Services or higher."

    could please tell what I need to do for this issue , I have SQL 2012 and .net 2013 and the DLL which is used in the code are having version 11.0.0 in my code even still I get this error .

    currently all my server SQL server 2008 but my code in .net 4.0 framework

  • November 19, 2014 at 8:26 am

    #1759538

    How are you trying to execute the package?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • November 19, 2014 at 9:43 am

    #1759568

    I am creating the package using C# code

  • November 19, 2014 at 9:46 am

    #1759569

    Application app = new Application();

    Package pkg = new Package();

    pkg.MaxConcurrentExecutables = MaxConcurrent;

    DTSExecResult executionResult = pkg.Execute();

    I am using the SQL 2012 DLL version in my code

  • November 19, 2014 at 9:59 am

    #1759574

    I am upgrading the code from 3.5 to 4.0 Framework I referenced the SQL 2012 DLL as reference in project when I execute the code package PKG.execute I get the below error

    "To run a SSIS package outside of SQL Server Data Tools you must install destErrorDesc_COMPANY of Integration Services or higher."

    Application app = new Application();

    Package pkg = new Package();

    pkg.MaxConcurrentExecutables = MaxConcurrent;

    /*******SQL DB CONNECTION*********/

    ConnectionManager conMgrDestination = pkg.Connections.Add("OLEDB");

    conMgrDestination.Name = "OLEDB_DESTINATION";

    conMgrDestination.ConnectionString = toConnection;

    DTSExecResult executionResult = pkg.Execute();

  • November 20, 2014 at 12:03 am

    #1759720

    Which edition of SQL Server 2012 do you have installed?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • November 20, 2014 at 4:05 am

    #1759766

    Enterprise Edition

    Just to add my pervious code is working fine with out any error which was developed in VS 2010

    I don't know how to fix it , I am stuck plz help me

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply