There seems to be some missing characters in your code can you please send me the actual code.

Thanks

Murali

Create a SQL Job and use the command DTSRun to execute the DTS package and schedule it .

Thanks

Murali

I have used MICROSOFT COMPRESS OPTION to compress a 3 GB file it seems to be working fine.

Murali

1. Open the project file with extension .o2ssproj in the folder on the server

2. Select Reconnect to oracle

3. Select Reconnect to SQL SERVER

4. Select the Schema node on Oracle metadata...