dbTalk Databases Forums  

Error opening datafile: filename, directory, or volume label syntax is incorrect

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


Discuss Error opening datafile: filename, directory, or volume label syntax is incorrect in the microsoft.public.sqlserver.dts forum.



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

Default Error opening datafile: filename, directory, or volume label syntax is incorrect - 01-06-2004 , 12:05 PM






I receive this error message when I try and run my DTS
package:

"Error opening datafile: The filename, directory name, or
volume labe syntax is incorrect."

I set the file name property of the Text File (Source) to
a valid file, but when I run the package and it returns
the above error message, it sets the file name property
to <not displayable>.

Does anyone have any experience with such a problem? If
so please help!!! Thanks

Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: Error opening datafile: filename, directory, or volume label syntax is incorrect - 01-06-2004 , 02:40 PM






In message <0b7701c3d47f$b2c38900$a601280a (AT) phx (DOT) gbl>, Jeff Borden
<anonymous (AT) discussions (DOT) microsoft.com> writes
Quote:
I receive this error message when I try and run my DTS
package:

"Error opening datafile: The filename, directory name, or
volume labe syntax is incorrect."

I set the file name property of the Text File (Source) to
a valid file, but when I run the package and it returns
the above error message, it sets the file name property
to <not displayable>.

Does anyone have any experience with such a problem? If
so please help!!! Thanks
How are you running the package?
Is this a remote path?

If scheduled check out -
http://support.microsoft.com?id=269074


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org



Reply With Quote
  #3  
Old   
Jeff borden
 
Posts: n/a

Default Error opening datafile: filename, directory, or volume label syntax is incorrect - 01-07-2004 , 10:11 AM



It throws the afforementioned error when I call it from
ASP or from the Enterprise Manager.

I'm executing it from asp like:
Set oPkg = Server.CreateObject("DTS.Package")
oPkg.Execute

But the fact that it throws the error from EM on the
server is most alarming. I just returned from vacation
and I have no idea what could be causing this.

The file names do exist on the local server, but when the
package is run it sets the file name property to "<not
displayable>"


Quote:
-----Original Message-----
Darren,

Your message didn't post. Could you repost?


-----Original Message-----
I receive this error message when I try and run my DTS
package:

"Error opening datafile: The filename, directory name,
or
volume labe syntax is incorrect."

I set the file name property of the Text File (Source)
to
a valid file, but when I run the package and it returns
the above error message, it sets the file name property
to <not displayable>.

Does anyone have any experience with such a problem?
If
so please help!!! Thanks
.

.


Reply With Quote
  #4  
Old   
Jeff Borden
 
Posts: n/a

Default Re: Error opening datafile: filename, directory, or volume label syntax is incorrect - 01-07-2004 , 01:56 PM



I'm running the package from asp. When that didn't work, I ran it from Enterprise manager and that didn't work. I am completely baffled as to what causes this! Is it a permissions issue? I went away to vacation for a couple of days and now it no longer works. It worked magnificently before. They had some linux guys come in and work on the linux boxes, but I don't think that'll affect this... Your thoughts are very valuable. 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.