So I've been tasked with doing a total conversion of the main bulk of dts packages that run at our clients warehouse systems to ssis. This is because A)all the databases are being switched over to sql server 2008 B)the software lisence on a previous system has run out
So yesterday I converted 7 packages which all follow the same logic,take a csv file and load it into the database.
However I can't tell from the DTS package itself whether the flat file source runs for a single file or if multiple are possible.
So can anyone tell me what is correct,I got a flat file connection that points to a folder can multiple files exist or is only 1 read