Hi, I have a Dataflow with three componnets: 1. script component 2. script component 3. flat file destination After I connected second script tothe flat file destination andtryed toopend Flat File Destination Editor, a dialog with this message showed: TITLE: Editing Component------------------------------ The component is not in a valid state. The validation errors are:Error at Data Flow Task [Flat File Destination [76]]: The component locale ID has not been set. Flat file adapters need to have the locale ID on the flat file connection manager set. Do you want the component to fix these errors automatically? ------------------------------BUTTONS: &Yes&NoCancel------------------------------ No matter which button I pressed, I was not able to work with flat file connection manager. When I selected a file path in connection manager editor, I got an error "A valid file name must be selected". I tryed different files in differnet folders, but got the same error. So I tryed to open some older working packages. On flat file destination componnent , when I clicked on tab"Mapping", recieved error " [Flat File Destination [51]]: Unable to access the acquired connections.", Flat File connection manager showed "A valid file name must be selected". But althought these old packages seem to be broken in design, they a running OK. I thought, that the problem could be in wrong expression for connectionString, but it still remainsafter removing it. Please, could you give me advice, where could be a problem or whatshould I check? Thanks a lot Janca

It sounds like the connection might be set through a configuration or an expression. Have you checked to see if that is the case?

I used expression for the connection, checked it, than completely removed butit didn't help. I am not able to create even a new connection. Neither configuration for setting connection string is not used in my case.

It's one of those things I will never uderstand. I added the package into a new project and everything worked fine, then copied back to the old project and couldn't edit flat file connection as before

I suspect it's SQL Server SP issues?... I'm having the same problem, I have done what you did by creating a new project. and it works! thanks!!!

It's not a SP2 issue... just tick off "WorkOffline" in project main menu > SSIS

Hi Brunic, Thanks a lot for saving me from reinstalling SSIS. It did work perfectly. Regards, Vijay