I appreciate everyone's input; the discussion has given me some directions to research. One approach I tried was to store the WHERE field value as a STRING datatype in...

Sample Data (Header's are for ease of viewing here)

id_rsltn,code_rsltn,code_rsltn_cat,dt_rslvd,ind_rslvd

2011-06-09 09:36:01.923000000,SPAY,DISP,2011-09-21 00:00:00,A

Source Table (SQL)

CREATE TABLE [dbo].[smt_upd_rsltn](

[id_rsltn] [datetime] NOT NULL CONSTRAINT [DF__smt_upd_r__id_rs__5CED7072] DEFAULT (getdate()),

[code_rsltn] [varchar](4) NOT NULL CONSTRAINT [DF__smt_upd_r__code___5B052800] DEFAULT...

Thanks Brandie, yes the date parameter when used in the WHERE clause is the only parameter causing an issue. The other date parameter, the one where the data is...

It's the Destination that uses the parameters. The Source is a straight table. In the SQL Command property of the OLE DB Command, I am using the following...

Thank you Brandie for responding. The Source (SQL Server table) column is defined as Datetime. The Destination (Sybase table) is also defined as Datetime. In SSIS, using...

yayomayn, Your t-sql statement was very close. Could you please tweak it so there is a decimal between Seconds and Milliseconds instead of a colon? Your query results...

yayomayn, thanks for your help. I will try out the query statement this afternoon and post back my results.

Thanks again for your help. Unfortunately, there are no other columns to use as a natural PK. This is a 25 yo legacy Sybase database. Every table...

Thank you for the quick reply. I checked the timestamps and they are the same. As for the error, the is not one. The SSIS...