Syntax in LoadFromSQLServer method

• Richard Oths

  Old Hand

  Points: 320

  More actions

  August 19, 2007 at 8:55 pm

  #118215

  Hello,

  I'm trying to pass a parameter into the above referenced method. But the switching between VBA and T-SQL syntax is vexing me.

  CREATE PROCEDURE spRun_DTS (@PackageName char(10))

  AS

  DECLARE @object int, @hr int

  DECLARE @src varchar(255), @desc varchar(255)

  EXEC @hr = sp_OAMethod @object, 'LoadFromSQLServer("OWS78002878791", "", "", 256, , , , & @PackageName & )'

  If I hard code a value instead of @PackageName, then it works just fine. Any ideas?

  Thanks

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  August 20, 2007 at 1:25 am

  #727893

  Hi

  You have to use dynamic sql for this .

  "Keep Trying"