Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Sybase Data Source, how to work around derived tab

Author  Topic 

rohitkumar
Constraint Violating Yak Guru

472 Posts

Posted - 2009-01-05 : 14:52:42
I posted a similar question in reporting services group, I am trying to fetch data from a sybase server. The query uses a derived table and because of it I cannot have it as a source of data in the SSIS package, has anyone experienced this before?

Whats the work around? I cannot create temp tables on the Sybase server, have read only access.
   

- Advertisement -