ETL Magic with SSIS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Ron Johnson » ETL Magic with SSIS – Part II

ETL Magic with SSIS – Part II

Rate Topic

Display Mode

Topic Options

Author

Message

GreyBeard

Posted Thursday, January 12, 2012 12:06 AM

Valued Member

Group: General Forum Members
Last Login: Monday, March 11, 2013 8:52 AM
Points: 65, Visits: 321

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

Post #1234538

BarneyL

Posted Thursday, January 12, 2012 1:25 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:05 AM
Points: 318, Visits: 640

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

Post #1234559

Kevin Kunz-193240

Posted Thursday, January 12, 2012 12:55 PM

Grasshopper

Group: General Forum Members
Last Login: Sunday, May 19, 2013 3:38 PM
Points: 23, Visits: 563

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.

Post #1235189

kevin.johnston

Posted Thursday, January 12, 2012 2:18 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 08, 2013 2:42 PM
Points: 1, Visits: 86

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.

Post #1235239

GreyBeard

Posted Thursday, January 12, 2012 9:32 PM

Valued Member

Group: General Forum Members
Last Login: Monday, March 11, 2013 8:52 AM
Points: 65, Visits: 321

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

Post #1235356

surreydude.

Posted Friday, January 13, 2012 12:54 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, April 19, 2013 4:50 AM
Points: 109, Visits: 114

Wot no error flows?

Post #1235410

Samuel Vella

Posted Friday, January 13, 2012 2:40 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 6:46 AM
Points: 328, Visits: 1,851

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

Post #1235467

« Prev Topic | Next Topic »

Permissions