File or directory represented by connection does not exist
I am looping through files in a folder in SSIS - 2008 / SQL Server 2008. Each file is copied to a staging folder, unzipped via an execute process task. The unzipped file is the source for a flat file connection in a data transform. Everything works great from my local BIDS machine. When I run the deployed package from the SQL Server agent, I keep getting the following error message "Log File" Description: The file name property is not valid. The file name is a device or contains invalid characters. End Error Error: 2011-06-20 12:43:04.18 Code: 0xC001401E Source: xyz Connection manager "Log File" The file in question is the newly created, unzipped file - which certainly does exist, and the SQL Server agent login has full rights to it. I have tried everything here and it just doesn't work. I have granted "Everyone" full access to the file folder. I can see that the file is copied and unzipped, but the Flat File connection manager just will not accept a valid file name. I have the Flat File Connection Connection String property set to an expression which points to the newly unzipped file. Please keep in mind - this works fine from my local machine - it only fails when deployed to SSIS.
June 20th, 2011 4:59pm

Are you using a log provider for text files? It looks like, based on the name, that the log file connection manager is failing and maybe the folder on your local machine that you are writing logs to does not exist on the server you've deployed to.
Free Windows Admin Tool Kit Click here and download it now
June 20th, 2011 5:11pm

Have you set the Connection Manager's DelayValidation property to true? It may have worked on your local machine because the "unzipped" file was always there (due to how you developed your package). But on the server, because the unzipped file isn't there when the package is loaded, the connection manager will fail to validate. Setting DelayValidation to true tells SSIS not to check for the file until it's time to actually use it. Talk to me now on
June 20th, 2011 6:07pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics