How to get datatable data directly from SQL DB directly using SSIS jobs ?

[sbyadgi]

How to get datatable data directly from SQL DB directly using SSIS jobs ?

I guess I just want to know the SQL DB tables where the datatable contents are stored as blob.

-Thanks

[SachinSharma]

Hi @sbyadgi 

Refer following post, there is a query mentioned which lists all tables that contain columns with LOB data types in SQL server database.

Regards,

Sachin