Layne-812700 (3/2/2011)

---

Hi,

We're in the process of migrating from SQL 2005 to 2008, and we have quite a number of packages. Can we script them out, then do a find-replace...

Are you trying to get the actual value (the intersection of the row causing the error and the column) that caused the row to fail?

I tested it on my dev...

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...