Merging Sql, Lotus Notes, Access DB to SERVER 2000 DB 2

[Rafic]

Hi All,
i want to combine three sources to one.
sources: Sql, Lotus NOtes, Access
Target : Sql server 2000
Tell me a way for doing this
Rafic

 

[JayKusch]

Possibly via the use of DTS "IF" Lotus notes has some type of ODBC driver to connect thru.

Thanks

J. Kusch

 

[Catadmin]

Access & other SQL Server dbs are rather easy. You can use the DTS Import/Export Wizard for them. Make sure to do a data transformation on the Access db, though, or SQL will auto assign a datatype and it might not be the one you want to use.

I don't see an object in the DTS Wizard for Lotus Notes, though. Perhaps you should export your Lotus Notes to an Excel or a CSV/delimited text file. Then you can import it via the wizard.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[JayKusch]

I beleive you can create a new connection object for the NotesSQL 3.02g, or above, ODBC Driver for Domino.

I will keep looking on how to get it to work!


Thanks

J. Kusch

 

[JayKusch]

Bingo!

I beleive this article can be used to install the driver, even though we are not trying to create a linked server.

Once the driver is installed, select the "Other Connection" object in the connection types area of the DTS designer tool.

Should be able to use the same DSN setting that are described in this link ...

http://www.databasejournal.com/features/mssql/article.php/3462011

hope this gets you a bit further.

Thanks

J. Kusch

 

[Rafic]

Hi Kusch,
Thanks for your link.
I think It was pretty useful.
I will try this.

Thanks
Rafic