Exporting SQL2000 to Excel via DTS...and password protecting
i have setup a DTS to export data from sql to excel where the last task is an active-x component that opens and saves the file with a password...
i have the code to apply the password and can run a .vbs file and it does apply the password...if i run the whole package it continually dies on the last task...the error i get is "cannot access file.xls"...however, if i run the last task by iteself (right-click, execute task) it executes properly (applies the password)...
if i take the last task out and make it it's own package i can execute that properly...also, i have called the separate task as part of the main task and get the same error...
i cannot find a way to execute the task as part of the main DTS...
i only want to have one package to schedule/execute to fulfill this process...anybody have any idea(s) what i'm doing wrong, or what sql is not liking? or, any ideas to accomplish this in a different way? comments are appreciated...
regards,
ErikM
[1943 byte] By [ErikM] at [2007-12-20] 