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.
| Author |
Topic |
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
 Posted - 2008-08-08 : 16:03:22
|
| I am trying to setup a data flow task to copy data from sybase to SQL 2005.I have a stored procedure in the sybase db, output of which has to be loaded to SQL Server.Will SQL Command in OLE DB Source Editor work? using this I can see data in the preview window but Columns is all empty. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-08 : 16:47:54
|
| Did you setup ODBC/OLEDB provider for sybase? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-09 : 00:14:46
|
| You need Sybase client on sql server. |
|
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2008-08-11 : 09:44:27
|
| I am able to connect to Sybase from SSIS.In the OLE DB Source editor, I am using SQL Command optionIn case I give a simple query "select colA, colB from table" I see these names in the list of columnsBut if I give a execute procedure statement "execute getMyData_sp param1" I don't see any name in the list of column and therefore I cannot use this OLE DB source editor. |
|
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-11 : 12:58:44
|
| you can however use a table valued UDF for that. just change your procedure to a table valued UDF and give source like thisSELECT * FROM dbo.getMyData_udf(param1,..) |
|
|
|
|
|
|
copying data from sybase