Why not use a linked server using a connection string that supports mirroring?

http://www.connectionstrings.com/?carrier=sqlserver2005

Have not tried it though but the connection should switch over without you knowing.

Variable values changed at run time will not reflect in the variables pane. is that what you are seeing?

Nope - if something in the config file is not found in the package, it reports an error. I agree, it should be a warning, at most or configurable. Because...

If you using a normal flat file destination, the file length would not be a problem.

From the data you gave, I would say the weird contatination is a problem. Stick...

ok then, explained:

http://msdn2.microsoft.com/en-us/library/ms190476.aspx

With the help of a learned friend, it was pointed out.

I guess initial reaction was correct

I'll be dammed. I just hooked a memory key of someone and you are right. Even worse, my DBCC comes back clean.

Here's something though: I did the test, all is...

You can use a cross to to "explode" your data.

Consider table A and Table B. A has 10 rows, B has 3.

When cross joining them together, your result will be...

you could use a execute process task and merge using dos but that seems like a bad way to do it.

Why do you want to do this anyway? Can you...

What exactly is the data format? If you asking can SSIS parse a web page....

If the data is actually a text file that IE is rendering, then you can use...

I'm not sure there is a native way to do this as the jet drivers have the "first row is header" switch and I don't know that you can change...

The 3 GB would be used up by the OS, other processes running on the server etc. Like Sugesh said, see the SQL counters and see exactly what SQL is...

Another thought, this is _really_ dodgy. Data integrity is of paramount importance. If a server could loose a disk and continue running not reporting anything, no one would know about...

I'm not sure this is correct though. Any modification to data must be hardened to the disk subsystem before SQL says all is well. The subsystem either being the physical...

The original poster does not mention the source. I am guessing it is SQL. If so, it's weird SSIS got this wrong as it uses the mapping document in the...

At a "here we are at 40000 feet" level, yes. Pull the drive out (It'll be the one with the flashing red light) and plug in the new one.

All...