SSIS Package 2008 Questions and Answers

Recent IT Questions

1 - 4 of 4
<<PREVIOUS 1 NEXT>>

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

View Answer   |  May 27 2009  5:01 PM GMT
SSIS Package 2008, SSIS 2008, SSIS
asked by NET2008

  5 pts.

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 =...

View Answer   |  Mar 16 2009  8:43 PM GMT
SSIS Package 2008, SQL Server 2008, SSIS Package
asked by IG1944

  10 pts.

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...

Answer Question   |  Jan 12 2009  6:08 PM GMT
SSIS Package 2008, SSAS 2008, Partion processing
asked by GIG

  240 pts.

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...

asked by GIG

  240 pts.

1 - 4 of 4
<<PREVIOUS 1 NEXT>>