This would have normally required you to code in Javascript
or other scripting or programming language to access the properties and methods
of the DOM [Document Object Model]. Visit W3C (http://www.w3c.org/xml/) to
learn about XML, and how to code an XSL file.
Creating a SSIS Package to
Access Folders and Files
Access to host computer's folder/file system is an important desired feature in any
programming language. Visual Basic provided this functionality to access folders
and files (that means virtual directories on the server) with the FileSystemObject
object. In Visual Basic, you would have used the CreateObject ("Scripting.
FileSystemObject") to create this object. Once created, you would then use all its
properties and methods.
There is yet another method, the early binding method, that declaratively creates
this object by referencing the Microsoft Scripting Runtime library (scrrun.dll) to
instantiate a new Scripting.FileSystemObject. If you would like to understand the
FileSystemObject take a look at this http://www.w3schools.com/asp/asp_ref_
filesystem.asp tutorial. Although access to folder and files are simplified by the
FileSystemObject, caution must be exercised as viruses can enter when the file/folder
structure of the computer are given easy access.
The File System Task in SSIS can do a subset of the operations which were called
"methods" in Visual Basic's FileSystemObject (http://msdn2.microsoft.com/
en-us/library/z9ty6h50.
Pages:
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141