You cannot change the meta data of a data flow at run time.

Why not have a loop that loops over the sheets in to file, each loop will execute...

Not sure why you are using VB. Why not use the send mail task? You can then use an expression to add the attachment.

You don't need a script task, nor do you need to enable or disable tasks. In fact, I don't think you can do that at run time. Use an expression...

That's the way to do it. Have a environment variable which tells SSIS where your config files are. That way, deploying a package to a server is simply copying it...

What makes you say it is always -1? Remember, SSIS during runtime, will not update the variables pane to reflect the new value of the variable. For this you need...

Firstly, the SQL Server Destination component will only connect to a SQL instance running on the same machine as SSIS so you cannot connect to another server.

Secondly, you cannot change...

There will be a pause as the driver workouts that the original principal is dead and fails over to the new principal.

Nothing you can do about that...

But as you are...

There's no limit to the text file you can create other than OS limits. I've just created a file with 1 million rows. no problems. Really long data types as...

There are many advantages to SSIS over DTS and even more articles on google about it so I won't bother mentioning them here. Except the pipe line...

On to your second...

Come to think of it, rather use a script component as a source and read the file as a structured file, which it is, and build your output rows using...

Should be to difficult.

What delimits rec 1 from rec 2? Just a normal carriage return?

I would say use a flat file source, no column delimiter.

Then using a script component, you...

There you go, test the linked server I cannot say I know what the interals do but by the name and BOL, it...

As a thought...

You could be a little cleverer and check the state of the mirror. This would be the same as above but a bit cleaner.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/a7b1b9b0-7c19-4acc-9de3-3a7c5e70694d.htm

If you want to see the values, use a watch window. From debug menu, select watch. Drag and drop a variable into it.

SSIS has two environments: Run time and design...

Doh. That would happen.

Sorry, you got me now. Off the top of my head, I have no idea and I don't have a mirror at work.

A dirty idea:

BEGIN TRY

...