I guess it has nothing to do with any configurations, When you are running in IDE you use your login credintials, but when you schedule you use Sql service account....

Hi Jack,

I found the way to do.

first writing all the data to flat file. same time getting the rowcount to a variable which have package scope.

And with the script component...

Hi Jack,

I want this to schedule as a Job.

I have a requirement to send daily a flat file with update records on table.

Need to create a flat file (destination)...