DBCC SHRINKFILE (JobPortal_log, 100) WITH NO_INFOMSGS

This works great for my log files!

Row.email10 = mailList10[0].ToString():"";

If this is what you meant, i still get the same error 🙁

Let me give that a shot.

Thanks

Just venting

(?<Country>.{2})-(?<State>.{2})-(?<City>.+)-(?<ZipCode>.+)\s\(

This regex worked great!

I placed it into an SSIS script and worked like a charm!

The trim was not working because the first character was a tab.

select ASCII(substring(IanVarchar,1,1)) from profiles

Once i determined the trim was not working, i substringed the values i...

I had forgotten about that, thanks 🙂

Why can you not bulk insert with a delimiter from a table?

Why does it have to be an external file?

Fixed 🙂

Thanks for the assistance!

": 8 years" This is the data in my generic field secondaryemail address - nvarchar(100)

I want to pull out the number and update the Experience column, whch is an...

I changed the Regex and now it processes 100k records in 3 minutes 🙂

yes RAID1, i have more drives on order, and will move the data to a RAID10.

I think the regex is what is killing me here!

Two for the o/s

Two for the data

I am waiting for more carriers to add:

Two for the TempDB

Two for the Log Files

I thought the performance would be better, based on the...

Error1Error loading email integer works on experience JobPortalIANDB-Load of CB resumes 10-19-11 2.dtsx: The connection "{F07CF98B-1C21-4A2E-B7B2-D539D05F1AD0}" is not found. This error is thrown by Connections collection when the specific connection...

//ArrayList mailList = ValidateEmailRow(System.Text.Encoding.Unicode.GetString(Row.DocContent.GetBlobData(0,(int)(Row.DocContent.Length-1))));

ArrayList mailList = ValidateEmailRow(System.Text.Encoding.Default.GetString(Row.DocContent.GetBlobData(0, (int)(Row.DocContent.Length - 1))));

Changed Unicode to Default in the above line and it is working 🙂

The original input field was 'nvarchar(max)' and now the input field is 'text'.

The SSIS input field format is 'DT_TEXT', which i have not changed. Should it be something different for...