DTEXEC with /SET on 64bit fails

• deuba

  SSC Rookie

  Points: 35

  More actions

  February 28, 2008 at 6:04 pm

  #122472

  Hi,

  When I try to execute a SSIS Script package without any paramater in dtexec utility, it looks okay.

  However if i parameterize and pass the value in the commandöline with /SET option, it simply fails on 64 bit.

  Method 1

  Code :-

  Public Sub Main()

  Dim sServer As String = CStr(Dts.Variables(”myvar”).Value)

  ……

  ….

  Execution :-

  dtexec /FILE “D:\REFRSH.dtsx” /Set \package.variables[myvar].value;SVR

  where SVR is the value intended to be passed.

  OUTPUT :-

  Code: 0×80012017

  Source: REFRSH

  Description: The package path referenced an object that cannot be found: “\pa

  ckage.variables[myvar].value”. This occurs when an attempt is made to resolve a

  package path to an object that cannot be found.

  End Warning

  DTExec: Could not set \package.variables[myvar].value value to SVR.

  Method 2 :

  Dim sServer As Variable = Dts.Variables(”myvar”)

  But resulting exactly the same error message.

  Any ideas ?

  Thanks

• Frank Bazan

  SSCertifiable

  Points: 5378

  More actions

  February 29, 2008 at 4:08 am

  #783663

  Try changing the line:

  Dim sServer As Variable = CStr(Dts.Variables(”myvar”).value)

  to

  Dim sServer As String = Dts.Variables("myvar").value.ToString

  This will probably work for you and remember to set the option to precompile the script as required by 64bit.

  Kindest Regards,

  Frank Bazan