Error whilst opening the file system object sql server

The FSO allows you to manipulate and shred path names, to copy, move, delete or create files or folders. You can check for their existence or get a number of objects and collections. These are…. This provides information about a logical drive physical, or network attached to the system, such as its share name, type, total space, and how much room is available.

This will give a list of the physical or logical drives attached to the system and includes all drives, regardless of type. Removable-media drives need not have media inserted for them to appear in this collection. This will allow you to create, delete, or move a file, and to find out the file name, path, and other properties.

It has a method to open a file as a text stream. The Folder object has methods that allow you to create, delete, or move folders. Also there are several properties that return folder names, creation date, paths and so on.

All of these methods, properties and collections are readily available from Books on Line and W3Schools. We end up with a rather more esoteric procedure that we will throw into the pot just to show what can be achieved with FSO. It will take any file and format it prettily and check for any errors. It is an example which illustrates several techniques and shows how one can integrate a DOS application. EXE file. It is a remarkable tool that combines a Lint and a prettifier. It has now been adopted by an enthusiastic band of people who work through W3C and SourceForge to maintain it.

It also requires you to set the configuration that I have embedded in the source of the stored procedure, but which you can supply as a parameter to over-ride the defaults I have chosen. Once everything is in place, all you have to do is to supply the input as a string and the spHTMLtidy stored procedure will put the tidied version in the output string and fill another string with all the warning and error information.

SQL Server is not designed as a means of file and directory manipulation, and for most of the time it is not the appropriate place in an application to do it. However, now and then in the life of a DBA or database developer, it is nice to have the functionality to hand and, for this sort of work, the File System Object is ideal.

United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. Getting started with SQL Server. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need. Who are the certified experts? How quickly will I get my solution?

We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed. Plans and Pricing. Contact Us. Certified Expert Program.