To conclude: I really was pointing out the obvious irony 🙂

Totally off-topic:

why are you calling a stored procedure per row? Isn't it more effective to call the stored procedure on a set?

In your flat file source, you can select the option

Retain null values from the source as null values in the data flow

Try it and let us know if it works.

I usually define them first in the datasource view and then check if they are correct in the dimension usage tab of the cube.

Try using "1900-01-01".

Or the clever use of LEN and FINDSTRING in a derived column.

vinod.andani-874416 (9/16/2010)

---

i strongly disagree with you.. as the rollback/commit statments does not work for alias unless preceeded by TRAN or TRANSACTION so the syntax error.... i chose answer "Error :...

Great question. Internal SQL Server stuff isn't exactly my forté, so it is always nice to have a QotD to crank up my knowledge.

Great question!

I didn't know about the ROLLBACK WORK syntax, so I definitely learned something today.

phil.wood 94423 (9/14/2010)

---

Oops, I got it wrong.

In my defence, nesting works all over Microsoft so I'm a little surprised they never got it working here. Almost seems like an...

Nice question about the transaction basics. As I'm reading the self-paced training kit for the database developper certification, this was a really easy one for me, as it is explained...

The number of tasks that can run concurrently in a ssis package is dependent of some parameters.

- the number of processors available

- the value of MaxConcurrentExecutables

- the value of EngineThreads

Make...

Edit: (This is an unfortunate double post due to my slow internet connection)

M.B.A. (9/13/2010)

---

As I found out this is a great article on the same site:

Top 10 SQL Server Integration Services Best Practices

And it seems that in my Case dtexec.exe has...

@dsvasudevan: I believe there is no explicit transaction, so the 3 tasks do not belong to the same transaction.

On-topic: great question!