Error: "Error creating DTS package for [tablename] Cannot find folder "[folderpath]""

Symptoms

You receive this error message on deploy:

Error creating DTS package for [tablename]
Cannot find folder "[folderpath]"

This error can occur in the following scenario:

ServerA:

• tX application
• Integration Services

ServerB:

SQL Server default instance:

• Other timeXtender databases
• MSDB where SSIS packages are stored

SQL Server named instance:

• Repository
• Staging
• DWH

Resolution

In the timeXtender repository settings, staging and data warehouse, use the following settings:

Server: ServerB\namedinstance
SIS Server Name: ServerB

This will make sure that the SSIS packages are loaded from the correct instance of MSDB.