Search results for query: *

I don't know if this is the correctt forum to ask this question. Is there a software tool that will automatically distribute OS files on the active directory level to multiple servers in the same domain? I seem to remember using a tool like this a few years ago, but I don't remember what it...

SQL Server 2005. I have two recurring SQL Agent jobs on one of my servers. They are the only two jobs on the server, at present. One of them is scheduled to recur once a day at midnight, and the other is scheduled to recur once every 15 minutes. Neither job is recurring. The schedules are...

We want to monitor free disk space on the hard drives of our SQL Server boxes, but we want to do it by percentage of free space so that we can reuse the same monitor, regardless of the size of the hard drives on the box, and not have to create one-off monitors for each server. The...

In an ActiveX task, I have instantiated an object for an existing ExecuteSQLTask. Now I am trying to set the SQL Statement property for the instantiated task, but I can't figure out the name of the property. The DyanamicProperties task name of "SQLStatement" is not correct. How do I set the...

This is not a critical production question, only something I have found that I can't figure out. I have this query that returns 103,038 records: Select a.RecId From dbo.TableA a Left Outer Join dbo.TableB b on b.TableA_RecId = a.RecId Where b.RecId is NULL If I modify this...

I'm running a stored procedure, and when it finishes I get the fatal exception error in the subject line. I have traced through the stored procedure, and it seems to complete normally, so it looks like this error is generated after the stored procedure completes, but before control returns to...

We have a stored procedure which hangs when called from DTS. If the stored procedure is called from Query Analyzer, it runs just fine. This does not happen with any other stored procedure. The logins for DTS and Query Analyzer are identical, so it doesn't look as though permissions are an...

Is there any way to conditionally encrypt a stored procedure when creating it? For example, running the sp script against the development server would not encrypt the sp, but running the same sp script against the production sever WOULD encrypt the sp. Is this possible? Thanks.

BOL recommends that you use 'Set @local_variable = scalar_value' instead of 'Select @local_variable = scalar_value', but it doesn't say why. Can someone tell me why 'Set' is recommended over 'Select'? Thank you.

I have set up an ADO connection to a SQLServer DB in VBScript in an ActiveX Task. What I want to do is return a uniqueidentifier value from this connection directly to a local variable in the script. The essential parts of my code are as follows: Dim strSQL, strResult strSQL = "Select...

I want to put filenames from a folder on the servers hard drive into a table in my DTS Package SQL Server OLEDB connection. I can do this by issuing a "dir" command and directing the output into a text file on the hard drive, and then importing the text file with a data pump, and the inserting...

I need to return a recordset from a table in my SQL Server connection, and then process each individual item in the returned recordset. The returned recordset is going to have only one column. I'm thinking this has to be done using an ActiveX Script Task, but I haven't yet been able to figure...

I'm having an unusual problem. I'm importing a text file, but I'm only getting the first 256 characters of each record. The text file, however, is a little unusual, so I'm wondering if that might be the problem. My customer created an ostensibly comma-delimited file. However, the file has a...

If anyone needs or wants to be able to import the first line of an Excel spreadsheet, follow this link and become enlightened. I sure did. http://www.sqldts.com/default.aspx?255

This may be a very basic question, but up until now I have only imported and exported flat text files. When I attempted to import a simple Excel2002 spreadsheet, the Transform Data Task excluded the first row of the spreadsheet. I checked the Excel Connection and Transform Data Task...

I am using DTS to FTP a file to a remote server. As part of this process I create an FTP commands file for FTP.exe to use. The last task in my DTS process is supposed to delete this FTP commands from from the hard drive. I use an ExecuteSQL task to do this with the following command: Execute...

Is there a way to access error messages generated by step failures in DTS? For example, I can make the FTP step fail by giving the wrong password and an error message will pop up saying Unable To Connect. Is there any way to access this error message, say in an ActiveX Script task so it can be...

Is there a Crystal dll which will convert a string containing a number in scientific notation (i.e. "6.03e2") to numeric and one that will convert it back again? Thank you.

I am using Crystal 8.5 and Crystal Syntax for formulas. I declare the following variables: Local numberVar intIndex; Local stringVar strResult := ""; Local stringVar strSymbol := ""; The following syntax generates no errors: if {?DataType} = "N" or {?DataType} =...

When I export to a character-separated values file, the information in the Report Header section gets inserted at the beginning of each and every detail line! The report looks absolutely fine in the Crystal View window, but gets corrupted like this when I export it. What is going on here? I...