Hi Thomas,

Thanks for your info. I want to do two -way process consolidating data from firebird databases to one mssql2005 database and then from mssql2005 transfer back data to firebird databases. so do i need to use both kettle/talend and intergration services ?

inside the feature components for integration service it has mssql2000 dts designer component do i need that ?
i already have the dts for mssql2005 but it is still not showing in the mssql2005 ?

my firebird database consist of chinese charater in unicode_fss , does mssql2005 able to display that after being transfer using kettle/talend ? and likewise does firebird able to display the chinese character from mssql2005 after the data being transfered back ? thanks

Regards
Halim S

Thomas Steinmaurer <ts@...> wrote: > i use ibpump for manual data transfer but i need auto and programmable data transfer tool.

>
> I have used data transformation service in mssql2000 to do data transfer but in mssql2005 i cant find the dts what method should i use ? another issue is how to transfer chinese char unicode_fss from firebird to mssql2005 and from mssql2005 back to firebird ? please advise thanks

If it is a one-way process, e.g. moving transactional data from a
Firebird database into a MSSQL based data warehouse, then any ETL Tool
like "Kettle" or "Talend" could do the job. We have been using Kettle
lately and IMHO, it is a very nice open source product, but I have also
heard good things about Talend.

In MSSQL 2005, the ETL product is called "Integration services".

--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com





---------------------------------
Get your new Email address!
Grab the Email name you've always wanted before someone else does!

[Non-text portions of this message have been removed]