Also, for the best speed you should use BULK INSERT instead. It's much quicker than BCP for importing data.

What sort of object is 'orgdetail' ??

Probably more of a VB.Net question than a SQL question. I believe you can specify different sorting and filtering when you use a dataview.

From the information you've posted I'd say the length of the ShipCountry field is shorter than the data you want to put into it. "DestinationSpain" is 16 chars long so...

Instead of attach, you'll probably want "Restore" from the backup

Take a look at Restore Database in Books Online.

You should also note that Windows XP has a limit of 10 concurrent network connections.

Just use the inbuilt DateTime transformation that comes with DTS. No need to fiddlw with ActiveXScripting.

See my reply over here http://www.sqlserver.org.au/forums/ShowPost.aspx?PostID=659#660

For indexed views, take for example your classic Product hierarchy. In a normalised OLTP system the tables might look like this,

Product

ProductID, ProductName

ProductCategory

CategoryID, CategoryName

ProductSubCategory

SubCategoryID, SubCategoryName

Normal datawarehousing technique would have you bring...

Rather than referring to the fields in the dataset, use the ReportItems collection in the SUM.

EG: Sum(ReportItems!Balance.Value)

You know ... I suggested ages ago that the "Anything that is NOT about SQL" forum should be excluded from the posts counts

Oops ... should note that this is C# code

Currently of all the parameters in our repotrs we only need to specifically set one per report. Most of the other parameters use system defaults like current date/time/user/etc... Hadn't really thought...

Unfortunately you can't. I fell into the same trap and after losing all my wonderful annotations documenting what the package was doing, I've never done it again.

How about posting to a more appropriate forum than "Question of the Day (QOD)" ??

Well I checked Books Online for you and found the you can't rollback the restore command.