SSIS variables

  • 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

  • You can use a variable if you have an expression for the relevant property in the connection manager.

    😎

  • Good to know :unsure:

  • 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