Step 1:

get the Export working outside of the job using your preferred way (e.g. from SSMS and save the export as SSIS package or use bcp or whatever).

Step 2: wrap...

I cannot confirm what you describe. Please provide sample data that allow us to verify the scenario. The following works just as expected (no output):

DECLARE @t TABLE (CodeName CHAR(2), ...

CirquedeSQLeil (1/22/2010)

---

For me there are a couple of points of interest. What is a fair and equitable split? Do you want the Client as a repeat client? ...

I'm at the customer side (at least at the moment).

The statement

indicates to me that you've been hired as a subcontractor.

If there would have been...

Pac123 (1/22/2010)

---

I'm sorry what i had meant was- It would be possible to store the source data as XML. There are thousands of these records in the DB. If there...

Would you mind to provide table def, some sample data and expected result? Please have a look at the first article in my signature on how to do it the...

Glad I could help! 😀

Based on your statement

I assumed you'd be able to convert it into "real" xml format.

I tried to use the html format and...

If you could get the source data in xml format it'll be an easy task to do...

DECLARE @t TABLE (ID INT , Conten XML)

INSERT INTO @t VALUES(1, '<a id="AB123">sometext </a><a...

Glad I could help 🙂

Now...

Before trying to resolve this issue one question:

Would it be possible to store the data in xml format instead of html?

Reason:

String parsing is dangerous since it might lead to unexpected...

Maybe something like this?

Note 1: I used the tally table as described in the related link in my signature to generate the weeks

Note 2: You may notice that this year...

If you still get the same error that basically means that you the procedure "Student_InsteadOf_Del_Trg" is stilled called (maybe by another trigger?)

Just being curious (I noticed line #308 for the...

DECLARE @v VARCHAR(30)

SET @v='CA*461*NN'

SELECT LEFT(@v,LEN(@v)-3)