Business Intelligence

• Topics

  Started by

  Posts

  Last post

• MSBI - Learning

  Hi, I'm working on .NET, Now i'm learning MSBI(SSIS, SSRS, SSAS). Which whicks are better and usefu…

  sridhar.yalamanchi

  9 replies

  7 years, 6 months ago

  By: boyapati.ram100

• MSBI career

  Hello Everyone, I have 2.11 yrs of experience in SQL Server development and .Net too. Have more int…

  soumya.halder93

  3 replies

  7 years, 6 months ago

  By: boyapati.ram100

• How to read text file block by block based on header code in SSIS

  I have table which consist of several header code (it always starts with HDR) Every header will hav…

  squvi.87

  1 replies

  7 years, 7 months ago

  By: Eirikur Eiriksson

• SSAS in AG

  I believe I am correct that with 2014 SSAS it really can't be part of Always On, but can be on a cl…

  tcronin 95651

  2 replies

  7 years, 9 months ago

  By: tcronin 95651

• How to SetItemParameters for a report in SSRS 2008 using web services through SSIS package Script Task

  Gettings Everyone !! I'm new to SSRS and really need some help from you experts in this Forum …

  mikehe.info

  9 replies

  7 years, 11 months ago

  By: arshadul.huq

• Update status if deployed SSIS package is aborted

  When my SSIS package is executed, it updates a status field with the word 'Running'. If the package…

  Mike Bliv

  2 replies

  7 years, 11 months ago

  By: Thom A

• It takes 5 min to throw an error when config file is missing

  I do a negative testing. I renamed dstConfig on purpose. I want SQL Agent job to fail.It runs for 5…

  RVO

  2 replies

  8 years, 2 months ago

  By: Thomas Rushton

• SSIS - Cant open my file on execute

  I have tried to execute a SSIS package and the following is the result: DataFlow Task 1:Error: Cann…

  EwanAC

  1 replies

  8 years, 3 months ago

  By: jamiros

• File system task: copy in for each loop

  i am getting a error; The process cannot access the file as it is being used by other process.

  nicepraveenb

  2 replies

  8 years, 3 months ago

  By: MMartin1

• Excel source having more than 255 characters

  Hi, I have my SSIS package importing data from excel source to table. My excel file can contain cel…

  itzmee

  14 replies

  8 years, 3 months ago

  By: drew.allen

• How do I remove zombie Business Intelligence Development Studio installed by SQL Server Express?

  I am at a client where they install SQL Server Express 2008 R2 from a disk that apparently is capab…

  David Ziffer

  11 replies

  8 years, 4 months ago

  By: samvkevin

• how to pick the first file first from specific folder using for each in SSIS

  I have a remote folder from where i pick the multiple files and loop through for each loop containe…

  hegdesuchi

  4 replies

  8 years, 5 months ago

  By: Eirikur Eiriksson

• OLE DB Source Dynamic

  Hi, I created an SSIS package that uses an OLE DB Source - pointed to a DBF file. Problem is the na…

  krypto69

  1 replies

  8 years, 5 months ago

  By: Eirikur Eiriksson

• Redshift Script

  Hi I am using a script to get details about database name, schema name, table name, row count and s…

  subrahmanyam113

  1 replies

  8 years, 5 months ago

  By: HanShi

• need suggestions on converting cognos cubes to ssas cubes

  Due to the price of Cognos, my company has decided to convert all Cognos cubes to SSAS. I need sug…

  shanghaigirl-1125377

  2 replies

  8 years, 6 months ago

  By: Alan Burstein