anuragingle (9/16/2010)

---

I need to delete files and more importantly the folders containing the files which are older than 90 days.

Can this be done with a SSIS package

I can delete the...

Nils Gustav Stråbø (9/15/2010)

---

You can make a parameter depend on the value of another parameter. I've done it several times with drop down lists. All you have to do is...

ian.dunlop 7059 (9/15/2010)

---

HI ALL - Anyone ever had to do the following - hopefully someone has

Scenario

I have 2 parameters - 1 is a free entry textbox - 2nd is a...

Ron,

The user has not mentioned about the nature of SalesValue measure.

If the SalesValue...

Rich Wyble (9/14/2010)

---

I created an SSAS data cube a couple of years ago. At that point I was knowledgeable enough to be dangerous. Since then I’ve realized that...

It is FST (File System Task) and not FTP task:-):-)

Deepthy,

Please note:

1. FST(File System Task to create a new file)

2. user variable to store a recent time stamp

3. Append the file name accordingly with the variable

4. DFT(Data Flow Task) to...

Ashish I can give you 100 questions on each and I assure you that you will fail to answer any new technical query that arises in production or atleast at...

sacheen (9/13/2010)

---

I have to write a query which performs select operation on one table from one database on server A and where condition has result of another query which is...

Thanks , I learned a new concept today

My mistake...Sorry:-D:-D:-D

sabari as you said you have close to 2 million records. I suggest you stick with derived column transformation with CRLF as delimiter

sabarichandru (9/13/2010)

---

Hi,

This source file comes from Peoplesoft Database so u cant correct the format. client will send the CSV as a source.

u had given some suggestions how to rsolve the...

Dennissinned (9/13/2010)

---

Your main Report Dataset needs to look something like this

select * from cateogortTbl

where cateogoryID=@Cateogory or @Cateogory = 'All Cateogories'

Now you create a new Report Dataset that just Lists the...

Good question...

The logic can be well understood as below:

For Parent : Transaction option = Required

For Child : Transaction option = Supported/Not Supported