Already tried but no success..

Here is the settings with which I am trying:

Control Flow: IL => Serializable, TransactionOption => Required

Sequence Container: IL => Serializable, TransactionOption => Required

And all the tasks...

Thanks Keon for such a quick reply.

I tried this (TransactionOption of sequence container => Required) but the package got stuck with wait_info LCK_M_SCH_S.

you can also use the following query to get the count of records in the tables:

SELECT OBJECT_NAME(OBJECT_ID), Rows FROM sys.partitions

WHERE INDEX_ID IN (0,1) -- 0 = Heap;1 = Clustered

any updates????

For this need to change the existing stored procedure.

Anyways can you please give some sample code?

In my case the stored procedure SP1 is returning two resultsets say resultset1 (has 2 columns of int type) and resultset2 (has only one column of varchar type).

What I...

Any Suggestions!!!!

Thanks!!

Yes I am refering to connectionstring of .NET. Can you please give some sample code?

Use PIVOT TABLE.

Try this:

SELECT (CASE WHEN RecordDescription IS NULL THEN 'Total records' ELSE RecordDescription END) as Records, SUM(Count) from Table1 GROUP BY RecordDescription WITH ROLLUP

Try this:

SELECT s.name,s2.name,s.max_length

FROM sys.types s INNER JOIN sys.types s2 ON s.system_type_id = s2.system_type_id

WHERE s.user_type_id > 256

and s2.user_type_id <= 256 and s.name='urDataTypeName'

You can use BULK INSERT to import excel file into SQL Server table.

I hope this would work for you:

SELECT * FROM (SELECT Source, YearMonth, CountEntery FROM tbl) AS a

PIVOT(SUM(CountEntery) FOR YearMonth IN (2003-04,2003-05)) AS p

CREATE TABLE #T(C1 INT, C2 INT, C3 INT, C4 INT, C5 INT)

INSERT INTO #T

SELECT 1,1,1,1,0 UNION ALL

SELECT 1,1,1,0,1 UNION ALL

SELECT 1,1,0,1,1 UNION ALL

SELECT 1,0,1,1,1 UNION ALL

SELECT 0,1,1,1,1 UNION ALL

SELECT 1,1,1,1,1

SELECT...

Try this....

SELECT DISTINCT c1.Col1, c1.Col2,

STUFF((SELECT ',' + Col3 FROM Tablename c WHERE c.Col1 = c1.Col1 FOR XML PATH('')),1,1,'')

FROM Tablename c1