2016 SSIS inquiry

  • I have to modify a simple SSIS package that extracts a table from a database and copies it to another server with a different database name.   I've examined the code using a standard sql utility and identified the connection strings and databases.    But I don't see the code that specifies the tables.  Do I need to examine the project in visual studio?   Yes, I'm a newbie at SSIS.

    When the snows fall and the white winds blow,The lone wolf dies but the pack survives.

    Once you've accepted your flaws, no one can use them against you.

  • Yes, to examine what SSIS packages do, you need to open them in VS/SSDT.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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