For the deployment issues...

Make sure you have the correct URL where the report server lives. I have ran into this before and my problem was in the Solution Properties I...

Catalog table to be specific...

In the 'data flow' editor add the 'Derived Column' component between your source and destination. There you can add new columns as well as perform some clean up operations on...

Penny,

I believe when you set it up the job name should match that of the DTS package and it usually comes w/ the DTS Package name in the description of...

For this I've used a function I found on a technet forum from Bruce L. (MVP) which parses the values in the string and returns a table that you join...

If you are putting the database on a different server I don't imagine that it would matter what edition (Standard, Enterprise, Dev) you installed the web components from...

I am actually...