33 Check if file size is greater than 0 KB only load that file in SSIS

Thnks! Very helpful!

Hi Aqil,

In Filelogs I'm not getting the recordcount and it loads only one CSV file
"C:\Files\Dollar.CSV"

Can you please help me..

How to verify the in sql table is data available or not if data is not available then next step will execute or else exist form the package i will write the query

Hello, Thank you very much for your video. I have a use case that is different. I'm connecting to a SQL database looking for documents that have a signature on them that have a zero size to them. Rather than cycle through all of the notes in the storage location I would lilke to locate the exact files and return their size. Can this be done?

SELECT distinct per.person_id,
c.SignedName,
pn.location + pn.sub_location + cast(pn.note_id as varchar(255)) +'.rtf' as'file'
FROM patient_encounter pe
INNER JOIN person per ON pe.person_id = per.person_id
INNER JOIN CARD_Finalize_ c ON pe.enc_id = c.enc_id
inner JOIN patient_notes pn
ON pe.person_id = pn.person_id AND pe.enc_id = pn.enc_id
WHERE c.SignedName ! = ''
AND c.create_timestamp >= '20220101'
AND pn.table_name = 'CANEA_CARD_DiagAssessPlan_'
and field_name='instructions'

Hiii I have tried this but. In filelogs table it shows a value which give in statement but it's not show my exact row count in sql and in filelogs only one table is shown. But in that path I have given 2files

This is one interview question. I have 10 tasks in a package, in this 10 tasks if any task fail i want mail, so how to use single SMTP task for all 10 Tasks.

This is very helpful, go on with your video, you have my total support

Absolutely knowledgeable 👍👍

But what if files any excel formulae hidden in it and data is not available
File size is still more then zero right?