Recent content by DBAchick

Basically, I need to control the position of a record I am inserted. I have created TableX with a single column (no index) varchar(8000). Main Stored Procedure calls Stored Procedure 1 which inserts a 'header record' in TableX. The calls Stored Procedure 2 which queries several other...

Summary of what my DTS Package accomplishes: A stored procedure is executed to populate a table in the database with the data I need using an execute sql task. Using a transform data task, I tranform the data to a destination text file. All of these task 'values' are set using the dynamic...

I have an execute process task in my DTS Package that I only want executed if a Global Variable value = Y. Here is my code: Function Main() ' Check global variable from package If DTSGlobalVariables("sZipFlag").Value = "Y" Then Main = DTSStepScriptResult_ExecuteTask Else...

I have created a job that will be executed as a Multi-Server job. The first step is an ActiveX Script in which I need to query the sysdatabases table in order to get a recordset of the databases on that server. In order to run the Select statement, I am creating a connection string that...

I would like to be able to zip a file using WinZip or PKZip as step one of my DTS package. I assume I will need to do this in an active X task as it will require a commmand line call to the winzip or pkzip.exe. Am I headed down the right path or is this beyond the capabilities of DTS? Any...

The references that are set in my Excel spreadsheet are: Visual Basic For Applications (C:\Program Files\Common Files\MicrosoftShared\...) Microsoft Excel 9.0 Object Library (C:\Program Files\Microsoft Office\...) OLE Automation (C:\Windows\System32...) Microsoft Office 9.0...

I created an excel spreadsheet that performs some email tasks using vba for applications. I set the references in the VB editor, but when I send the spreadsheet to someone else, they receive errors until we set the references on THEIR machine as well. Is there a way to 'complile' the...

I searched the forum, but could not find this issue addressed. Access 2000. I have a query in which one field is a date. I have parsed out MyMonth: MyMonth = Month([MyDate]) and now want to perform a function on MyMonth to get the month 6 months from now, My6Month. Example: If MyDate is...

Info: Running Word and Excel 2000 but saving both files as 97 compatible. I have seen this done in Word, but not Excel. I want to create a spreadsheet that has a Word Doc 'embedded' in it. I have created the spreadsheet that will be sent out to various people, now I want the document...

Excellent suggestions! Thank you both for your assistance!

I have created a DTS package that makes one connection and creats 7 .txt files based on different select statements. Each .txt destination file needs to have a path and file name assigned (General Tab on Properties of Text Destination.) I want to be able to manipulate (before or after...

I need to write an ActiveX Script that will be executed via the DTS utility in SQL Server 2000. I create 7 files using DTS but the name of the file is not a variable so it is hard coded. I would like to run a quick script after the files are created to concatenate the date to the end of the...

Thanks for you input Skip. After I started to 'click around' I found an option under format control that allows you to either move and/or size the control with the cell it floats above. I checked move and size with cell, and viola! they disappear when I collapse the group. Guess I should have...

I have created a spreadsheet with a few checkboxes and radio buttons. I have grouped the cells that lie underneath the objects, but when I collapse the group (click the little "-" next to the row numbers), the radio buttons and check boxes remain on top and visible. Is there a way...

Is there a way to find the exact name of an event - I have a label with a click event - I want to know the name of the event i.e. if the label is label10 and the event is a click event - can I find the string label10_onclick in any property