Skip to main content
Mar 15, 2021 6:42 PM UTC
Question

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

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

1 reply

Mar 16, 2021 4:36 AM UTC

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