July 24, 2014 at 4:28 am
Greetings 🙂
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?
Richard
July 24, 2014 at 5:45 am
You can use a variable if you have an expression for the relevant property in the connection manager.
😎
July 24, 2014 at 6:02 am
Good to know :unsure:
July 24, 2014 at 6:20 am
Go With For each loop container.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply