I decided to move with a different approach:

I have an SSIS package with two different connections and two different file flat file sources inside the same data flow.

Now my problem is. I would not like that if Dataflow 1 fails that the package fails. Instead I would like to wait for the result of data flow 2...

Thank you very much.

I guess I found a cool solution that I would like to post here.

I have created two connections, one called "ResColumn" and Other "WithoutResColumn"

Hello,

Thank you for your reply. Not sure I undertood your answer.

Maybe what I will do is continue with my approach. but instead of saving the content...

Hello,

Because this file is generated by a provider that is sending this infromation for free. If we which to have custom, then we have to pay and unfurtanetely...

Dear Both,

Thank you very much for your feedback.

Problem is this.

I have a provider (which I cannot request to change the format of files)...

Yes. That explains the test error. but not the dev error 🙁

I don't understand this one: The client version is incompatible with the database version. Ask your administrator...

It seems to me, from reply gaven by Gila that if we restore a Master DB database into a SQL Server 2016 sp1, even not having touched in the application...

We have upgraded all our instances from SQL Server 2012 to SQL Server 2016 SP1.

We have two different situations here:

1) In DEV environment I am getting this error...

Thank you for the link.

It says only enterprise and dev editions support it.

But I have one dought. Maybe you can help me clarify.

I am...

Now code is without converts. like:

EXEC ( '

SELECT

      DISTINCT (REPLACE(REPLACE(SchemaName, ''['', ''''), '']'', '''') +  '' - ''  + REPLACE(REPLACE(spname, ''['', ''''), '']'', '''')) ...