good luck

http://www.sqlservercentral.com/scripts/contributions/1028.asp

for tempory table it will be better to use insert into than Select * into. Eventhoguh it required you to create temp first, but it will be better in performance...

DO you want back to be create in your pc

if so, share a folder in your PC

Map it from the remote server

make sure your agent should have access right...

YOu can add activex script object.

here is an example

http://www.sqlservercentral.com/columnists/dasanka/themultiphasedatapump.asp

an also you will find plentry of examples in http://www.sqldts.com

You can use Image data type

Currently in there is relationship pane in which you can't do this type of releationships

thankx for the update, I have done that way, But I think there should be another way of doing it

Corrections are done. Title caption needed to be corrected.

I don't think u can to this in simple way

other wise

1. Make a data backup of the existing table to temp table

drop the table

recreate the table again

put data back to...

Major mistake!!!

will be corrected

Sorry for the mistake. thankx for the information

did you try to get any information from the Index Tuning Wizard

Increase the disk space of the TempDB

right click the tempdb, go to properties

at the data files tab,

is there any difficulty in using Datediff function in the DTS