Hi @Anagha Adhav ,
1.The bit data will be changed as Boolean [DT_BOOL] data in SSIS package.
Please refer to Mapping of Integration Services Data Types to Database Data Types.
2.We can use Derived Column Transformation in Data Flow Task.
Useful expression in Derived Column:
(DT_WSTR,10)ISDELETED == "True" ? 1 : ((DT_WSTR,10)ISDELETED == "False" ? 0 : NULL(DT_I4))
Best Regards,
Mona
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues in November--What can I do if my transaction log is full?
Hot issues in November--How to convert Profiler trace into a SQL Server table?