The wildcard functionality is available in the For Each Loop, so you can look into that.

The For Each loop also allows you to store the filename of the file it...

Do you have an idea why the original problem occurred?

With the same method. Create another variable that will hold the final result.

Set the property EvaluateAsExpression of that variable to true, and then create an expression similar to the one...

Regarding the datetime variable:

you can use an expression on the variable to set it's value.

Set the property EvaluateAsExpression of the variable to true.

Then create an expression for the variable, where...

Allright, I took a long hard stare at the example, and I finally noticed the running total.

Here's the article...

LexusR (3/3/2011)

---

try without ssis

bulk insert into FlatBuffer ...

and parsing into tables

if Object_ID('tempdb..#F1') is not null drop table #F1

if Object_ID('tempdb..#F2') is not null drop table #F2

if Object_ID('tempdb..#F3') is not null drop...

If I understand it correctly, Result...

Sorting the way you provided is not possible, since the one with 2.5 clearly doesn't belong there.

However, if it was just a typo on your part, you can just store...

Good question Jamie.

I got it correct because I found your issue on Connect:

https://connect.microsoft.com/VisualStudio/feedback/details/595443/datadude-data-generation-need-a-way-to-set-identity-insert-on-in-a-dgen-plan

(I voted on it)

How do you mix a star schema with a snowflake schema?

No problem, glad to help.

According to various sources, you can't connect with SSIS 2008 to SSAS 2000.

http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/0610eafb-85e3-4506-af64-b15e251c4185

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/23f31694-37d8-4a83-8272-30ecc240f733

The suggested alternatives are;

* create a DTS package to process the cube and run this DTS package from...

Sure. At...

CirquedeSQLeil (3/2/2011)

---

Koen Verbeeck (3/2/2011)

---

Great question, thanks.

I could deduce the correct answer since I ran the query on my development machine.

Not all results were zero and the columns aren't nullable, so...

What are you using to bulk insert the data.

One solution (and there will probably be more) is the following:

use SSIS with a .NET script task (or just build a .net...