I have created SSIS package in MSDB but the setting files are being stored in the local temp folder...I can see them in the connection manager (in the properties of the package as they are created automatically). Is there is any way to change file path?
Because of this what happening is:
When I created the package using domain user account, the package is created successfully and it runs properly. But when I log off and again log in to the server the package fails as the setting files are being stored in the local temp folder and it gets
flushed when I log off.
Is there is any setting while creating the SSIS package or in SQL server 2005?
View Complete Post