Hi,
We have a requirement where in we need to pull data from Greenplum to SQL Server with few transformations, DTS packages have to be used for this purpose. Can anyone please tell us if we can use ODBC/OLEDB connections to connect from SSIS to Greenplum...?? Also which would be faster ....??
Also has anyone worked on something similar to this...?? If so please provide your inputs on the issues faced by you and how it got solved.
Thanks,
Bhavya