Also be sure your column emp_status does not contain nulls or else a

emp_status !='01'

will not return the nulled columns. I don't know if this is the intended behavior.

So you deleted a local user account? Be careful this does not cause issues in other areas.

Hi,

Look into the function "ParallelPeriod" in...

The US post office has a NCOA (national change of address) service. They in the process maintain a standardized version of US addresses. There are companies that buy/rent this data...

Model your business processes, that will light what are your facts and subsequently your dimensions. If you are familiar with your business this shouldn't trouble you too much.

Certainly. Code repository systems work on this concept.

I wouldn't be surprised if the OP has something similar looking in the relational...

I don't believe the forum users in general like the idea of clicking on obscure links.

Might incorporating this work?

select case when isnumeric(left(DCPI_Date,4))=1

then DCPI_Date

else '19000101'

END

when doing your insert into dbo.Reliance_Master

Then later in your SSIS redirect those rows that have 1900-01-01 as the date to...

I'm sure this is not the case, but thought I should mention: make certain the ID column in your audit table is not a identity column.

Even if it does cause potentially more network traffic as a result of normal usage, that is the point of creating the connection from server A to B was to...

If a sixth column/price gets added or a new product in the family, with 'price 5' rather than 'price5' you will miss data, have to keep maintaining the query. That...

I had seen this error when I was processing tons of records on a virtual machine. My solution was breaking the query down into batches. That is, using a loop...

File groups could help if you do frequent data backups on this VLDB where you can back up each devise simultaneously. I don't read that you need to do this.

Is there a way except advanced editor to change the data type of all columns of excel source in one shot instead of doing for every columns one by one...