question

lsnyd1 avatar image
lsnyd1 asked

SQL Server 2017 SSIS Package Export failure

Upgrading from SQL Server 2008 R2 to SQL Server 2017. Using SQL Server Business Intelligence Development Studio. I am able to publish to one SQL Server 2017, but fail to publish to another SQL Server 2017 with error "An OLE DB error 0x80004005 (Client unable to establish connection) ocurred while enumerating packages. A SQL statement was issued and failed." I have compared server settings and permissions without success. I must be missing something...

ssis
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.