InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 13:59:17 GMT20http://www.sqlservercentral.com/Forums/Topic1234538-2881-1.aspx[quote]SQL Server Destinations[/quote]I'm not sure that using SQL Server Destinations is a good idea as the target server has to be local to the packageFri, 13 Jan 2012 02:40:24 GMTSamuel Vellahttp://www.sqlservercentral.com/Forums/Topic1234538-2881-1.aspxWot no error flows?Fri, 13 Jan 2012 00:54:45 GMTsurreydude.http://www.sqlservercentral.com/Forums/Topic1234538-2881-1.aspxI agree about the screen shots, don't know what happened during the upload to the site. Here's a [url=http://rjssqlservernotes.files.wordpress.com/2011/10/etl-magic-with-ssis-part-1.pdf]link to a pdf[/url].Thu, 12 Jan 2012 21:32:53 GMTGreyBeardhttp://www.sqlservercentral.com/Forums/Topic1234538-2881-1.aspxIn 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.Thu, 12 Jan 2012 14:18:48 GMTkevin.johnstonhttp://www.sqlservercentral.com/Forums/Topic1234538-2881-1.aspxBeing 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.Thu, 12 Jan 2012 12:55:08 GMTKevin Kunz-193240http://www.sqlservercentral.com/Forums/Topic1234538-2881-1.aspxGreat 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. BarneyThu, 12 Jan 2012 01:25:11 GMTBarneyLhttp://www.sqlservercentral.com/Forums/Topic1234538-2881-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Integration+Services+(SSIS)/76525/">ETL Magic with SSIS – Part II</A>[/B]Thu, 12 Jan 2012 00:06:24 GMTGreyBeard