when I create a connection in connection manager, I would like to use expression that uses the user variable as connection , but is there a way to generate...

Thanks a lot.

So in 1. I can do the transaction log backup during the process of reindex?

2. I do have a full backup, but it is on next day.

So you...

I ask another person to remotely into the box just I do, he can see the control flow tasks in the tool box.

Is that only settings for my visual...

I create a new package with different name. Still cannot see.

See attachemnt.

No, I still cannot see it.

Here is a screenshot in attachment

Yes, that's exactly what I see

I see Integeration service projects 4

data sources,

data source views,

SSIS packages

Package.dtsx

Miscellaneous

A new blank project

I think it is -m

is that all we need, like below:

SQLCMD -i "d:\_ssisfiles\scripts\SRR\StartJob.sql" -m

?

Thanks, is there any sample script about this?

Also how in each step to return the suceed or failure status:

1. batch file to call a sql script, something like this...

No, I don't. Package configurations will override design time defaults when you open the package. It doesn't matter if the configuration comes from a table or a file.

The only way...

so do you agree what wildh says in his post:

Running in design time will result in using the connections from the connection manager rather than you file.

Running any package not...

We use enviroment variable that points to an xml config file.

So really confused by what you said.

When you open your package in visual studio, it will look for package configurations and configure your connection managers if the package configurations are found.

This means that design time values...

This happened again the 4 th times in last two weeks. I click SSMS, and got an errro, cannot start application.

I fix it the fourth times too, by running SSMS...