Метод loadfromsqlserver обнаружил код ошибки ole db 0x80004005

Answers

• 

  ---

  Avis de non-responsabilité:
  Mon opinion ne peut pas coïncider avec la position officielle de Microsoft.

  Bien cordialement, Andrei …
  
  MCP

  • Proposed as answer by

    Saturday, May 22, 2021 7:02 PM

  • Marked as answer by
    Иван ПродановMicrosoft contingent staff, Moderator
    Thursday, June 3, 2021 2:54 PM

• Здравствуйте

  Посмотрите пригодится ли Вам нижеперечисленное:

  1. Change the host file

  Which is generally located at “C:WINDOWSsystem32driversetchost” add server name and an ip address.

  This could solve your problem.

  1. Change the “Delay” setting in package property , package property ->Control flow delay.

  And the third one which generally would be the best alternative and will mostly solve this issue is

  1. Change the number of retry for the specific job to greater number (eg. 5 or more) and also can change the retry interval to (0). This way if this job fails with delay in connection, will retry again till specified number of times and mostly it gets succeeded.

  ---

  Мнения, высказанные здесь, являются отражением моих личных взглядов, а не позиции корпорации Microsoft. Вся информация предоставляется «как есть» без каких-либо гарантий.

  • Proposed as answer by
    Иван ПродановMicrosoft contingent staff, Moderator
    Saturday, May 22, 2021 7:02 PM
  • Marked as answer by
    Иван ПродановMicrosoft contingent staff, Moderator
    Thursday, June 3, 2021 2:54 PM

I have this error:

LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed

And here is my code, what is wrong?

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 

1

• Remove From My Forums

All replies

• Hi Aakash,

  It seems like it indeed times out. So it must be a slow network.

  But I do not know how to reproduce your error to help any further.

  ---

• Hi Aakash,

  Can you check the server name which you used to call the package? You should use the dbserver name where the package is installed.
  Please refer to : SSIS Package Timeout issue

                          «Login
  timeout expired» prevents package deployment

  Regards,
  Zoe

  ---

  MSDN Community Support
  Please remember to click «Mark as Answer» the responses that resolved your issue, and to click «Unmark as Answer» if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to
  MSDN Support, feel free to contact MSDNFSF@microsoft.com

• Hi Zoe,

  I have checked the dbserver name and it is correct.

  Thanks,
  Aakash

  ---

  Aakash Rajput

• Hi Aakash,

  please tell us how to reproduce this issue.

  ---

• • Proposed as answer by

    Tuesday, June 25, 2019 2:54 AM

• Hello,

  I am getting the same issue «The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired)» while launching package. I have imported package in MSDB of SQL Server 2014 and launching from c# code as below:

  Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();

  using (Package package = app.LoadFromSqlServer(string.Format(«{0}{1}», @»\», «Package»), «SERVER», null, null, null))

  { 

  DTSExecResult result = package.Execute();

   }

  Please let me know what might be the reason. It was working properly in SQL Server 2012.

  Thanks,

• Hi,

  Any updates on my query. I am using the same what Rajesh has posted, hope that will help in replicating the issue.

  Thanks,
  Aakash

  ---

  Aakash Rajput

• Hi Zoe,

  Any updates on my query. I am using the same what Rajesh has posted, hope that will help in replicating the issue.

  Thanks,
  Aakash

  ---

  Aakash Rajput

• Hi Aakash,

  After using his method, has your problem been solved?

  Regards,
  Zoe

  ---

  MSDN Community Support
  Please remember to click «Mark as Answer» the responses that resolved your issue, and to click «Unmark as Answer» if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to
  MSDN Support, feel free to contact MSDNFSF@microsoft.com

• Hi Zoe,

  The problem still persists. I am having the exact same code which he has posted and getting the «Login timeout expired» error.

  Thanks,
  Aakash

  ---

  Aakash Rajput

• Hi Aakash,

  Sorry, no progress has been made through our efforts. Maybe you can try to work it in SQL Server 2012 as Rajesh said before.

  Regards,
  Zoe

  ---

  MSDN Community Support
  Please remember to click «Mark as Answer» the responses that resolved your issue, and to click «Unmark as Answer» if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to
  MSDN Support, feel free to contact MSDNFSF@microsoft.com