Thanks for the mention Dale.  Not sure if my server can handle the load :)
 
I hope that I didn't come across as preferring SSIS to Workbench in a heads-up 
comparison.  There is a huge amount of functionality in Workbench, especially 
around process documentation and items like custom transformers, that just 
aren't there in SSIS.
 
For me, the benefits of using SSIS are that I don't have to deal with external 
scripts and fmw files in multiple locations, and that the process is fairly 
self-evident to non-GIS folks in my department so that if I'm away they can 
deal with problems that might come up.
 
What would be really cool would be a Workbench to SSIS Package convertor :)
 
Jason
 
________________________________

From: [email protected] on behalf of Dale Lutz
Sent: Sat 2006-08-05 8:58 AM
To: [email protected]
Subject: [fme] Jason Birch scoops our upcoming SSIS integration



Hello folks,

I just got a note from Jason pointing me at his latest blog:

http://www.jasonbirch.com/nodes/2006/08/05/27/sql-server-2005-safe-at-la
st/

which focuses on the now-entering-beta FME/SSIS integration.  It's worth
a read, particularly if you are someone that uses other ETL tools in
your work situation.  We are working to integrate FME with several ETL
packages so that from within a single environment users can deal with
their traditional ETL processes as well as deal with a spatial component
thrown in.

I've been asked a few times why we would rehost the FME processing
environment in other User Interface -- does this mean we are somehow
ashamed of Workbench?  Not in the least.  The issue is that in some
corporate environments one ETL tool or another is already firmly
established as a standard.  By integrating FME with said ETL tool, the
organization can leverage the training and expertise and overall
investment in the ETL tool and extend its reach into the spatial arena.
It's a great value proposition.  And for those Workbench lovers out
there, you don't need to worry, because typically it is
possible/desireable/favorable to still use Workbench to design some of
the dataflows and then integrate those into the ETL environment later.

Thanks Jason for writing this up.  Exciting stuff.

Dale




Join us at the FME Worldwide User Conference Sept. 21-22, 2006 Vancouver BC 
Canada. For more information, visit www.safe.com/2006uc.   
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/fme/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 

<<winmail.dat>>

Reply via email to