How to call a package from sql or .net

• BuilderBits

  SSCertifiable

  Points: 6071

  More actions

  August 20, 2006 at 6:27 pm

  #367175

  Can someone tell me how to invoke a package? And how to pass a value into a package scope variable?

  Where do these pachages go?

   

  erik

  Dam again!

• HYDNIZ

  Say Hey Kid

  Points: 699

  More actions

  August 22, 2006 at 9:02 am

  #656125

  You can see your packages logging on to Integration services from SQL Server 2005 Management console. You can keep them in file server as well. 

  Dim execApp As New Microsoft.SqlServer.Dts.Runtime.Application

  Dim execPkg As Microsoft.SqlServer.Dts.Runtime.Package

  execPkg = execApp.LoadFromSqlServer("Your Package location"","pkgServer", "pkgUser","pkgPassword", Nothing)

  execPkg.Variables("Pkgvariable1").Value = varvalue1

  execPkg.Variables("Pkgvariable2").Value = varvalue2

  execPkg.Execute()

  execPkg =

  Nothing

  Hope this helps.