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...
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...
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...
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...
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...
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...
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...
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...
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()...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.