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