I'm writing a console utility to download specific files from web sites. The problem I'm running into is that some web admins have taken it upon themselves to not return a 404 error of the URI of the file is incorrect. Instead they redirect the request to another page on the site to provide...
I'm studying RegEx patterns for use in C# and I'm trying to find out if a subgroup scenerio is possible. I'm parsing an INI file and I'd like to return a single matches collection that contains the section, key, and value information for each entry. Here's what I have for patterns so far...
I'm having a bit of problem with the Select Case logical expression in my formula. I have several parameter parameter fields that return arrays of values (using the Allow Multiple Values option). I'm trying to assign a group name based on which parameter array the item is found. Here's my...
We have CR 10 and CR Enterprise Server. When developing reports in the CR designer, I would like to set the datasource to the development SQL server and be able to change the source before deploying it to the enterprise server. This is standard practice in any development area in our...
A question for the forum admins:
Can you please set up forums for SQL Server Reporting Services? It's a relatively new product (January of 2004), but it's quickly becoming a hot topic in the Business Intelligence community.
Two forums would probably be appropriate (one for setup & admin, and...
I have a package that is used to update tables on a Report server from a Production server and then creates a report from the data on the Report server. The steps are as follows:
1. Execute SQL Task - Clear local tables
2. Transform Data Tasks (3) - Update 3 local tables with data from remote...
I've just about completed an introductory book on VB.Net and I'm looking for some advised on good books for learning advanced topics going foward. My experience has been mainly with VBA/VB6 and client side web VBScript over the past 6 years. Since .Net introduces much more OOP into the VB...
Hey There,
I've heard from some people (DBAs and Developers) at work that there are potential issues with using Access to create reports from linked tables to SQL Server. I've searched Google, but I couldn't find any technical articles on any known issues. I did find one that mentioned a...
I have a DTS package that uses a query to export data to an Excel file. Everything works fine as long as the Excel file exists and the column names are pre-defined. What I would like to do is be able to create the Excel file during the DTS execution and define the columns based on the columns...
I have a project that incorporates a memo field for richtext content. Through experimentation and research, I've been able to develop a method to convert the RTF content to HTML using the Word object. In many cases, this reduces the size of the RTF content by up to 95%, which includes the...
I'm working on a project in Access that uses Word to print a report that contains fields with rich text. The rich text file is being created dynamically by combining the content from each of the fields and reformatting the rtf codes accordingly.
Since the rtf document is being created...
Good Afternoon,
I'm trying to find a query that will return a result set from a table that has the parent / child relationship in the same table. The table contains articles of information for a knowledge base application which is structured around a tree type interface. Each of the records...
Hello,
I just put together a new system with an ASUS A7N8X-E Deluxe MB and a Saphire (ATI) 9600 Pro video card, and it recently had a minor glitch.
When I booted up the computer one day, the video showed what could only be described as "jail bars" of distortion / static on the screen (about 6...
I have this update query in my DTS package to null out blank values:
-----
update catalog_import
set vendor_sku = null
where vendor_sku < '!'
update catalog_import
set vendor_desc_text = null
where vendor_desc_text < '!'
update catalog_import
set uom = null
where uom < '!'
update...
Has anyone found any good visual xslt designer tools? Something that could read data from ODBC sources would be a good bet as well.
- Glen
Know thy data.
I'm setting up a DTS package to retrieve a file via FTP and import the data from tab delimted to a table. Everything works fine except that empty fields in the delimited file contain a space. I would like to convert that empty field to a null value on import.
Does anyone have an ideas on how...
I have a batch process that imports data uploaded by vendors into a table for comparison and reporting. I created three SPs to handle the task but I could use some advice on making it more efficient. Here's the gist of the process (apologies in advance for the long post):
Vendor data can...
Hello good people of Tek-Tips!
I'm planning a project to create a snapshot of data from our CRM database and place it into an MSDE database for reporting purposes. Here's the basic concept:
Pull specific fields from Problem Report, Change Request, and Service Order records that are currently...
I'm working on moving our knowledge base application from an Access frontend/backend solution to a VB.Net frontend / MSDE 2000 backend solution. The MSDE database will be on a central server to which all users can access.
In the current application, the user is able to create private DBs and...
I'm putting together a "light" application server box. It's configured with duel 1 GHz processors, 512 MB RAM, and about 50 GB RAID (mirrored) drives with Windows 2003 Enterprize edition.
My questions is, has anyone here tried to run MSDE and IIS 6.0 on the same box? If so, what are...
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.