Search results for query: *

OK, that subject line stinks, but a better one is too long. I am brand new to SSRS and fairly new to SSIS. I go to class next month, but I'm already having to produce. It was easy to create an SSIS package that works perfectly to load in the data, and an SSRS report to display the data nicely...

Had date fields that showed as long date and time (midnight) to the second. Set format in properties to mm-dd-yyyy (hey, it works in Access and Excel!) But what I get (using today for example) is00-13-2007 Then on a money field, I had four decimal places. I managed to get rid of the last two...

For my very first SSRS report, I used the wizard. Put some fields in "page," some in "group," and some in "detail" Judging by the (sub)total lines, the designer is showing me a single page (in fact, I am sure of it). Details show four records and I know there are hundreds, posibly thousands...

On a large data set, is there any performance advantage to having a view on the server apply some filtering isntead of have the report do it? For example, table S contains two years of services. I put in the reportSELECT * FROM S WHERE GETDATE() - Date_Of_Service < 30Tweak a column width, and...

Had a partially implemented SSIS package in Vis. Studio. After execution (successful), the output window ended saying it took 15.xx seconds. After adding more functionality and getting another successful run, output window does NOT say how long it took. Is that something selectable? I...

Created an SSIS package in Visual Studio. 1. Last task is SQL. Output window always says "Sucess", Fortunately the red box in the designer told me it wasn't true. Scroll far enough to the right and there's the error message. Unfortunately, it unhelpfully listed several things...

table S (input) has columns A, B table K (keep) renames them C, D and adds E Need to add new records if not already there, leaving E null in that case. Seems like there should be a simpler way thanINSERT INTO K (C, D) SELECT A, B FROM S WHERE NOT EXISTS (A, B) IN (SELECT C, D FROM...

I need to standardize some fields in a staging table before selecting some of them to put in a permanent table. Can I depend on the UPDATE happening before the SELECT or must I say GO between the two to ensure that non-standardized input fields are evaluated correctly in the SELECT ? thanks...

The goal was to load the data in identically structured CSV files--all files in directory. First attempt at building package with for each container got all sorts of cryptic error messages. So I deleted the entire package and created one with the Import/Export wizard and a single file name...

I had a report with so much data, I couldn't come up with a layout users could easily understand. So I made a copy of it, and then I laid out a subset of the fields on each report. One of them works fine. The other: In preview, it looks right, only one page long. Design is not too wide for...

HAVING UNBILLED.age_dt Between DateSerial(Year(Date()), Month(Date()), 1) And DateSerial(Year(Date()), Month(Date()) + 1, 0) Why does this select records throughout this month and last month? -- Wes Groleau http://www.Parkview.com/

I have to provide a way for a non-technical user to add records to a database from a file. The simplest method (for her, not for me!) would be if she can drag the icon from the attachments panel of GroupWise onto the desktop icon for my application. I'd rather not use FileSystemWatcher...

I'm still waiting for SQL Server 2005, but I'm starting to build my package in Visual Studio. I'm wondering how I should choose between using a ForEach container to loop over all the input files or using a "Multiple Flat Files" connection manager. Files are CSV with field names on first row...

Read-only access database has a linked table that is actually an ODBC connection to another Access DB. Every time we try to update the "real one," if anyone is using the linked version, it makes the master also read-only and we can't update it. Is there a way around this? -- Wes Groleau...

Just out of curiosity--if any one here happens to know something. Our auditor is taking a four-day weekend and I'm impatient. (I'm not an Inpatient--maybe I need to call an ODDitor)...... I am going through 835 files from Medicare to figure out some data extraction issues. Came across two...

What is the secret incantation to use for this? With Cells(x,y) If .HasComment then DoSomething(.Comment.Text) End If End With <range>.HasComment doesn't exist Comment = Nothing is "invalid use of object" Several other guesses got the same Not checking gets "Ob Var or With...

We do not yet have Office 2003, and so we can check in Access components as text files. So I have been checking in/out whole databases instead. About a week ago, and ever since, checking in a DB with "keep checked out" enabled takes hours. (Formarly took less than five minutes worst case...

I have successfully loaded these files into Access and SQL Server 2000 (via DTS) but I first used VBA to reformat them. The reformatting adds a HUGE amount of time to the loading. Here are some of the reasons I used a preprocessing step with DTS. I am hoping SSIS has some good ways to handle...

I have SQL Server 2005 Express (free) on this PC (paid version on the way) which I'm told does not have SSIS. But we also have a paid version of Visual Studio 2005 which allows me to build SSIS packages. This puzzles me. Will I be able to execute them or store them? -- Wes Groleau...

Seg_Array = Split(String_X12N, Seg_Delim) Last week, this code was working. Now, it consistently triggers an MDA pop-up which says "The CLR has been unable to transition from COM context 0x18f650 to COM context 0x18f7a0 for 60 seconds. et cetera" It does NOT wait sixty seconds. It is...