can you please help me to pass the connection file in the same way. what will be the syntax of the connection file??

I found command dtexec /conn connectionfilename packagename.dtsx to execute my package by providing external connection.

But can you please help me to prepare connectionfile. I can't find anywhere googling the...

Thanks everybody for your warm suggestions. I used output inserted.col1 for my task.

I tried to use @@rowcount but it returned 0 for update statement. So, i couldn't use this.

Thanks again...

I mean like

if

update tbl1 set col1='Y' where col2='xyz'

updates one or more rows, then i need to execute one set of statements. if this doesn't update any rows, then i...