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


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match