Thank god for Will Smith and aliens 😉 😀 :hehe:

Congrats to...

Congrats!

Iulian -207023 (7/1/2011)

---

Thanks for the question

Interesting area, but why would someone usually use trace flags in practice;

I have not used them yet so I did not had the chance to...

That is good to know. Thanks for posting a solution Tim.

Easy question to finish the workweek. Thanks Steve!

The very last word of all that text says "success".

Is there any question you still have?

Are you executing the package manually in BIDS on the UAT server?

The Run64BitRunTime is a design time property in BIDS. It should have no effect when you run the package...

First of all, don't use the JET provider (which is used to read 2003-Excel files), it doesn't work in 64-bit.

The latest version of the ACE provider (used for .xslx) is...

If you are using SSIS, you just need to specify " as the text qualifier in the flat file connection manager.

Nice theoretical article about the basics, Tom. Thanks.

Nice question. I had to read the question a few times to realize what the actual question was (it is still early). 🙂

Do the Excel files and the FTP files have each time the same structure?

If yes, you need to loop over these files using a for each loop and reuse the...

You need to create an Event Handler on the dataflow.

The type of this event handler depends on what you want to do, but OnPostExecute or OnPreExecute seems a good choice.

Inside...

You create a data mining model and a data mining structure inside Analysis Services.