Thanks it worked.

Thank you guys.

Resolved this.

Set the variable path wrong. Use message boxes to view variable values at run time.

If you are able to transfer manually ,try using passive mode on ftp manager. Enable the logging for the client you are using to transfer manually for any additional settings.

I was able to achieve this using the arguments and setting the working directory to the exe folder

Changing the order of the parameters resolves the issue.

I finished the testing on this and it worked as suggested by Gila Monster. Thanks. I used a similar to this.

USE master

SELECT name, physical_name

FROM sys.master_files

WHERE database_id...

Thanks, I will try this.

I previously had to change the DOP settings. For OLTP MS recommends DOP to be 1. I think you should monitor the setting usng DMV's for more than one value...

Thanks Nevyn.

I found this helpful link.

http://www.simple-talk.com/community/blogs/andras/archive/2007/09/14/37265.aspx

I resolved it. Had issues with my VMNet and network adapter.

I faced the same problem and it was the space after the package name which resolved it.

Thanks.

Thanks for the reply.

I understand the metrics would be different for both the instances (OLTP vs OLAP)

Is there a range of good metrics for OLTP is what I trying to...

Reinitialize the subscriptions.