I would imagine it might have something to do with access.

Can you run xp_CMDShell 'MD C:\usr\xxx'

Does it create the directory?

If you run the oSQL from CMD with the asme syntax,...

None.

Well, none to run your package.

Any connections in your package will use their authentication.

So if your package is connecting to SQL using NT Auth, it will be using the context...

Would the UserName and password not be for packages saved in MSDB only and not files?

If you omit the parameters, does it work?

SQL is most likely giving up with a decent plan and using a lot of parrallelism due to poor indexing.

What does the query plan look like? Some table or index...

In the advanced editor, if you go to column mappings and click the Refresh button, does that do the trick?

Failing that, it could just be some corruption in the component....

You could use a combination of xp_CMDShell and oSQL to execute the file.

Another option would be, and I have not tried this, to use openQuery to load the contents of...

Well said

"Something as simple as a flaw in a clustered index design could kill all of the performance gain you might get with RAID 10."

Have you looked in BOL?

In BIDS, go to Menu > SSIS > Configurations.

Enable it and add new. Go through the wizard and from the tree, select properties you want to...

SSIS is a very steep learning curve. Worse if you knew DTS well.

The book you mention is well worth it and helps a create deal...

I am not aware that you can do that.

You best bet is then to create a custom component and call that.

Or, create a DLL and use that from withing the...

There are many articles on custom components on the net. You options would be to use a script task and VB.NET to unzip stuff. Again, there are more than enough...

If you use a config file to set the passwords at run time, does that help?

http://technet.microsoft.com/en-us/library/ms141747.aspx

You should install SP2 for many reasons.

A package will not save sensitive information such as passwords.

Your best bet is to use a config file to set the passwords for the...

It's the mapping SSIS uses. There is a XML file in the SSIS root which hopes the data type mappings. (Don't fiddle with the file)

You can open up the advanced...

Have you remapped the source manager?

If you use a data viewer, what columns exist in it and what are the values in the rows?