Re: Regarding Connectivity

[Brandon Hines <brandon(at)2i(dot)com>]

Amit,

I have not set them up myself, but in the past we used DTS packages  
extensively.  There were some occasional issues, but it does work.

-Brandon


On Jan 8, 2008, at 6:43 AM, Amit Saha wrote:

> Hi,
>
> I have one question regarding the connectivity to PostGreSQL Database.
>
> Question: Is it possible to connect to the PostGreSQL database  
> through Microsoft SQL Server 2000 version in the DTS Package.
> There is a requirement to pull data from PoseGreSQL database into  
> SQL Server Database.
>
> In case, it's not possible, is there any way to export the data in a  
> flat file, so that I can use this for importing in SQL server  
> database.
>
> Please let me know how should I go about that.
>
> Thanks
> Amit