This article sums it up rather nicely:

Import data to Excel sheet's specific region

You could use named ranges in the Excel destination to write to different parts of the Excel sheet, but you'd need to know the number of rows of each extract...

IgorMi (11/26/2013)

---

Hi,

These settings I've done on a client machine with RAM of 128 GB were following:

max server memory set to 112 GB

min server memory set to 64 GB

My suggestion...

If all of the tables have the same format you can append the results together using UNION ALL (either in the source query itself or in the SSIS data flow).

If...

What if you run pkgA directly on the server, without pkgB starting it?

AShehzad (11/26/2013)

---

I have created a new login with public server role. Just added it SQLAgentReaderRole in msdb. Again i am able to start/stop the agent with this login. So could...

SSIS doesn't really support this natively, but you can use BIML to read the metadata from the Excel file and create the data sources for you.

Stairway to BIML[/url]

You can use DDL triggers for example:

DDL Triggers

or you can use policy based management:

Administer Servers by Using Policy-Based Management

PBM has its disadvantages though. If you create a rule for your...

No problem, glad to help.

I'm not 100% following regarding the set-up of your package.

What is the "next step"? Another transformation in the data flow? Another package called...

That question is hard to answer without more information.

This article gives you some pointers:

How much memory does my SQL Server actually need?[/url]

I don't think this is the expected behaviour.

Are you sure the user doesn't have other permissions?

You never ever execute the code inside @qry.

You just store some string in it (which happens to be a SQL statement, but that doesn't matter).

Then you check if @qry is...

Interesting question, thanks. Keep it up!

What if you try the following?

\\computername\d$\SSRS\Images\Help.pdf