Another solution that is very similar to goofbauer's , but uses SQL server's numbers table and does not need row_number()

SELECT DATEADD(day, -1 * (number ), getdate()) as Last_Dates

FROM...

no it's not good pratice, and will run like a dog if there is a lot of data in there.

As far as I am aware the Visual Fox Pro Ole provider (VFPOLEDB) is not 64-bit compatible, you will need to run this package in 32-bit mode.

I see it all the time..

though common does not mean that it is good practice.

have a look at the procedure here, it will generate the insert script with data for you.

http://vyaskn.tripod.com/code.htm#inserts"> http://vyaskn.tripod.com/code.htm#inserts

I agree with Koen, a well designed ETL Packages wether it be in SSIS or any of the other tools should have logic in there that makes the...

the way I would do this, would be to create a distinct count on your measure, when you do this , SSAS creates a new...

best way to handle type 2 scd in my opinion, is to create a staging table that is identical to your load table and use the t-sql merge.

this will be...

Martin Schoombee (11/4/2011)

---

The ease of use is sometimes the product's biggest downfall. I see too many people who use components (like the SCD component) and then scratch their heads when...

SSIS is a great tool , I work a lot with Informatica and Data Integrator but keep coming back to SSIS when possible due to the flexibility...

i have seen code that would disagree with this.

it starts the id at 10000

so the id is meaningless?

if so you can use

DBCC CHECKIDENT ("Attributes ", RESEED, 10000);

to reseed you id column

you have a primary key and are trying to insert a duplicate.

search your source table for id =1129614 and it should have more than one row.

If you don't want to make a change to the sql source,

another way of doing this would be to add your data source twice, then use a derived column to...