I have an SSIS package.The SSIS runs perfectly the first time . then I lose the text file destination in the file connection manager each and every time I reset the file destination and try running the SSIS.Any advice.
What do you mean, exactly, by 'lose'? What error messages are you getting? Between running the package the first time and running it again, what actions are you taking? (Edit file, move file?)