sql20
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.