I am trying to reuse the ssis package from this link :

http://biresort.net/blogs/pedrocgd/archive/2009/08/06/stepbystep-ssis-extract-data-from-multiple-excel-worksheets.aspx

But if I use a different excel file name or change the variable value from '01$' to...

Thanks that worked .

The following query

SELECT DISTINCT A.Class,

CAST( CONVERT( CHAR(8), A.Origdate, 112) AS DATETIME),

SUM(A.totalpaid) As AmtPaid

FROM dbo.ad A

where CAST( CONVERT( CHAR(8),A.Origdate, 112) AS DATETIME)>= '6/21/2010' AND CAST( CONVERT( CHAR(8),A.Origdate, 112) AS DATETIME)...

If I use the query below

SELECT DISTINCT A.Class,

CAST( CONVERT( CHAR(8), A.Origdate, 112) AS DATETIME),

SUM(A.totalpaid) As AmtPaid

FROM dbo.ad A

GROUP BY A.Class,CAST( CONVERT( CHAR(8), A.Origdate, 112) AS DATETIME),A.totalpaid

HAVING CAST( CONVERT( CHAR(8), A.Origdate,...

I am getting the following error :

Column 'dbo.ad.origdate' is invalid in the HAVING clause because it is not contained in either an aggregate function or the GROUP BY clause.

I have also used the query below

SELECT DISTINCT A.Class,

A.Origdate,

...

Sorry, the replace should have been like this

strXML = strXML.Replace("</a>", "<"/a"> ");

strXML = strXML.Replace("<acronym>", "<"acronym"> ")

Thats right . Thanks again . 🙂

Thanks I changed the XSD to <xs:element minOccurs="0" name="SubCategoryId" type="xs:unsignedInt" />

It worked . Thanks again.

Also the error : [XML Source [1]] Error: The value was too large to fit in the output column "SubCategoryId" (3198).

Precision = 18 and Scale = 0

Precision = 18 and Scale = 0

<xs:element minOccurs="0" name="SubCategoryId" type="xs:unsignedByte" />

I tried to change it to DT_UI4 . But it did not help either . I couldnot change it to DT_STR . "Invalid value" error shown .

I followed what you suggested . But the SubcatId in the Output columns shows a datatype of numeric[DT_NUMERIC] and the length is disabled . So I couldnot change to something...