path parameters to ssis package

• arkiboys

  Hall of Fame

  Points: 3958

  More actions

  December 12, 2011 at 6:10 am

  #391103

  Hi,

  Trying to pass parameters to one ssis package and execute it as below.

  Note that I am using one exec per parameter for the same ssis package.

  The error is:

  'DTSExec' is not recognized as an internal or external command,

  operable program or batch file.

  NULL

  EXEC xp_cmdshell 'DTSExec /SQL "\PackageName" /SERVER "(ServerName)" /SET "\Package.Variables[User::ServerName].Value";"\\servername"'

  EXEC xp_cmdshell 'DTSExec /SQL "\PackageName" /SERVER "(MainPath)" /SET "\Package.Variables[User::MainPath].Value";"\d$\foldername"'

  EXEC xp_cmdshell 'DTSExec /SQL "\PackageName" /SERVER "(MainPath)" /SET "\Package.Variables[User::FileName].Value";"filename"'

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  December 12, 2011 at 11:58 pm

  #1420372

  Take a look at this thread:

  http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ec5a4654-ada2-4974-8140-529cfb8153c8/

  😉

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• arkiboys

  Hall of Fame

  Points: 3958

  More actions

  December 13, 2011 at 2:33 am

  #1420442

  Solved the syntax issue.

  Thanks