jamesl 88576 (3/11/2013)
I am trying to automate the move of data in .txt files to staging tables in Sql. I have been all over the internet and have read many questions and answers on Sql Server Central and have not found a solution.When going through a flat file connection manager you always have to reset the columns, or so it seems. Can anyone suggest a work around for this problem? Actually I don't want to touch the connection manager once it is set up.
I am not sure what you mean by "always have to reset the columns." As long as the format of the incoming files are the same then you do not have to do anything except change where the connection manager is pointing, i.e. change the path to point to the new file. If the file format changes then yes, you have to change the Connection Manager to be able to process the new file format.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato