This may give you clarification

assume the table structure as below, when there is invalid date value in #SourceTable such as 21/21/2001 then we simply discard the data for being updating...

Thank you Desnorton, for the Query.

Quick Check. in source table every column is vacrhar(500) but in the Target table it is DOB is date , Phone Number fields

In this case...

removed this entry as it is posted to separate new post. apologize for multi post.

Thanks

Asiti

• This reply was modified 3 years, 6 months ago by  asita.
• This reply was modified 3 years, 6 months ago by  asita.

Thank you Phil.

Would it be advisable to do it in SQL server itself, as we have some senior management they opted to use SQL server only (son interms of procedure...

Thanks Jeff, sure I will work for SQL side only. no ssis

in this case everyday the staging table ret refreshed (truncate and load from file as all columns nvarchar(500))

so from...

Hello PHil,

Would like to insert these records into separate table (so team can look into it later to check) we dont want to process that record at all. please let...

We are planning to process with SSIS, but we are not married to any particular solution. can you please guide me for some sample / post that i can do...

added Jeff please help, sorry for delay as it is bit delay to get the file to me

Thank you

Good Morning,

Apologize for delay in reponse please see attached sample file ( i mocked little bit) so all these fileds need to be loaded to final table(same structure as stg...

Thank you much for your update.

I apologize there is small change that I didnt mentioned in ealrier post I need to consider only ValidMobile =1 for MobilePhone to be used...

Apologize for my Format, I tried several ways to adjust that but no luck.

Please let me know if you need any more info on this

Thank you in advance

Sita

Hi,

This is not an assignment but kind of question from my friend to me.... list questions i did all 18 except this one

if possible please help...

Thank you SSC Guru

here is correct code that matches expected output  please help me

CREATE...

I tried that but it is nnot working properly  (LEN(description) - CHARINDEX('%',REVERSE(description)))

can you please provide any sample code

Thank you

Can somebody please help me i am using Sql 2012 please...