I have a SSIS package loading a lot of CSV file, which first line is the column head. Some file are ordered differently. However, package still try to load the file use predefined column order (it seems it doesn't check the head of each file see if it matchs the predefined column order).
Any way to force the package the check each file's head? or I had to manually check it using VB.Net script?
No, the Flat File connection manager cannot adapt to dynamic file formats. You can workaround with script. These threads should be helpful.http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1408850&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1438953&SiteID=1
