Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jjefferson
  • Content: Threads
  • Order by date
  1. jjefferson

    Any way to log sent email created by Send Mail Task?

    Re SQL Server 2008 R2 SSIS When we use the sp_send_dbmail procedure in a T-SQL query, the email activity is logged in a system database table. However, I cannot find a similar logging capability with SSIS when using the Send Mail Task. I have the feeling that the feature does not exist, but...
  2. jjefferson

    Trying to add Excel to Open With list of program options

    Windows 7, Office 2010 Recently upgraded from Office 2007 to 2010. We have a number of files on our system that are Excel files, but they do not have the XLS or XLSX extents (a process that makes a backup copy appends a timestamp to the copy when moving, so they are named something like...
  3. jjefferson

    Access to dataset filter info in Report Builder 3.0

    Using Report Builder 3.0 on SS 2008R2. We migrated a lot of reports that users had built in Report Builder 2.0 on SS 2008. One of the features of RB 2.0 that seems to have been "lost" in RB 3.0 is the ability to insert a "filter description" textbox as the footer of a report. We have a number...
  4. jjefferson

    SSIS package - graceful exit when nothing to do

    I have an SSIS 2008 package that is working fine. There is a script task at the very beginning that looks for the file it wants to import. I have a precedence constraint between that and the next step to test the success of the script task. When I run this manually from VS, it works fine and...
  5. jjefferson

    Excel Passing Named Range as Argument

    I've been banging my head against this simple thing, tried suggested approaches found in searches without success, and need to ask for assistance. I have three named ranges on a sheet, each referring to a single cell. Three buttons each call their own unique sub in the module. I would like...
  6. jjefferson

    Problem changing gpg.conf file

    I am using GPG4Win 2.0.2 to encrypt/decrypt files only. I have been using the "--pgp8" option when using the command line to encrypt files for a particular client, and this is working fine. I want to add this option (pgp8) to my gpg.conf file so the GUI encryption front-end will recognize and...
  7. jjefferson

    SQL Server Mix of Full and Express Versions?

    We have numerous instances of SQL Server 2005 on our network, and have the Management Studio installed on our workstations. I have some testing and development work I'd like to perform, and wondered if it is possible to install just the SQL Server Express edition on my workstation, without the...
  8. jjefferson

    VB equivalent to PHP mcrypt function

    I hope to find references and links to places I can learn more rather than have the code spelled out for me. And maybe save some time searching if what I need to do is not possible. I am very new to VB.Net. I had a web application written for me a little while ago. The programmer wrote a PHP...
  9. jjefferson

    UPDATE function in a trigger - problem

    I'm working on a trigger which selects column names from a table to determine which columns to "audit". The user can then add or remove column names from this control table and the trigger will not need modification. At least, that's what I hope to do. I have a problem with the UPDATE()...
  10. jjefferson

    SQL 2005 and DOS text

    Hi - Using Management Studio query to pull some data, then save the results as a tab-delimited text file for an old DOS program to process. Worked fine with the old Query Analyzer (still have that and am using as an interim workaround). The problem is that Management Studio seems to be saving...
  11. jjefferson

    Management Studio - text encoding problem

    I can't find the setting to tell the new SQL Server Management Studio Express to "save as" plain ol' text (like the old Query Analyzer used to do) instead of this new fangled two-byte Unicode text. The exported text imports just fine into Unicode-aware things like Excel, but we have some old...
  12. jjefferson

    Server Management Studio save as problem

    Until recently I used Query Analyzer to perform ad hoc data extractions, then saving the results in tab-delimited text files. I've now been converted to SQL Server Management Studio Express (which I like a lot), but the "save results as" function seems to have lost the ability to create...
  13. jjefferson

    Outlook VBA - Preliminary advice

    I need some initial confirmation that what I want to do is possible, before I spend a lot more time on it. Don't need any code (yet!). I've reviewed and harvested a lot of code already that generally runs through an Outlook folder and saves messages and/or attachments to other disk locations...
  14. jjefferson

    FILTER function in Access VBA?

    Was recently upgraded to Access 2003, and wanted to try some new functions. I can get Split and Join to work just fine, but Filter is another story. The system doesn't seem to "recognize" it, in that I don't get the popup argument assistance that I do with Split and Join. I can get to the...
  15. jjefferson

    Closing maximized preview closes Access

    I'm asking this for a colleague, so forgive me if I haven't provided enough information; I'll supply more if needed. The basic problem is that a report is presented in print preview mode, and the user clicks the maximize button on the preview's frame. All toolbars are disabled for the end...
  16. jjefferson

    Word 2000 text form fields

    I have two "issues" with form fields I need to resolve, if possible. The template has a line of text, followed by a form field for a number, followed by a form field for an amount, all on the same line (this is repeated down the page). I need to somehow "fix" the position...
  17. jjefferson

    Excel - Disable Auto Hyperlinking?

    I have a column for users to enter email addresses to be used later by a VBA macro. As each entry is made, it is turned into a hyperlink to the email client. I can disable/remove the hyperlink from these cells, but if a change is made or a new cell added the text is re-hyperlinked. I'd like...
  18. jjefferson

    Merging Excel workbooks

    I've found and am using some techniques from this forum to retrieve information from multiple workbooks and copy it into a "master" workbook. This is working fine when the "source" workbooks only contain one worksheet. Now, I have to open from 1 to 12 workbooks, each...
  19. jjefferson

    Selective copying between sheets - Excel

    I have a workbook with one worksheet for each branch office; the name of the sheet is the branch code. The last sheet in the workbook (called "DATA"), is a raw grid of data retrieved via SQL, and sorted in branch code order. Column A is the branch code, columns B to L have the rest...

Part and Inventory Search

Back
Top