Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: victordba
  • Content: Threads
  • Order by date
  1. victordba

    Wrong sorting order of Date dimension in Excel.

    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...
  2. victordba

    Unused output columns warning...

    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...
  3. victordba

    Flat File Source Problem...

    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...
  4. victordba

    Populating SSIS variables.

    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...

Part and Inventory Search

Back
Top