One my package uses script component to generate's a text file.Every day the package is executing successfully but the text file is not created in the specified location . Am using variables for file name,location please help.

Are you working with Fullpath? Maybe you want to write the File to a Network mapped Drive? Use UNC-Paths Do you have some Erroroutput?

How are you running your package? Is it via a sql server agent. If yes, can you check the job history to see if there are any warning messages. Can you test the package in debug mode and check if the file is getting created?http://btsbee.wordpress.com/

Hello, Please specify more details of how you are running/deploying your package? It will help us to resolve the issue.

And maybe post the actual script so we can see what is going on.MCTS, MCITP - Please mark posts as answered where appropriate.

Add some logging (this.ComponentMetaData.FireInformation) to your script component. For example to verify that your variable is filled. And add a try catch around the file writing part. Something like: try { // your code } catch (Exception e) { // Raise event so it can be logged by SSIS bool pbCancel = false; this.ComponentMetaData.FireError(0, myTask, "An error occurred: " + e.Message.ToString(), "", 0, out pbCancel); } Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Add some logging (this.ComponentMetaData.FireInformation) to your script component. For example to verify that your variable is filled. And add a try catch around the file writing part. Something like: try { // your code } catch (Exception e) { // Raise event so it can be logged by SSIS bool pbCancel = false; this.ComponentMetaData.FireError(0, myTask, "An error occurred: " + e.Message.ToString(), "", 0, out pbCancel); } Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter