• srilu_bannu (3/27/2013)


    Hi all,

    I am working on SSIS and created integrated services project and saved them under a new folder.

    I want to deploy them under msdb folder and schedule the package but, i am getting this error:

    ...

    I couldn't give the instance name because our SQL Server is installed on default instance mssqlserver so i gave only server name nyabc.

    No matter how i change the part <ServerName>nyabc</ServerName> i was unable to load the package into msdb folder. It is giving the same error even after restarting ssis service.

    Can anyone please tell me what is the wrong i am doing here? How should i import packages to msdb folder and schedule them?

    Under which name is the SQL Server database engine installed? Under the default instance or under nyab?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP