if you go into Studio Manager > Server Objects > Backup Devices right click on the Display_Backup, goto Properties > Media Contents, you will see that the back up with...

i am failing to understand your requirement, do you want columns name to appear in the rows?

oops too many programming languages. its actually the CASE statement

check in BOL on usage but its pretty much the same as an IF...ELSE..

A fellow SQL Kung Fu fighter.

probably 4 graphs

the problem with your script is that you are actually specifying a non existant backup device hence the error message. What you probably want to achieve is...

change

User ID=sa;Password=titi

to

Integrated Security = SSPI

you can customise your transform and put the changes in your script or instead of importing direct from the table you can write a query in which you do the...

try installing the latest service pack

if that fails then consider splitting your package

what is the error message that it gives you when it fails when doing the import using the wizard?

an alternative is to write your own application using c#, vb .net...

change your code in the second part

[PosactAReader = oledbcmdCheckAdjustment.ExecuteReader()

If AdjustmentReader.Read() Then]

to

[AdjustmentReader = oledbcmdCheckAdjustment.ExecuteReader()

If AdjustmentReader.Read() Then]

you can overload your webservice to accept serialised xml then i think you can store it as a variable in the script. how big is your xml output?

create your column 1 in the destination table with identity specification (is identity) set to yes. You can use the import wizard in the BI Studio to port your data.

have you tried using table hints e.g. WITH NOLOCK

clustered

you can check on the index (+) thingy on the table in QA