WayneS (10/15/2010)

---

Actually, I create all stored procedures like...

right click on table --> explore data

if they are not in the source tables then it wont process.

when you go into the DSV and preview the data for that table do you get an error?

If you try to manually insert one of the error rows into the table via t-sql does it give any more specific errors?

are there any triggers on the table?

you could...

Gianluca Sartori (10/15/2010)

---

steveb. (10/15/2010)

---

one thing you could do to make it a bit more obvious what server you are connecting to, is to define custom colours for each server...

you can use them in debugging , but surely you would remove them before putting them in to production ?

what happens when you add error handling to the destination?

We need a bit more information,

are those valid columns in the dimension source table ?

one thing you could do to make it a bit more obvious what server you are connecting to, is to define custom colours for each server under registered server -...

is the table empty when you load the data?

and are you 100% certain the data does not have duplicates.

I would put some error handling on the destination to send the...

if the files are the same structure you can either loop through them using the for-each loop , or you can use the multifile connector.

here is a good summary

http://consultingblogs.emc.com/jamiethomson/archive/2006/10/14/SSIS_3A00_-Processing-data-from-multiple-files-all-at-once.aspx...

you could do this with SSAS, one of the big advantages of using a cube is that you can have a time dimension so that you mdx can be...

parthi-1705 (10/12/2010)

---

any thing dd/mm/yyyy or mm/dd/yyyy or yyyy/mm/dd thats not a matter i need to split and store...

i'm a bit confused; are your date mm/dd/yyyy or dd/mm/yyyy

you can't use case statements in ssis expressions

http://msdn.microsoft.com/en-us/library/ms140206.aspx