December 9, 2013 at 4:24 am
iam tring to import the packages which is a cluster environment while importing the package got the below error and also unable to open the msdb folder
The SQL Server specified in Integration Services service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer. For more information, see the topic "Configuring the Integration Services Service" in SQL Server 2008 Books Online.
any suggetsion how to resolve
December 9, 2013 at 5:00 am
You need to configure the MsDtsSrvr.ini.xml to reference your cluster \ instance name
This is in the ssis installation route folder and there are plenty of guides on how to do it on here 🙂
December 9, 2013 at 5:03 am
thanks for the reply can u pls provide the link how to do .
Appreciate your help.
December 9, 2013 at 5:07 am
Google will be your best friend 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply