if anybody has the document, can you please provide me ?

Windows 2008

I need to move only some tables to other data file which is on same file group.

Not the whole data file.

Thank you for your replies.

is this possible, If the both data files on same file group and need to move from one data file to other datafile ?

Thank you for the reply.

If it is SQL Server agent services instead of SQL Server services ?

Hi All,

Now the issue got resolved.

Thank you all for the help.

It was due the small mistake in the script.

I have added

USE DBNAME

which is not correct.

I have removed it and...

I have added the data viewer and executed the package but nothing is displayed.

I have created data viewewr, but didnot find how to proceeed to check the data viewer.

Please find the attachment.

As many Datasources as source instances.

connection manager.

rhythmk (7/5/2012)

---

Raghavender (7/5/2012)

---

We have different instances on those we have to run one SQL script, and the result to be stored in another instance.

This is the thing I am looking...

We have different instances on those we have to run one SQL script, and the result to be stored in another instance.

This is the thing I am looking for.

Otherwise please let me know how to do the below scenario using SSIS:

I have a query which need to be run on different instanceas and the result to be stored...

Sure, I think its better to compare using linked servers.