Thanks brenda and steve, that was a lot of great career advice as well!!

I'm usually a "go at it alone" sorta person, but i have come to realize the importance...

I am pretty new in the sense that this is my first DW/BI project altogether.

I am using this methodology that i found during my initial reserach in this project.

1.Determine the...

Thanks, it does look like most of the people here have learnt things themselves, i was trying to decide as to whether i should buy some more books...

Thanks for your feedback everyone..yes i definetly do not want to take shortcuts, but im sure you would all agree that the subject domain i am referring to is vast...

I...

Thanks, yeah what i have mapped out is that each dimension table has a unique key, and these are surrogate keys.

Then each fact table has those keys in it...

Do i need to recreate the index?

Thankyou for your suggestion,the query cancelled, i truncated the table and it took just 1 second (haha!) .

It also keeps the schema, so no need to recreate 🙂

Yes..i guess so, however in the past i have done that, the process seems to keep executing in the background though, consuming resources and the only way to end it...

Would a drop table be quicker?

As a SSIS newbie myself, i just successfully created a package, that imports data across two servers, and then performs a lookup and after that an update. It was messy,...

I set the ole db command task to ignore errors, however i still get the following error on execution of the data flow task....it seems to me some...

I get an error when i try to insert, i have attached the data flow and the error output message is as given below:(It's when its trying to convert the...

Thanks for the direction folks! i am getting what has to be done, just still trying to figure out how to update the destination tables with data from...

Yeah, that makes sense, now wherein do i put in the command to update the data, is it in the sqlcommand section of the component properties tab? So basically the...

I think i would just merge and create a unique id with a reference id back to the old table in case i need to perform updates.