ETL Magic with SSIS – Part II

  • GreyBeard

    Mr or Mrs. 500

    Points: 535

    Comments posted to this topic are about the item ETL Magic with SSIS – Part II

  • BarneyL

    Ten Centuries

    Points: 1044

    Great article, definitely one for the favourites file.

    The screenshots could with being bigger though, there were a few where the details in them were unreadable.

    Barney

  • Kevin Kunz-193240

    Valued Member

    Points: 73

    Being as the images are so small - perhaps you could upload the package, that would allow people to check their results with the package you created.

  • kevin.johnston

    Grasshopper

    Points: 17

    In my processing we recieve many files like this, for the part where your moving the non lookupvalues to another table, I typically deal with them by adding them to the lookup table in the error output then merge the rows so you get the new lookup value.

  • GreyBeard

    Mr or Mrs. 500

    Points: 535

    I agree about the screen shots, don't know what happened during the upload to the site. Here's a link to a pdf.

  • surreydude.

    SSChasing Mays

    Points: 601

    Wot no error flows?

  • Samuel Vella

    SSCrazy Eights

    Points: 8055

    SQL Server Destinations

    I'm not sure that using SQL Server Destinations is a good idea as the target server has to be local to the package

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

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