No. SSIS does not allow for meta data changes at runtime. i.e. you cannot to inplace conversions like that.

You must get the source to do it. It is faster, better,...

If you do a DIR X:\ in cmdshell, what does it return? (Assuming x is an invalid drive)

_just_ incase, you are aware of SQL returning a NULL as the last...

one week in and about to build custom tasks... Ouch 🙂

So long as you have a basic grasp on vb.net or c#, you should be fine.

As for asking questions, this...

Tried the web services task?

If it does not suit all your needs (as it did not mine) you can create your own custom task. Fairly simple yet limitless in what...

You can use SOAP from within SSIS. You can then use SSIS to load the files (You already doing that though)

If you _really_ wanted to do it from SQL as...

What options do you have with BCP? Query possibly?

If the tables have different schemas then no, you cannot use a loop. SSIS does not cater for runtime changes.

If however you have 1000 of the same table, then you...

You are returning a xml node - try using a object type variable.

You can accomplish what you are trying to do. That is what SSIS was built for....

A forloop is not needed though. You cannot loop over all the tables and extract...

Use a proxy account in SQL?

Create proxy account, use it to run job / package whatever.

see BOL for proxy accounts.

How lucky can you be...

net use \\MyServerName\SomeShare /u:DomainName\UserName Password

Then, anything run in the same context _should_ be able to connect.

When you done, it's a good idea to run net use...

There is a way you can do it with net use.

Using cmd (or xp_cmdshell) you would run net use \\myuncsharename /password (or somethign along those lines :w00t:)

I will look for...

No.

You can upgrade 2000 (not my favorite thing) and then it replaces the instance.

You can uninstall 2000 after detaching the databases and install 2005.

You can install alongside as a new...

Unless you have logging turned on, I do not believe there is a way to interrogate a package while it is running. You would have to watch dtexec.exe or dtexecui.exe...

A few of the CTPs broke 2005 badly. Also, it is unlikely you would be able to use the database with 2005. I doubt (not sure though) that it is...