SSIS PACKAGE EXECUTION IN 64 BIT MECHINE

• Bondalapati Srikanth

  SSC Journeyman

  Points: 77

  More actions

  January 15, 2009 at 10:58 pm

  #155137

  All

  I have a web service created in DB server (Since ssis package creation execution and will be done locally at which sql sb is installed) and using the web service in my application by pointing the web service URL for creating ssis package virtually and able to execute, even i am not saving the package physically.

  Dim pkg As New Package()

  .

  .

  .block of code for adding tasks

  .

  pkg.Execute()

  But in the load of excel i got a problem(error) and other i can able to load.

  I found so many articles which explains me that we can set a property ("Run64BitRuntime") to false for the project.

  But in my context i cannot have a project, because i am creating package virtually and executing.

  Can any one give me the best way to work on this.

  Please provide me the code if possible..

  Thanks In advance

  Srikanth

• pat-261672

  Hall of Fame

  Points: 3325

  More actions

  January 16, 2009 at 7:07 am

  #928087

  i used command based on the stp and it wored fine.