Search found 1 match
- Wed Nov 12, 2008 3:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Database connectivity to MS SQL Server
- Replies: 3
- Views: 2187
Re: Database connectivity to MS SQL Server
Hi , please try these below connectivity string , it has worked for me Provider=sqloledb;Data Source="servername";Initial Catalog="Database";Integrated Security=SSPI; WE can import the meta data using couple of RDBMS, 1. SQL server Enterprise DB , use plugin meta data iport funct...