Business Intelligence

• Topics

  Started by

  Posts

  Last post

• Combine tables from source database to destination database in SSIS

  Hi All i have a set of tables names in a flat file.I need to read the names from the file and to …

  incubator123

  6 replies

  14 years, 5 months ago

  By: krish.sett

• Executing SSIS packages in various ways

  Hi Guys I am new to this forum and would like some help. I hope this is the correct place to post …

  chrisd-906612

  3 replies

  14 years, 5 months ago

  By: CooLDBA

• Join Access Data with SQL Data in SSIS

  Hi, I have my Access table structure as follows AccountID useralias 1 anm 2 ghy…

  v-swgar

  2 replies

  14 years, 5 months ago

  By: v-swgar

• Derived column Replace function not working for double quotes

  Below is my code in derived column transformation expression to replace double quote with nothing, …

  silpa001

  7 replies

  14 years, 5 months ago

  By: karthik_j18

• SSIS 2008 OLE DB Source Table name or view name variable - Opening a rowset for "Select * from dbo.datatable" failed. Check that the object exists in the database

  Part 1: I have a package that stores a table name in a variable. I use the OLE DB source to connec…

  bjones-1039857

  2 replies

  14 years, 5 months ago

  By: karthik_j18

• Generate column Mapping report in Excel from SSIS Package

  I need to Create a SSIS Package and generate a column mapping report into excel sheet. For exampl I…

  rakesh.sharma1981

  5 replies

  14 years, 5 months ago

  By: Koen Verbeeck

• ssis

  hi all how many records we processed everyday in ssis regards

  satvinder.atwal

  2 replies

  14 years, 5 months ago

  By: Koen Verbeeck

• Role of SSAS DEVELOPER

  Hi All plz tell me what is role of SSAS DEVELOPER in details or in steps actually i m new in ssas a…

  satvinder.atwal

  3 replies

  14 years, 5 months ago

  By: CarpenterBob

• FTP SSIS Task

  I have developed a package that reads some info from a database, transform some data, puts into an …

  GBeezy

  5 replies

  14 years, 5 months ago

  By: pyt

• What is the concept of Dataware house

  What is the concept of Dataware house,How it is install and all? In MSDN also I am continuos sera…

  forsqlserver

  3 replies

  14 years, 5 months ago

  By: Jayanth_Kurup

• SSIS Excel Connection Manager

  I have developed a SSIS package that shoves everything into a Excel Spreadsheet and then sends that…

  GBeezy

  2 replies

  14 years, 5 months ago

  By: GBeezy

• can we Use Cursors in Query for SSIS

  Hi ! I run the below query with SSIS on sybase DBMS but i was getting the error message stating tha…

  Steve Dell

  2 replies

  14 years, 5 months ago

  By: Jack Corbett

• Child package issue in SSIS

  Hi All I have around 5 child package in one parent package. All the child packages run without any …

  sowmya.boodaderureddappa

  4 replies

  14 years, 5 months ago

  By: sowmya.boodaderureddappa

• SSIS Scd's and doing SCD's via t-sql

  What do you think are the pro's and cons of using the SCD object in SSIS, do you think its better …

  vee van gelder

  5 replies

  14 years, 5 months ago

  By: Koen Verbeeck

• SSIS - Excel - extract column names

  Hy everybody, is it possible to get the column name from an excel sheet (e.g. in my Sheet are the C…

  PowerUser

  1 replies

  14 years, 5 months ago

  By: Koen Verbeeck