Search results for query: *

I have a SSIS package that is importing thousands of records into a Microsoft Access database. I would like to include backing up the database or at least getting a copy of the affected tables before the import tasks execute. Is there a way to accomplish this since the Backup Database Task...

I have created a package that imports an Excel spreadsheet into a SQL table but it has to perform a fuzzy lookup first before importing. That works fine. The problem is, I have approximately 2000 spreadsheets to import. They are all in the same directory. What I would like to do is to have...

I am trying to subtract two date fields that I thought would be very easy. I'm creating a form in Adobe Acrobat. However, I am either coming up with a blank field or the "NaN" message and I don't know why. Both of my fields are formatted as a date field. My calculation field is formatted as a...

Hi, I am trying to capture a session variable that is located in a FormView that's part of a Master page. I know how to do session variables but the value is showing up as "System.Web.UI.WebControls.Label" instead of the value. What am I missing? The code I used to declare the variable is...

Is there a way to set the zoom factor to a default percentage when using a macro or Module to print preview a report. Right now when the macro runs it opens the report but it always defaults to "fit" and the client is looking to avoid the need to resize it. Any help would be appreciated.

I created a trigger on a table that moves any changes and deletions to the main table to a historical table. The problem is that I keep getting an error "conversion failed when converting datetime from character string". I used the convert function on the date fields and I'm still getting the...

I have created a web application with Sql 2005 stored procedures. I want to show the return value messages in a pop up window in the application but have been unsuccessful in getting it to display. I have tested it in SQL Query Analyzer and it is working successfully. How can I display it in...

I'm using Forms Authentication and a SQl 2005 database. I want to track who entered new records into the table. Of course I'm able to get the time and date but the asp.net current user is not being added to the table. I have one account accessing the sql database so if I use the suser_name...

I apologize for such a simple question but I have been using ASP.net for about 3 weeks. I have built a web application with a SQL 2005 database. I'm using Visual Studio 2005. I have established roles and users and it works fine. Now what I need to do is have the current ASP.net user name...