title: LoadFromSQLServer method has encountered OLE DB
body: <p>I have this error: </p>
  
  <blockquote>
    <p>LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed</p>
  </blockquote>
  
  <p>And here is my code, what is wrong?</p>
  
  <pre><code>DECLARE @FileName VARCHAR(50); 
  DECLARE @VendorID VARCHAR(50); 
  DECLARE @sql VARCHAR(2000); 
  DECLARE @Local_File_FullPath VARCHAR(100);   
  
  SET @FileName = 'Extgt_skinny_file.txt.pgp' 
  Set @VendorID = 'ET' 
  
  Select @Local_File_FullPath = dw03_path  FROM GMAC_META.dbo.VENDOR_XFER_METADATA where vendor_id = @VendorID 
  
  SET @sql = 'dtexec /SQL "\EMAP_FTP_XFER_CHECK" /SET \Package.Variables[User::FileName].Properties[Value];"' 
  + @FileName+'" /SET \Package.Variables[Local_File_FullPath].Properties[Value];' 
  + @Local_File_FullPath+' /SERVER "hqgmdw02/dw_dev"   /CHECKPOINTING OFF /REPORTING E'
  
  
   exec xp_cmdshell @sql 
  </code></pre>