hi cozyroc,

that setting is the solution for this i think.. now its working.. and the cannot create activex component error is due to That COM object only i think.. after...

using isnull function

hi cozyroc,

my friend proposed this idea.. wil it work..

In run type

dcomcnfg.exe >>> on the left pane.. ther will be component services.. click on the '+'>>> my computer>>>COM+ Applications>>>Microsoft.SqlServer.MSMQTask… right...

thanks ramesh for your reply

hi wen i opend my package the following pop up appears.

do i need to install COM object. wat is that?

unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface...

hi cozy roc,

as per your guidence last week i created proxy account and it ran successfully. but now its not working. i'm getting mad. wat is the reason for this....

hi all,

i have used two script tasks. one for writing something into an excel sheet and another one is for reading some data from the excel sheet. i disabled the...

hi cozyroc,

writting data into excel sheet doesn't work.. so now i changed my proceedings.. it is throwing many errors.. i think writing the excel sheet through scheduling is not the...

go to event handlers tab

add a execute sql task

before that create a table[error] with following column names

error name, error code, task failed, time of execution, etc

in the execute sql task...

in control flow add

1 execute sql task and

1 data flow task.

in execute sql task write ur procedure to delete some rows.

in data flow task add one data source and OLEDB...

i think it is with the security issues.. the solution is to create a proxy account.. follow this link to create a proxy..

what exactly you want to know? can you explain little more in detail?

hi cozyroc,

i created a proxi account and now it is working.. thousands of thanks for all of you people..

but script is throwing pop up's some times like want to save...

hi,

i did not try for proxy account.. actually if i disable the script task, then im able to schedule the package. it is running smoothly. but the problem occurs with...

hi,

you are absolutely correct... i'm trying for excel automation only.. how can i check that i have enough permissions or not.. wat i have to do.. now im working with...