caippers (1/2/2014)

---

I do the only question I have is I don't see a consideration for the left and right parentheses. Wouldn't this miss that if a number was missing...

The question would be, what do you want?

SSIS and SSAS are great tools for BI development. If you already know SSRS, you can go all the way.

You must evaluate both...

Thank you for all of your recommendations. I will try all of them (I might not be able to use the error file because of permissions to write on disk).

I...

Yes and no.

All import utilities from SQL Server (bcp, bulk insert, openrowset, SSIS) have options to handle errors. The first 3 have the errorfile and max errors options. SSIS has...

You could use an errorfile during the import operation to validate your values. Be sure to have an acceptable value for MAXERRORS to avoid the import to fail.

Is there a formula to obtain the name for each week? or will someone define it manually?

If you go to the connection properties, look for Expressions and use the expression...

This seems to work fine, unless you have other 4 digits number in your string.

If you have any questions on how it works or why did I used something,...

Remember to use the option to enable triggers (FIRE_TRIGGERS) or the result will be the same.

Maybe this will avoid errors.

CAST( CASE WHEN CHARINDEX('T', c3.value('@runDate[1]','varchar(30)')) = 0

THEN STUFF( REPLACE(c3.value('@runDate[1]','varchar(30)'), ' ', ''), 11, 0, 'T')

ELSE REPLACE(c3.value('@runDate[1]','varchar(30)'), ' ', '') END AS datetime2)

But the best...

It's hard to give an answer as I don't know your table or xml structure. Could you give a sample of values for the following query?

SELECT c3.value('@runDate[1]','varchar(100)') as runDate

FROM xmlResults...

I believe that Lynn was referring to what command did you use (eg. INSERT INTO, BULK INSERT, bcp, etc).

Just a guess, but your runDate in the XML might not have the correct format or might be an invalid date.

Hi,

To get better and faster answers, you should post DDL and sample data in a consumable format as I did this time for you. (It seems that you edited your...

petr.caslavka (12/30/2013)

---

This is definitely a better way of doing it. However, I am not sure about the TRUNCATE TABLE ps_micros_e7_time_clock_details statement. I don't want/need to truncate the table altogether as...

If there's no primary key, then performance won't be great. Even if there's no PK defined as a constraint, you could identify a PK that will help you identify duplicates.

Here's...