Business Intelligence

• Topics

  Started by

  Posts

  Last post

• Can SSIS Excel output be encrypted without Office installed?

  I have a client request to return a password protected Excel file from an automated ETL process. Do…

  edtrembickiguy

  1 replies

  14 years ago

  By: COZYROC

• Compress folder in to a zip file

  hi , I want to compress a folder into a zip file using ssis 2008 please let me know how to do tha…

  chhaya.porwal

  12 replies

  14 years ago

  By: Raunak Jhawar

• set a variable in ssis to a new value

  I am unable to see why the following does not reset the variable MainPath inside the package. Do yo…

  arkiboys

  11 replies

  14 years ago

  By: Koen Verbeeck

• path parameters to ssis package

  Hi, Trying to pass parameters to one ssis package and execute it as below. Note that I am using one…

  arkiboys

  2 replies

  14 years ago

  By: arkiboys

• SSIS package error on SSMS - how to debug

  One of our maintenance package has been failing. This package has been created by our previous DBA …

  ashanair70

  5 replies

  14 years ago

  By: Koen Verbeeck

• Lookup and Cache Transforms refresh option??

  Do we have an option to refresh the cache in Cache transforms??? How does the Cache transforms actu…

  sandyinfowave

  1 replies

  14 years ago

  By: Koen Verbeeck

• SSIS - Script Component

  Hi All, I am looking to use the Script Component to import a flat file and add a blank column to it…

  aarionsql

  1 replies

  14 years ago

  By: Koen Verbeeck

• Aggregation Function in SSAS Store only Last Value for Measure

  We have a requirement that SSAS cube store only the last value of a measure. Currently we are usin…

  ssolanki

  2 replies

  14 years ago

  By: seikialice

• Similarity Metrics

  I googled an open source function which generates a set of metrics returning a similarity coefficie…

  smecharrafie

  3 replies

  14 years ago

  By: jihadalrawi

• CheckPoints Clarfication

  H All, We have one Master packge.In master package we have used for each Loop container for loop re…

  msbi2049 53516

  14 replies

  14 years ago

  By: Vikash Kumar Singh

• SCD type 2 idea.

  Hi Guys, Am just lost in coming up with an idea of using SCD type 2 on table structure below. crea…

  Olalekan Adewale

  5 replies

  14 years ago

  By: Olalekan Adewale

• SSAS

  Hi Frndz, currently i am working under SSIS and SSRS.. I would like to know about SSAS too from bas…

  Charmer

  8 replies

  14 years ago

  By: Charmer

• Generating reports in sql 2005

  Can you teach me how to generate a report in sql 2005, step by step process

  diaz.avan

  2 replies

  14 years ago

  By: stevefromOZ

• How to add new column in SSIS Package at run time

  Hi All, I am new to SSIS, I created one new package and i want to add one new column in the de…

  Sarath Vellampalli

  28 replies

  14 years ago

  By: KoldCoffee

• How to load the filename and the data from multiple text file using SSIS package at the same time?

  Hi Everybody This is my first posting on this forum - so please bear with me if I get things wrong!…

  deepakagarwalathome

  6 replies

  14 years ago

  By: Koen Verbeeck