Set the Delay Validation to true. It's complaining about a blank value. Delaying validation should solve it.

Two questions in one..

Your way of setting the variable should work. Try dropping the User:: part.

As for the SQL part, I use OLE DB, not .NET and you map the...

It would catch it. It would be a IO access denied or read write error.

A simple test would be to write to a UNC path and while writing, disconnect from...

Darren's example is correct. The key thing is he has selected Package as the scope. Is yours the same?

You can check this by viewing the variables pane and showing all...

It's to do with the scope of the variable.

Variables created in a container cannot be seen by parent containers.

The connection managers sit below the package so they will not be...

I've had the  same issue before. You'll have to do it manually and not use the wizard.

See BOL for the examples. It's rather easy.

Your name needs to be MyDomain.MyServername.

You cannot use just the server name.

See BOL for the exact name.

What makes you say it's the stats creation that makes it hang?

What makes you say it is hanging? Creating an index on a large table will take time. Some indexes...

You cannot migrate DTS packages. You can only save them as structured files and run them from within SSIS. See BOL for details but you'll be better off rewriting the...

Agreed. Keep files on the OS and store the path. Makes managing the files easier.

The easiest way to get a row count is by using the rownnumber component, assign the value to a variable and on post execute, use the variable. As for getting...

Check the Protection level in your package properties. See BOL for more info on that.

Alternatively, you can use a configuration to set the value of the username and password (My...

The archive attribute is set anytime the file is modified (Opened and read?)

For SQL, this would be understandable as the service would be running background tasks.

Anti virus?

Get File Mon from...

Schedule it in SQL Agent

This sounds simple enough so here goes.

If your file is already in CSV, leave it. It's simpler.

The way I understand it is you...