No and No.

A connection manager is not directly related to a specific task, so you cannot use an expression in a connection manager using some attribute of a task.

And there...

You can run Powershell commands from SQL Server Agent. Is that an option?

When looking at the error it seems you are trying to run the package in a 64-bit environment where there is no 64-bit Oracle OLE DB provider installed.

Either run the...

Dynamically importing Excel files (or flat files) will only work if the structure and worksheet names remain the same for all the different Excel files.

When you create an Excel Source,...

Phil Parkin (3/9/2011)

---

You could always give them CSV files instead. Excel is the wrong tool for handling so many lines of data. If they are processing this data after you...

Are there any errors?

What version of Report Builder are you using?

Report Builder 3.0 surely supports SSAS:

http://technet.microsoft.com/en-us/library/dd220525.aspx

Another ad-hoc reporting tool is Excel. Laugh all you want, it is still the most used BI tool...

Schuttberg (3/9/2011)

---

> as they are just packages in the file system, you could go to folder where they are stored, copy them and them paste them in the appropriate folder...

Is there a question?

Anyway, I have a question: are there any errors and if yes, please post them here.

Your question is not exactly clear to me, but I think you are referring to indirect configuration.

Basically this means that there is an environment variable (or xml file if you...

There are several options:

* as they are just packages in the file system, you could go to folder where they are stored, copy them and them paste them in the...

Phil Parkin (3/9/2011)

---

That's a message I always try to get across. The fact that the files are usually called 'Comma Separated' is not helping the cause one bit and I...

Phil Parkin (3/9/2011)

---

Koen Verbeeck (3/9/2011)

---

natarshia.peck (3/8/2011)

---

Hello

i am running into a similar problem with the embedded double quotes.

I tried using the redirect row on error to just skip those rows with...

natarshia.peck (3/8/2011)

---

Hello

i am running into a similar problem with the embedded double quotes.

I tried using the redirect row on error to just skip those rows with the double quotes.

I have...

I did 😀