Thanks Narayanan,

Am having another condition like id1 column in the same table which doesnt have identity column.. but i need to insert values for ex.

source db

id name

-----------

1 ...

Please check my blog article,

http://venkattechnicalblog.blogspot.com/2008/05/migrating-data-from-multiple-source-to.html

Tegards,

Venkatesan Prabu .J

I am new to ssis and wish to know the steps to proceed this.

I need to transfer the files from source FTP to destination FTP without any transformation thats it....

You have asked for code snippet right below is the code sir

USE

[master]

GO

CREATE

LOGIN [vp] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

GO

EXEC

master..

   Its advisable to install your sql server in the default drive itself. For the data files your master and other databases,  Its based on the processor which you are...

Really a cool problem, ok lets first analyse the problem first.

SQL Server usually takes more time for executing a query for the first time and it will take very less...

Hi Friends,

  EXEC sp_configure 'show advanced options', 1

GO

RECONFIGURE

GO

EXEC

sp_configure