Alvin Ramard (8/31/2010)

---

This looks like it is fairly simple to do in SSIS.

Honestly, it looks like you're trying to use SSIS before taking the time to learn how to do...

jyoti_bhatt (2/24/2010)

---

Hi,

I have a WMI Event Watcher task with the below WQL Query. Then task stays yellow even when a file named test.txt is dropped in C:\ drive?

SELECT * FROM...

SELECT [Measure] ON COLUMNS,

TOPCOUNT

(

{[Dimension]},7,[Measure]

) ON ROWS

FROM [CUBE_NAME]

Once the file is processed...as in your case...have a Script task or FST(File Rename)

have a variable(s) and follow the approach Alvin has mentioned

ssis learner__ (9/2/2010)

---

Hi,

thanks for your reply

-I got a way to do what I was trying to in this useful link

but now I was using a File System task (instead of...

Alvin Ramard (9/1/2010)

---

You might want to take a look at the CASE statement.

I also would like to recommend that you take some time to learn a few things about SQL...

have you closed and disposed the streams, if any

since you are able to add new content...it shd not be the issue with the credentials...have u implemented any scripts that involves IO operation

2 questions..

1. Are you Admin on the said machine

2. Is that drive where the folder is placed a local drive or a Network share drive?

As wayne has already mentioned about Excel sheets,

You may implement either an OPENROWSET query or a routine T-SQL with sheeet names

For more customization...Script Task may be handy

Libby,

Why do you need a Script component for data transfer...

All you require is a OLEDB source and Excel destination as per the problem statement you described

How are you specifying a FTP Connection string using a variable :ermm:

da-zero (8/26/2010)

---

A data warehouse is in most systems indeed like a relational database. The biggest difference is that traditional databases tend to keep only operational records in a normalized table...

Hey Ria,

What I understand is that you need to implement 'Reflection'.

Am I correct?

Phil,

What do you suppose is the problem?