Hi Nicholas,

Thanks for the help. I tried by setting the package properties as fail package on first error. it is working now.

Thanks,

Sridhar!!

Yes, the second package is showing a failure but still the third package is running. I don't know how to set packages as steps in a job.

Thanks,

Sriidhar!!

Thanks Greg. I have created the DTS package now. But I haven't tested it. I need to test once the new data comes. I will ask you if any problem...

Hi Greg,

Thanks for the reply. The problem is the excel connection would be different. that is the excel file name would be same but the sheet name...

Hi,

I have one more question related to this...I need to do several DTS Transformation tasks and Execute Sql Tasks...

The order would be like this...

SqlConn--->ExcelConn--->ExecuteSqlTask

SqlConn1--->ExcelConn1--->ExexuteSqlTask--->ExecuteSqlTask--->ExecuteSqlTask

SqlConn2--->ExcelConn2--->ExexuteSqlTask--->ExecuteSqlTask--->ExecuteSqlTask

I have so many of...

Hi,

I will try that. Thanks to both of you for the Help.

Thanks,

Sridhar!!

Hi Greg,

Thanks for the reply. The problem is they should not be executed in parallel. They should be executed in series. i.e. after first data transformation and...

Hi Greg,

Thanks for the reply.Each Data Transform Task and Execute SQL Task are unique. Each will export the anomalies of a table into the excel sheet...

Hi,

Now I got a new problem. I am able to update the excel sheets using the name ranges in excel sheet. Now I have to do like...

It doesn't take much time. It took around 1 minute.

Thanks,

Sridhar!!

Thanks alot. I tried like the above and it worked.

Hi Bellis,

Thanks for the immediate response. Can you please post the sample script to execute more than one sql statements inside active x script. right now i'm...

Hi Bellis,

The problem might be it runs slow. one problem i got when tried to run the script you sent is the connection timed out problem. what should...

Hi Bellis,

Thanks for the reply. If i use active scripts for creating connections, I think the problem would be bad. Am i right?

Thanks,

Sridhar!!

Thanks for the reply.