i'm quite new with all ssis,
i need to transfer data from sybase to sql server 2005,
i need to perform this task cauple of time a day, therefore every time
i need to transfer only the delta. (somting like replication).
so i thought about using the ssia - data flow -
i wanted to make a query on sql server 2005 get the last row that was
updated and than make the source query on the sybase use the parmeter
retrened from the sql server 2005.
but i don't know how to do that,
can someone help me please. :-)

dana

Hmmm... that was easy in DTS. In SSIS? Why not try adding a linked server to
the Sybase system, then use OLE DB Source in SSIS with Data Access mode set
to SQL Command, then a SQL query like:

SELECT * FROM OpenQuery(SybaseServer, 'SELECT * FROM SourceTable')
WHERE SourceTable.PrimaryKeyCol NOT IN (SELECT PrimaryKeyCol FROM
DestinationTable)

Charles Kangai, MCT, MCDBA

"dana" wrote:

Hello dana,

Can you get an OLEDB connection to Sybase?

You can use the OLEDB Source Adapter + Connection Manager to get a rowset
from Sybase and pass in a a parameter.

If the driver does not support Parameters then you could pass in the value
for the extract statement through a variable.

You could set the variable value to be the result of an expression.

You could get the last read row value into a variable itself and use that
in the expression that defines the SQL Statement to extract from Sybase.
I would do this in an ExecuteSQL task.


Allan