Delete Rows from SQL DATABASE BEFORE Import To THE SQL DATABASE USING SSIS
How to Delete Rows from SQL DATABASE BEFORE Import To THE SQL DATABASE USING SSIS

Answer Question   |  May 30, 2009  5:01 PM
SQL Database, SSIS, SSIS 2008, SSIS Package 2008

SQL Server 2008: SSIS pakage with parameters
I need to create SSIS package with user entered date parameter. I have two questions: 1. How I can promt the parameter when I test the package in debyg mode. 2. How can I put on the begining of the package design condition: Global Variable gvar_Date datetime; If @p_Date is null Then gvar_Date = getdate() [...]

Answer Question   |  March 17, 2009  8:43 PM
SQL Server 2008, SSIS Package, SSIS Package 2008

How to process partitions (Full) in analysis services
Hi, I have a cube which on a daily basis partitions will be created Partition names: shipment2008_12_31 shipment2009_01_01 shipment2009_01_02 shipment2009_01_03 shipment2009_01_04 …. . . . . I have to process the partition based on the day. If the day is 03 jan 09 the package has to process shipment2009_01_03 (Full partion processing) If the current [...]

Answer Question   |  January 12, 2009  6:08 PM
Partion processing, SSAS 2008, SSIS, SSIS Package 2008

SSIS package using dynamic configurations
Hi I have to create a package which process the analysis services cube and its partitions,and dimensions. This package should run every 15 minutes to process the cube. I have a procedure which creates the database in analysis services db and relational db for the current month. I have another procedure which creates daily tables [...]

Answer Question   |  November 10, 2008  5:28 PM
SQL Server Analysis Services, SSAS 2008, SSIS, SSIS Package 2008