Business Intelligence

• Topics

  Started by

  Posts

  Last post

• MDX Date ranges

  Hi, I've got a query that i'm working on that's giving me a sore head. I need to display the first …

  Intrepid121

  3 replies

  13 years ago

  By: swapp

• ssis scheduling package prob

  hi friends i have a small doubt in ssis plz tell me how to solve issuse. i developed one package in…

  asranantha

  3 replies

  13 years ago

  By: Koen Verbeeck

• SSIS - copyied original package, changed name, but still reading original dtsConfig file

  I have an SSIS package, that I did not write. It is used to transfer production data from a configu…

  cgivens

  5 replies

  13 years ago

  By: John Mitchell-245523

• Excel Connection Manager issue will only preview data when XLSX spreadsheet is open

  We receive a spreadsheet via FTP from a vendor and have to load the data into SQL Server. When I c…

  Michael J Bonk

  2 replies

  13 years ago

  By: Michael J Bonk

• How To create Two hierarchies for two separate columns in fact which refers to single dimension

  Hi All, I want to create Two hierarchies for two separate columns in fact which refers to single di…

  NIRANJANA1977

  1 replies

  13 years ago

  By: Koen Verbeeck

• Performance Issue while Inserting data in to DB2 from SQL Server using SSIS package

  Hi, I am hoping someone will have a solution for my problem. I am having a performance issue while…

  ashwini.ramaiah

  2 replies

  13 years ago

  By: Koen Verbeeck

• How to count multiple entries in one column in SSRS?

  If I have 1 column displaying current product of 200 accounts. How can I see product counts? So i…

  tscott 24349

  1 replies

  13 years ago

  By: subbu1

• i am working on ssis 2008 so i have written vb.net script in my script task that given below errors .please give solution to resolve the problems

  Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an i…

  roshan.maharana

  1 replies

  13 years ago

  By: Tom_Sacramento

• Problems printing a report that utilizes a barcode font.

  I have a report that utilizes a barcode font (3 of 9) for one of the report fields. We have encount…

  WayneS

  3 replies

  13 years ago

  By: Ant-Green

• Export top(n) rows from Excel

  Hi, I am trying to export only top (100) rows from an excel source. I added the excel file to the s…

  engg.pankaj

  4 replies

  13 years ago

  By: Ant-Green

• Long versus wide fact tables

  Hi, I'm working at an insurance company which has several different dimensionally modelled warehous…

  richardkeithmoss

  7 replies

  13 years ago

  By: Ken

• SSIS package change source from Oracle 9i to Oracle 11g - ORA-12154 error

  I am trying to change our source database Oracle 9i to new database 11g. I pass the credentials thr…

  chalamsbi

  5 replies

  13 years ago

  By: ggoble

• Import from multiple Flat and excel files in the same folder

  Hi there, Need help with importing from multiple Flat and excel files in the same folder (or its su…

  engg.pankaj

  2 replies

  13 years ago

  By: Kumara1011

• moving data into praraw table

  i have 10 text files in a folder and also have three tables in sql server data base.depending on th…

  nck

  2 replies

  13 years ago

  By: Kumara1011

• Run Multiple SQL Queries

  I am new to SSIS so need help with some issues. Creating a task which involves running multiple sql…

  engg.pankaj

  3 replies

  13 years ago

  By: engg.pankaj