I am using a Sybase stored procedure as my input source for a data
transformation. I can preview the data along with the column headers.
When I go to the Transformation tab I am unable to see the source
columns (from the SP).

Any one else run into this?

I have played around with the prepare option in ODBC and no luck...

Any help!?!?

Can you use it anywhere else ? Excel etc.?
Does your Sybase SP return column headers ? ie this will not produce
anything in the Source for a mapping

SELECT SUM(A*B) FROM TABLE

This will

SELECT SUM(A*B) as Value FROM TABLE



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Matthew White" <mrwhite (AT) lehman (DOT) com> wrote

I can see the columsn when I preview the data, but I cannot see them
when I look at the source columns... Remeberm this is using DTS... I can
use ADO/ADOX/etc..., but I would rather use the nice and simple Data
Pump -- I think it is an ODBC provider issue...

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!