Recent content by lucyv

Thanks olisemalis. I think our situations are pretty similiar. Please let me know if you get this to work. -lucyv

Can someone please explain in further detail what olisemalis is trying to do? This sounds alot like a situation that I came across in the past but could not find a work-able solution. Thanks! -lucyv

Thanks again for all your help!!!

Yes I am using Transform Data Task. So I guess I cannot access the function through the Active X script? Thanks for all your help!

I am going from a text file t a table but I an to run the function on one of the columns. I am in the Active X Script Transformation window... I don't see a source tab. Thanks!!

How would I reference it... This is what I have but I am not having any luck Function Main() DTSDestination("isbn") = fn_leos_ISBNconv(DTSSourc"Col001")) Main = DTSTransformStat_OK End Function Where fn_leos_ISBNconv is the function. Thanks for your help!!

Is it possible to call a user defined function from a DTS package?? Thanks for any help!

Thanks TipGiver & Chiph. I wasn't aware of Exception.TargetSite.Name

I wrote a ErrorHandler class that passes errors into it and it displays the error message and logs it into one of my databases. In order to record the location of the error I have to hard-code the procedure/function name while calling the sub procedure. I can send you some sample code if you...

Just to let everyone know, I fixed my problem. The problem was that I could ping the computer using its IP address, but I could not ping it using its name (a DNS issue). I had my IT guy refresh the DNS database and everything works fine now. -lucyv

jebenson, It worked! It turns out it was trying to ping the computer using its name. Their IT guy refreshed their DNS database and now everything works great! Thanks for your help. You get a STAR!!! -lucyv

I believe they are pinging the PC by its name. But I will have to check on that. -lucyv

Should I recommend they check UDP and/or ICMP? If so, how would I word it without sounding like a newbie??? -lucyv

Sheco, Thanks for your suggestion. I'm almost 100% sure it is not a physical network problem for two reasons. 1) The software requires the client to log into a SQL Server database that is on their network. The PC in question does not have a problem logging into the server. 2) None of the...

jebenson, From what their IT guy has told me, yes they can ping the computer from another PC. I originally thought this was not the case because the Windows XP firewall usually prevent a PC from being pinged from another. At the top of my head I do not remember if I'm pinging the computer via...