Hi

If i use sp_msforeachtable commands within DTS as one of the step, its not unchecking the constraints. If i execute it in query analyser its working.

why?

Hi

I tried earlier as u said. But when its executed in the other named instances of sql server its showing the error "Cannot open datatbase "DBNAME" requested...

Hi

I refered http://www.sqlservercentral.com/articles/DTS/portabledtspackages/865/

I followed the article. I couldnt set “On Success” workflow from Dynamic Properties task to connection 1.

If i select these two workflow property is...

Hi

I tried with Switch. Not displaying any value. Now I added n columns for n parameters. For each Column visibility property I set the expression like

=iif(Parameters!parameter.Value="G",False,True)

Now I got my...

Hi

Yes I having values. Still searching the solution

Soundari

Hi

For all parameter values I am getting Gender only

Soundari

Hi

Thank you Mr.Nigel. I thought it may overload the database server. Anyway now i put decrypt function in the sql server and decrypting in the SP. Working fine.

Thank...

Hi

Thank You very much for your valuable reply. Now Removed the dropping and creating the view part from SP and its working fine.

Soundari

Hi

I am using SP only. The problem is my values are encrypted at the backend.

I have to decrypt using my own procedure before displaying in the...

Hi

Thank you for you reply. Now I am trying with VS 2005 Reporting Solution which will point to 2000 database. If anywhere i struck i may need ur help

Thank...

Hi

The following link is giving some useful information

http://www.sqlservercentral.com/articles/Performance+Tuning/ospr/666/

Latha

Hi

Thank you. CAST function worked for me

Latha

Hi

select (1*100)/9 which will give the result as 11

select (1*100.0)/9 which will give the result as 11.111111

select round(((1*100.0)/9),2) which will give the result as 11.110000

but i want...

Earlier how i was struggled to list out the columns in the tables because all my tables are more number of columns. Your idea of just dragging and dropping is...

Hi

Thank you for your reply. But I am having more than 50 columns. Any other better solution?

Latha