The "LogFilePath" specified in the code refers to a global variable the user is using in the package. You can easily substitute the code DTSGlobalVariables("LogFilePath") to anything of your choice...

There is a property of the Package Object named CreatorComputerName, which gives the name of the computer the package was created on. But when the package is saved onto...

I'm using SP3.

Then it must be something else. Let me think about this. But, I can't promise you an answer...

Here's another thought: Why don't you...

Are you returning DTSTransformStat_NoMoreRows anywhere. I remember that it used to make my task go to OnFailure. Please let me know...

Way to go, Ron

Way to go, Ron

Seeing you two fighting it out reminds me of something... Heh heh

I don't think you can... Just try doing a little bit more diggin' on the subject...

Will you be able to let me know how you have called the SP from the webpage? I may be able to give you a few suggestions in that case......

I suggest that you repost this post under the following section:

SQL Server -> Administration

Might get you more replies and solutions.

Coming to think of it, the idea seems really "correct" (That is - Once you have overcome the awe). Michael Crichton explains chaos and evolution in his books "Jurassic...

Thanks a lot

I actually don't have SQL Server 2005 installed on my machine and I tried downloading the Books Online but it's around 110MB in size...

Your question just reminded me of an Archie comic cover page headline: "Dumb Questions That Don't Deserve an Answer"

Nah!!! Was just kidding. I don't...