Is there an error?

You should also provide an explanation of what you are trying to accomplish.

At the top of my head, I can...

Probably something like this:

SELECT Feed = 'A', [No of Records] = COUNT(ID)

FROM TableA

UNION ALL

SELECT Feed = 'B', [No of Records] = COUNT(ID)

FROM TableB

UNION ALL

...

SELECT * FROM Table2 WHERE Status = 'A';

AWLS = advanced wilderness life support?

Great question, thanks.

What are the values of those variables?

With file system "deployment" you just copy the package to the file location where you want them.

Try converting the project to the package deployment model.

They are not mutually exclusive.

For example, if you want to restore to a point-in-time after the last back-up, you need to do a tail-log back-up first.

Tail-Log Backups (SQL Server)

There are no other errors?

How did you configure the expressions on the Excel...

How did you configure the expressions on the Excel connection manager?

Can you post all messages from the output window?

How did you configure the expressions on the Excel connection manager?

Did you set DelayValidation to true?

santoshkal (11/4/2014)

---

actually some SP are getting lots of time to execute so if i create a composite cluster index with all columns then it will improve or need to create...

What are the errors?