Note: This is an old article, citing an issue with legacy systems or providers. Some troubleshooting tips may still be applicable to newer versions. However, this article has not been tested with newer releases after 2016.
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