Hi,

You can use the below query in the ssis.

I have taken your string in to one variable and splitted the string in to 3 columns.

There are two methods to...

Thanks for your reply. I had already mentioned in my earlier mail that without changing the stored procedure I need the solution.

Please help

Hi,

Thanks for your valuable suggestion.

Thanks,

Madhuri

Hi,

Thanks for your suggestions. I am posting the output of the results which needs to come.

my table contains below data

tbl1

-------

name dt

xxx 01-Apr-2010

xyz 02-May-2010

abc 01-Mar-2010

results should come like below

name dt

xxx 01-Apr-2010

xyz...

Hi,

Can you try the below query.

Select rollno

from tbl

where rollno not between

1 and 5000

Hope it solves your problem.

Thanks,

Madhuri

Table has so many rows i can't use hard-coded limit on this. If table has less rows then that is feasible way.I think cursor is better option to go. What...

I am using sql server 2000. Is it possible to do in sql server 2000?

Thanks,

Madhuri

Hi,

I have a table named resource.

the table structure as follows

Resource

--------

UserID

Name

ManagerId

Sample Data

--------------

UserID |     Name           | ManagerID

5000         Sandeep        10000

5001         Saket            10000 

5002         Rahul             10000

10000       Bindu               1

1              Admin              1 

6001         Test1             5000

6002         Test2             5000

7001         Test3             5001

Query i wrote to...

Thanks prashant for article.

Hi Jeff,

Thanks for reply. I tried the options you suggested in URL.

When i tried Creating Excel spreadsheets via ADODB option

"Execute permission denied for SP_OACreate & SP_OADestroy objects under database  master owner...