dbTalk Databases Forums  

Unspecified error - Please help!

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Unspecified error - Please help! in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ruben
 
Posts: n/a

Default Unspecified error - Please help! - 03-16-2009 , 02:44 PM






Hi!


I'm trying to execute a dts in sql server 2000, in my dts I'm openning
a text file with Scripting.FileSystemObject, this is my function :

function ReadFile(pathfilename)
Const ForReading = 1, ForWriting = 2
Dim fso, f
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.OpenTextFile(pathfilename, ForReading)
ReadFile = f.ReadAll
end function

the file is not too big, but when is executing this line: "ReadFile
= f.ReadAll" the dts gives me the "Unspecified error", any idea? It
happened to me log time ago, I remember that I registered again one
dll to fix it but I don't remember witch one.

Thank you.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.