Can I resume an interrupted disk image done with dd?

Question

How can an instance of ExecuteSQLTask (Microsoft.SqlServer.SQLTask) be added to a DtsEventHandler?

Building the ExecuteSQLTask is straight forward, but adding it to an event handler may require some kind of casting.

I prefer not creating it this way, because I cannot add parameter mapping to the result set this way. Unless there is a way to add parameters to the Executable below?

     DtsEventHandler ehOnError = (DtsEventHandler)package.EventHandlers.Add("OnError");

 Executable execOnError = ehOnError.Executables.Add("STOCK:SQLTask");
            TaskHost thOnError = (TaskHost)execOnError;
            thOnError.Name = "sql_Exec_LogMessage_Error";
            thOnError.SetExpression("SqlStatementSource", "@[User::sql_LogMessageError]");
            thOnError.Properties["Connection"].SetValue(thOnError, cmag.ID);
// Parameter mapping?

Solution

I guess you could use the dd options seek and skip with the same numbers.

Another way would be to use the program 'pv' which can simply pipe data, but can also rate limit that, so then you might control your CPU/HDD temperatures.

Comments

[Admin]

Well, the problem is solved. Although overheating was harmful, largest performance increase was achieved with bigger block size/bs (several megabytes). Anyway, skipping/seeking helped too.

[Admin]

I get exactly the same amount of info copied. root@fe:/dev# dd\n if=/dev/sdb of=/dev/sdc\n dd: reading `/dev/sdb': Input/output error\n 48583648+0 records in\n 48583648+0 records out\n 24874827776 bytes (25 GB) copied, 5235.18 s, 4.8 MB/s\n I was thinking about using the -noerror option. Does that make sense? Thank you.

[billinkc]

I'm not following you. Or rather, I see what they're doing on the referenced article but not following what you are attempting to do that the referenced article does not. Could you edit it?

[user81420]

So, if the command I've used was: sudo dd if=/dev/sda5 of=/media/Data1/clone.img then now I should use sudo dd if=/dev/sda5 of=/media/Data1/clone.img seek=NN skip=NN where NN is a number corresponding to 25 GB? Thank you, that makes sense.