As of CTP 2.x, we can not set filter on the records to be moved to Cloud. Complete table will be archived to cloud. It is expected that the RTM...

My understanding too is, it will be shipped with Enterprise edition only

Yes Erik! Both the servers are residing on Windows 2003 server.

The script file directory is valid. The failure is not happening everyday for the same database. The behaviour is totally...

Thanks for the reply..

The issue was resolved. The procedue for changing the names in disconnected mode is -

Remove workflow

Rename the tasks

Redo the workflow.

After this, the workflow worked.

--Suresh

No, these packages run as local packages on sever.

Thanks,

Suresh

Hi SR

WHen the entire package has been executed as whole, it fails with the error given. When the particular task is executed individually (manually), it is successfull.

Thanks,

Suresh

Hi Lucky,

Thanks for your reply..

Here is Source is a SQL sevrer database. We use 'Copy SQL Server Objects Task' to copy the SQL Server Database from one server to another...

Thanks Kenneth for your reply..

I am rellay facing problem under situations where I have a temp table with some data. I am trying to create an Unique Clustered Index on...

The best thing to move/deploy DTS packages on other server is - to save the package as a structured storage file and transfer the file to the destination server. But...

Here, the problem is, the NT job on another server. we have READ-ONLY access to this. So, somehow we need to findout the status of this NT batch job and...

Check the location of the DTS Package on the new server. Th elocation should be identical to what is specified in the job step

MainTbl:

RowIDCreatedCreatedByLastUpdatedLastUpdatedByAssigneeStatus

2-IHW812003-09-03 14:10:15.000HARRY2003-09-04 22:02:52.000LUKELUKE3rd Party Hold

AuditTbl:

RowIDCreatedCreatedByFieldOldValueNewValue

2-IHW812003-09-04 22:02:52.000LUKEStatusNew Mail3rd Party Hold

2-IHW812003-09-04 21:47:10.000KENStatus3rd Party HoldNew Mail

2-IHW812003-09-04 19:19:47.000LUKEStatusNew Mail3rd Party Hold

2-IHW812003-09-04 16:55:36.000DICKStatus3rd Party HoldNew Mail

2-IHW812003-09-04 16:55:36.000LUKEStatusNew Mail3rd Party Hold

2-IHW812003-09-04 16:47:40.000DICKStatus3rd Party HoldNew Mail

2-IHW812003-09-04 16:05:46.000LUKEStatusIn...

Hi David

We dont have privilege to add an identity column to the AuditTbl. We have read-only (SELECT) permissions. We takethe data from the MainTbl & AuditTbl and process on our...

Thanks 'jpipes'...

It is worked for me.

Thanks Frank.. Actually, I was looking for pure SQL soln.

Regards

Suresh

Thanks Frank....

It did worked great. Now, I need to know Nth highest salary from the given values. Here, we may have to use recursion technique. Any clue on this?

Suresh