Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ETL Magic with SSIS – Part II Expand / Collapse
Author
Message
Posted Thursday, January 12, 2012 12:06 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 3:07 PM
Points: 65, Visits: 331
Comments posted to this topic are about the item ETL Magic with SSIS – Part II
Post #1234538
Posted Thursday, January 12, 2012 1:25 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 2:13 AM
Points: 456, Visits: 788
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
Posted Thursday, January 12, 2012 12:55 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, November 28, 2014 11:57 AM
Points: 23, Visits: 585
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
Posted Thursday, January 12, 2012 2:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 8, 2014 9:33 AM
Points: 1, Visits: 102
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
Posted Thursday, January 12, 2012 9:32 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 3:07 PM
Points: 65, Visits: 331
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
Posted Friday, January 13, 2012 12:54 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, November 26, 2014 3:52 AM
Points: 249, Visits: 164
Wot no error flows?
Post #1235410
Posted Friday, January 13, 2012 2:40 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 5:51 AM
Points: 328, Visits: 2,001
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 »

Add to briefcase

Permissions Expand / Collapse