I've a one-off task to input a bunch of CSV files and feel ... this is a job for ssis.
There are 121 files named from ab.csv through the alphabet to ze.csv. They all have 19 columns and no headers.
(btw, I would rather not import them all into a single table)
I ran the import-wizard for the first one (and saved it) hoping to modify it do them all.
Trouble is ... a) it created a named table ("dbo.ab"), and used a connection to a named source (c:\CodePoint\ab.csv).
I guess I need to ... loop through a list of 121 text-strings (I'm not proud - I'll paste them into a table if its simplest).
creating tables and import into them individually.
Any advise on how to do this please?