January 19, 2007 at 12:57 pm
Hello,
In a Data Flow task, I need to copy data from a SQL Server table to a flat file destination that resides on a CD, then execute a task (script task?) to invoke the Windows XP cd burning software to burn the file to cd. I have come across a couple of ideas. One idea is to use the ICDBurn Interface;
http://msdn2.microsoft.com/en-us/library/ms646705.aspx
The other idea is to use the IMAPI IDiscMaster::RecordDisc Interface;
http://msdn2.microsoft.com/en-us/library/aa365403.aspx
As far as I can tell, the ICDBurn approach would cause the Windows XP wizard for burning CD's to open, which I don't want. Are there any other ideas out there about how I might accomplish this? If IDiscMaster::Record disk is the way to go, do you know of example code that I can look at?
Thank you for your help!
cdun2
January 22, 2007 at 8:00 am
This was removed by the editor as SPAM
January 22, 2007 at 1:29 pm
You may want to simplify this a bit by splitting the two actions. There are command line utilities that will copy a file from your hard drive to a CD (burning it). I seem to remember NERO even having this feature available. Then your SSIS package would only have to write to a file residing on your hard drive and then execute a batch file or command line to do the burning.
January 22, 2007 at 3:40 pm
I did actually find a handy utility that is supposed to work with a batch file to do the burning. I haven't had time to look into it yet, but the application is called CreateCD.
Thank you for your help!
CSDunn
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply