I want to create a scheduled program which will run everyday at partocular time, hit some SOURCE database and store the data in DESTINATION database.

- Is it possible using SSIS?

-...

I am new to SSIS. Can you pass me a good link to create SSIS packages to move the data?

Thanks in advance.

Here is some more description..

I have a job that run overnight. It fetches the data from remote server to , say my server. I can't backup whole database since i...

I read the same. So is there any solution to my problem?

Thanks and Regards,

- Prash..

Error msg is

Msg 208, Level 16, State 1, Line 1

Invalid object name 'MySourceDatabase.dbo.MyTable.

When i used this commands

...

I have to use hudreds of select queries. So i can not create Synonyms for every table.

I tried creating a synonym for database object

i.e.

Create synonym...

Thansk a lot everyone for reply. i will surely cosider Synonyms. Is there any other option?

Thanks..

Regards,

Prashant Chavan