Dear all we have created SSIS packges for transfor the data from source to destion here i didn't use any conversation transformation source : Oracle destination : Sql server i have one table in source database structure is EVENT_ID LOGGED_IN_USER_ID EVENT_TIME LOGIN 34845 2012-06-19 07:41:01.0000000 LOGIN 8830 2012-06-19 07:41:02.0000000 my destion table structure is EVENT_ID nvarchar(16) LOGGED_IN_USER_ID nvarchar(15) EVENT_TIME datetime2(7) where ever i am executin the package like i got this error column "EVENT_TIME" (493) on input "OLE DB Destination Input" (470). The column status returned was: "Conversion failed because the data value overflowed the specified type. case 2: when i fetch the data this format select EVENT_ID,LOGGED_IN_USER_ID,CAST(EVENT_TIME AS VARCHAR(30)) ,CLIENT_MACHINE, AUDIT_DATA from ssoadm.sso_audit_tbl i received this type of error There was an error with input column "CAST(EVENT_TIMEASVARCHAR(30))" (58) on input "OLE DB Destination Input" (44). The column status returned was: "The value could not be converted because of a potential loss of data.". how to load a table smoothly from source to destination

Hi KONDAPATURU, >> column "EVENT_TIME" (493) on input "OLE DB Destination Input" (470). The column status returned was: "Conversion failed because the data value overflowed the specified type. Please right click on your connection manager and select show advanced editor, check the Input and Output Properties tab. Assuming that you define 2 different data types of datetime, one is DT_DBTIMESTAMD which specifies 3 decimal places on the seconds, another one is DT_DBTIMESTAMP2 which specifies 7 decimal places, please check this. For more details, please refer to this thread. >>"CAST(EVENT_TIMEASVARCHAR(30))" (58) on input "OLE DB Destination Input" (44). The column status returned was: "The value could not be converted because of a potential loss of data." Do you have NULLs in the column EVENT_TIME? If yes, enable the Retain null values from the source as null values in the data flow component. For more details about SQL Server Integration Services, please see this article for your reference. If youre still not able to resolve the issues base on my solutions, I recommend you that use SQL Server Migration Assistant(SSMA) to migrate data from Oracle to SQL Server. For more details, please refer to this blog.Best Regards, Ray Chen

Looks like you data type between source and destination tabel are not in sync. Try to create destination table with same data type which you have in source. If this is not possible, go to Advance editor and specify that package should ignore truncation.Please mark the post as answered if it answers your question