Hi,

Check if the below link works. It has an idea to run the package using DTExec utility.

http://blog.davyknuysen.be/2008/08/26/import-excel-files-with-sql-server-integration-services-on-a-64-bit-server/

Suresh

thaks Dan! I will continue with the virtual labs.

All of your suggestions were helpful. Thanks all again!

-Suresh

Thanks all guys for your time and valuable suggestions. SSC group always helped me with good suggestions. that's great!

I would say that I am interested in DBA work though I...

Thanks Sharath for your comments.

SSC Gurus, please help me with your ideas.

Suresh

Thanks Grant & Mike for the valuable suggestions!

Suresh

Thanks for the reply. I can understand the need to move to Try..Catch instead of @@ERROR. How ever, I am NOT able to understand what you mean by the below...

Thanks for your thoughts.

How ever, I am wondering how come "Pantom Reads", "Non Repeatable Reads", "Lost Updates" are handled if we commonly use "Read Commited" Isolation levels.

Looks like...

Thanks guys for the valuable replies.

Elliott: In your reply, you have mentioned as below.

They sometimes change it at a process or sproc level to handle specific cases.

Does it mean...

Thanks a lot Elliott..

Sorry for the delayed reply. It took some time for me to re-think of this tool and now with using your sample package, i am able...

Thanks Jason & Pablo for the clarification.

Suresh

Thanks Jason.

It was one of the questions I got when I got assessment call in my company (our company does assessment for employees every year).

One more thing. Is...

Thanks for your time Jason.

The question was more in terms of understanding the differences between Implicit, explicit and ref cursors.

So, Do you mean implicit cursors are deallocated automatically...

Thanks Elliott for pointing out the issue.

I have updated the For each loop to directly refer pkg.Connections instead of declaring new Connections obect.

For Each strConnection As Microsoft.SqlServer.Dts.Runtime.ConnectionManager In pkg.Connections...

I have tested by commenting the whole For Each block and could see my code working. When I uncommented it and debugged, the error originated exactly at FOR EACH statement...

It throws error when running "For each" line.

Thanks for your time..

Suresh