|
|
 |
Error : When I try to backup to a Network share
|
| Total Hit (2875) |
I get the following error message: «b»"Can't open dump device ... device error or
device off line. Please consult the SQL Server error log for more details."«/b»
«b»«u»Resolution:«/u»«/b»
To perform SQL Backup on network share SQL Executive service needs to run under an account that has permis
....Read More |
Rating
 |
|
|
|
How do I enumerate tables in an Access Database
|
| Total Hit (1161) |
If you need to enumerate the tables in an Access database, the easiest method is through the ActiveX Data Objects Extensions for Data Definition Language and Security. The ADOX library, as it is better known, can be used just like other COM objects from within ActiveX script, such as a task or workf
....Read More |
Rating
 |
|
|
|
Working with files and the FileSystemObject
|
| Total Hit (1110) |
The ability to work with files gives us great flexibility in how we use DTS. It allows us to add some intelligence into a package, and cope with unexpected situations automatically. The key to working with files is the Scripting Run Time as this gives us the FileSystemObject, which can be fully expl
....Read More |
| Rating
|
|
|
|
How do I open a file package or template
|
| Total Hit (945) |
In the save package dialog screen there are several Locations available. The Structured Storage File option is useful if you wish to keep the package as a file, perhaps so that it can be added into a source control repository, or for manually copying to another server or transfer media. Whilst it is
....Read More |
| Rating
|
|
|
|
Create an Access Database
|
| Total Hit (973) |
When exporting data to a text file, if the file does not exist it will be created, or if it does exist it will be overwritten. In contrast, when exporting to an Access database the file and table must exist already. This article will show you how to create an empty Access database ready to receive y
....Read More |
| Rating
|
|
|
|
Open File Dialog Custom Task
|
| Total Hit (1138) |
If you run packages manually and want the ability to select a file through a GUI, this is for you. This is a simple custom task that pops up a standard windows open file dialog box when executed. It assigns the chosen filename to a global variable for use within the package.
....Read More |
| Rating
|
|
|
|
Coping with text files and abnormal column or row delimiters
|
| Total Hit (1239) |
Sometimes you may receive a text file to import that has a row or column delimiter not available in the standard drop-down boxes of the Text File Properties dialog.
The first thing to try in these cases is to type directly into the Row Delimiter or Column Delimiter box. This will work fine if th
....Read More |
| Rating
|
|
|
|
Find an Access Database (from anywhere on the file system)
|
| Total Hit (638) |
It may be that we have built a DTS package to synchronise data held in an Access database and our SQL Server. The Access databases all have a consistent name but due to the fact that they are used by travelling salesmen on their laptops we cannot guarantee where the database will be.
For this we
....Read More |
| Rating
|
|
|
|
Deleting an Excel WorkSheet from within a package
|
| Total Hit (1892) |
Here is a simple and quick way of deleting a worksheet in an Excel spreadsheet. It uses two global variables, one for the Excel file name and one for the sheet to delete. As this uses OLE automation of the Excel application object, you will need Excel installed on any machine that this package execu
....Read More |
| Rating
|
|
|
|
Importing a Named Range From Microsoft Excel
|
| Total Hit (1723) |
On the newsgroups recently there has been a great deal of interest in importing data from Microsoft Excel into SQL Server using DTS. One of the questions that caught my eye was "How do I import values from cells from anywhere on the page?". You can do this using Named Ranges in the Excel spreadsheet
....Read More |
| Rating
|
|
|
|
How can I dynamically set the Access System Database
|
| Total Hit (669) |
You can easily change the filename for an Access database connection using the Dynamic Properties Task in SQL Server 2000. Unfortunately the property selection dialog does not allow access to the system database property (Jet OLEDB:System database) which you need to specify correctly when accessing
....Read More |
| Rating
|
|
|
|
How to check the file date
|
| Total Hit (603) |
This sample script was written to check the age of a file. If you import files according to a schedule, you may wish to check that the file is recent to prevent the potential re-import of an old file. The script reads the filename from an existing package connection and uses the scripting FileSystem
....Read More |
| Rating
|
|
|
|
Connecting to an AS400 with DTS
|
| Total Hit (563) |
DTS does not support AS400 connectivity natively, but by obtaining a third party ODBC or OLE-DB provider you can connect quite easily. In no particular order, some links for suppliers of such providers:
|
| Rating
|
|
|
|
How can I change the filename for a text file connection?
|
| Total Hit (619) |
It is a common scenario to have a scheduled package that imports a new file each day. Conversely you may wish to produce a uniquely named file each day. You can change the filename (DataSource) property of a connection at run-time from within an ActiveX Script Task.
....Read More |
| Rating
|
|
|
|
How can I change the filename for an Access Connection?
|
| Total Hit (696) |
You can change the Access MDB file of a connection at run-time using an ActiveX Script Task. The following example reads the new filename from a global variable and updates the connection called "Accounts".
|
| Rating
|
|
|
|
|
|
Getting Syntax Help for DTSRun
|
| Total Hit (579) |
If you are having problems with the syntax for the dtsrun command line, or just want an easy way of generating a valid command line first time, try using the dtsrunui utility. As the name indicates it is very similar to dtsrun, but with a user interface. This allows you to easily select your package
....Read More |
| Rating
|
|
 |
.NET Web Services II
|
| Total Hit (781) |
Part II: Customising attributes; Disco and UDDI practicalities and beginning asynchronous Web Services.
Knowledge assumed: VB.NET, VS.NET; .NET Web Service I
|
| Rating
|
|
|
|
.NET Web Services III
|
| Total Hit (760) |
After reviewing the basics of Web Services in Part I and continuing to look at more advanced specifics in part II, in this article and the next we continue the progression looking at three more advanced Web Service related activities:
«li»Creating and using SOAP extensions
«li»Creating asynchr
....Read More |
| Rating
|
|
|
|
.NET Web Services IV
|
| Total Hit (846) |
After reviewing the basics of Web Services in Part I and continuing to look at more advanced specifics in part II, in the last part we continued the progression looking at the first of the three more advanced Web Service related topics below:
«li»Creating and using SOAP extensions
«li»Creating
....Read More |
| Rating
|
|
|
|
Upload an XML File and Validate Against a Schema
|
| Total Hit (680) |
This ASP.Net (VB) program allows you to locate an XML file on your local machine, or anywhere on your network for that matter, upload it to a web server and validate the file against an XML Schema existing on the web server. If the xml file validates, a success notification is provided. If the valid
....Read More |
| Rating
|
|
|
|
Understanding How to Use XSL Transforms
|
| Total Hit (762) |
Original abstract: XSLT, XPATH and how to apply the concepts in .NET. Examines the concept of transformation and how an XSLT stylesheet defines a transformation by describing the relationship between an input tree and an output tree. Continues to look at the structure of a stylesheet, its main sub-c
....Read More |
| Rating
|
|
|
|
Use the Xml Web Control to Display Database Query Results as XML
|
| Total Hit (707) |
Sometime you may need to query a database and produce the results as an XML file. The .Net XML Web Control makes this extremely easy to do. All you have to do is create an instance of the XML control on your .aspx page. A very few lines of code can then be used to display the database query as XML.
....Read More |
| Rating
|
|
|
|
Saving a DataSet as an XML File
|
| Total Hit (701) |
XML is very well integrated with .NET. Many server controls have XML methods built in making XML capabilities only a method or two away. The DataSet class contains several of these XML methods and we will examine a couple of them in this article. The task in this example is to read a database table
....Read More |
| Rating
|
|
|
|
|
|
XSD Schemas: An Introduction
|
| Total Hit (655) |
The schema specifies the order of tags in the XML document, indicates fields that are mandatory or that may occur different numbers of times, gives the datatypes of fields and so on. The schema importantly is able to ensure that data values in the XML file are valid as far as the parent application
....Read More |
| Rating
|
|
|
|
|
|
|
|