SSIS Flat File Connection Manager

Hello All

I have a foreach loop that iterates through several servers and executes a stored procedure on each database and I am writing the results to a pipe delimeted file. I have created a column header in the connection manager the problem I am facing is that the header gets created for every pass I would like for the header to get created only once how do I fix this

Thanks
sql20Asked:
Who is Participating?
 
Alpesh PatelAssistant ConsultantCommented:
Hi,

If you are creating file using Flat file source from multiple servers and it creates more than one files (each for one server). Create header for only single file (Uncheck the option for first row is header)

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.