dtexec delay validation true

• texpic

  SSCertifiable

  Points: 5887

  More actions

  September 11, 2019 at 9:32 am

  #3679042

  I have a SSIS package that loads a flat file.  It runs fine on my laptop but on my virtual machine I have to set DelayValidation to true otherwise it looks like it loads the data then removes it from the final table.  On the virtual machine if I run the package from the Visual Studio screen (with DelayValidation  true) everything processes correctly.  If I try to execute it from a procedure it validates at the end and seems to remove the data from the final table.

  Question.  How would I add DelayValidation  = true to this scropt?  Thanks.

  DECLARE @cmd varchar(1000), @PathSSIS varchar(1000)
  
  SET @PathSSIS = 'c:\test\ImportOnly\ImportOnly\package.dtsx' 
  DECLARE @FileNamed varchar(1000) 
  SET @FileNamed = 'c:\test\MyFile_20190101'  
  
  SELECT @cmd = 'dtexec /FILE "' + @PathSSIS + '"'
  SELECT @cmd = @cmd + ' /SET \Package.Variables[User::FileNamed].Properties[Value];"' + @FileNamed + '"' 
  
  EXEC master..xp_cmdshell @cmd

   

   

• texpic

  SSCertifiable

  Points: 5887

  More actions

  September 11, 2019 at 10:02 am

  #3679050

  Yikes, disregard the question; made a simple mistake.