rocky_498 (10/24/2013)
I am thinking, how I about I rename a file from txt file to FileName.bak, would that be good?
Yes. You can also specify the filename.dat in the flat file connection manager directly, no need to rename.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP