I agreed with Ashok. 🙂 Better to use Toggle property, It'll increase performance as well because report will not render again.

But in case of Sub Report, when you click on...

Its a simple expression of SSRS and you can use it in ReportItem (TextBox).

Yes... If you give the correct path in command.

Try This:

dtexec /FILE "PackagePath" /CONFIGFILE "ConfigFilePath"...

I think the best way would be having function in code window:

Public Function Total(FirstN as object, SecondN as object, ThirdN as object) As Object

Total = FirstN +...

Hi Seenu,

Try this query and modify accordingly

SELECT COUNT(*),type_desc FROM sys.objects

GROUP BY type_desc

Pavan,

You can try these links:

http://www.programmersedge.com/?p=56

http://vyaskn.tripod.com/sql_server_2005_making_ssis_packages_portable.htm

Never forget to set ConnectionString property of your Connection Manager with package variables.

Jon,

May be you are trying to store data out of range because size for productID_PK is Numeric(1,0).

Try This example:

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

Declare @N Numeric(1,0)

SET @N = 10

Select @N as Number

You will get below...

sar_kan25 (2/2/2009)

---

I am selecting 25 entries from the table

For first five rows I want to add some common feature and select

For next five rows I want to add some another...

Keith DuAime (1/30/2009)

---

I don't understand why I get Ambiguous column name when using a union and order by statement. I thought the order by was supposed to use the column...

Try This:

CREATE TABLE #A (ID int)

CREATE TABLE #B (ID int, Code varchar(10))

INSERT INTO #A SELECT 1 UNION SELECT 2

INSERT INTO #B

SELECT 1,'abc' UNION SELECT 1,'def' UNION

SELECT 2,'pqr' UNION SELECT 2,'lmn'...

I believe you can do it very easily without two loops.

Just give some sample data along with O/P required.

Keep Smiling...

Anyway, This should work:

EXEC sp_depends @objname = N'TableName'

Girish,

I believe that you can go for COALESCE function.

And if you want to use T-SQL command then use sql_dependencies

SELECTTOP 10 * From sys.sql_dependencies

WHERE [OBJECT_ID]= OBJECT_ID(N'ObjectName')