Search results for query: *

Thank you, John. I already solved this problem. I my Calendar table besides Month Short (Jan, Feb, Mar and so on) I also have a field Month Number (1,2,3 ...). So, in the properties for Month Short I set the KeyColumn as Month Number, and for NameColumn I set Month Short. Works perfectly good.

Hi. I have a Date/Calendar dimension in my cube. When I open my cube in SSAS cube browser, and then expend year to quarter and then quarter to month, those months labels show in correct order, Jan, Feb, Mar and so on. But when I do the same in Excel 2007, when I am connected to the same cube...

Thanks, man. I feel like poop now. Something so simple and I couldn't figure it out. :) Thanks again, Victor.

How do you delete the columns from the Union All task ??? It doesn't have an Advanced Editor to do that, and in a regular editor it's impossible.

Hi, I am getting a few of those warnings: [DTS.Pipeline] Warning: The output column "ErrorCode" (1251) on output "Union All Output 1" (1214) and component "Union All" (1212) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task...

Guys ? Anyone ? I can't believe that nobody had this problem with delimited text source file.

I have a weird thing happening. I have an .csv file. When I try to load it into a table, I can do it easily in DTS 2000. But when I am trying to do it in SSIS 2005 with exactly the same settings (like Text qualifier, row delimiter etc.), I am getting an error: "The last row in the sampled data...

Hi, Catadmin. 1) Yes, I know exactly how many records in excel file I have. So I had to create package variable for each record. 2) I have only 1 Script Task within the ForEachLoop Container. That's where I go through the records in this Object Variable that contains my recordset from excel...

Thanks, Catadmin. I found the easy solution. First I used a Data Flow task. Inside this task first I put Flat File Source connection (it also can be an Excel). Then I used a Recordset Destination. What it does, it stores the recordset output from a flat file (or Excel) in memory recordset, and...

I have a little question. I have a small Excel file with 2 colums: "Rate" and "Rate Description". There are only about 10 records there (but it might change over time). Users can change rates at any time. I am supposed to use those rates in my SSIS package to calculate derived fields in one of...