Thanks for the reply. Both the stored procedure and table name are on the same server.

Thanks all for the reply. Is there a way to handle transactions in SSIS package when all the data processing is done in C# exe?
Any help is much appreciated....

Thanks that works.

Can anyone help on this ?

Thanks,

Thank you so much for your inputs. I have one confusion . You mean I write just one script task in the whole SSIS package and in this ...

Thanks. The package levels parameters are also configurable in Integration Services catalogue?

Is it a good practice to save the paths in database tables or make them as package parameters?

Thanks. I added the password it works now.

Thanks for the reply. Your example is talking about project deployment model.

If I am using package deployment model, then I would need my connection string to be dynamic using...

The query is returning just one row and it is name as test.txt.

I tried sending to Gmail,it did not deliver and same error in logs.This is making me crazy .

The...

Thanks.I am sending to actual email address .Had it been problems with email address it would not deliver without attachments. its only an issue when I send email with attachment.

Thanks for your help. It says mail id queued but no email is send. Below is the message in mail logs

The mail could not be sent to the recipients because...

Its strange ,it worked first time and now not working again. The same query I am using .Is it something to do with my Microsoft exchange account ?

I have tried...