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.
0 Comments