Sorry guys.. please do not reply now.. It sounds funny but there was a reason for posting this..

There were few fields (strings types); i combine using them .. this is an example ( LeftTable.string1= RightTable.string1 or RightTable.string1 is Null)

...

Thanks SSCrazy. Union all does not work in my case as i do not want two rows .........

but left join worked.. thanks.

Yes it has permissions to that folder. I am not sure what is the problem... going crazy now..

It works when i connect to SSIS in sql server and execute a...

Thanks.

I have given path like this \\file servername\foldername

It works from server too but when i run ssis package not the job.

Thanks

Thanks mister magoo.

So helpful people in this forum 🙂 🙂 🙂

Thanks for your help.

Thanks for your reply. I think this will work.

Thanks for your response. But i have never used datadriven subscription. How to use it? Any idea?

Thanks Everyone

Thanks P Jones

Thanks Everyone for your valuable suggestions.

I appreciate your help. SQLservercentral.com and you guys rock .

[highlight=#ffff11]It depends on your environment. Consider following things:

1. How busy is your system?

2. When is minimal activity on your system ? Schedule the maintenance jobs at that time.

Also, it is...

I did not mean to run manually.

Set up shared schedule to run at 12 am on the 1st of the month.