ssis package implementation

  • hi am database devolper i want one package which is take the connection string as user defined variable from database table...

    here i want use of for each loop container...

    can someone give answer for this question?

  • start of with creating a table with an ID column, and a column with your server/db names.

    use the row ID's to get the server names in each loop, with a ID+1 at the end, and then a where id = id+1...

    something of the sort.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply