ramonaraujop (10/5/2009)

---

to do rollback in a right way,

I wrote:

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

BEGIN Tran t1

DROP TABLE T

go

ROLLBACK

GO

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

SELECT * FROM T

the Question of the Day was wrong, I guess, so, was completed with...

I hope you had created a Data Source using this query.

Lets day data source is dsMain.

Now follow the below steps:

1. Pick a new table control

2. Drag and drop required fields...

Problem is with Parameter data-type. If you change the parameter from CHAR(8) to datetime, it should work fine.

When I run below query, it gives correct...

I also agreed. This statement should work fine.

May be problem is there in some other statement.

You can achieve this by following these steps:

1 Insert a Table Group on Date Field.

2. Check the "Page Break at end" property for this Group.

Hi Abhijit,

Declare a string variable in the package.

in the Excel Connection Manager, Reference this variable for Directory.

Sridhar,

I am sure you are doing some mistake in Connection String.

Could you explain the ConnectionString properties you are using in your package.

AS long as there is no dependencies between those tables, you can use same Data Flow Task and apply Parallel Transformation.

But if the tables are dependent, we should avoid this...

Try to execute the package using following command through command prompt:

"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\dtexec.exe" /FILE "PackagePath" /CONFIGFILE "ConfigfilePath"

I had same problem but could not resolve this. I dont think there is any way to hide the parameters at run time. There are some limitations of SSRS.

Hi Rox,

It would be better to convert your Stored Procedure into a Function, if possible. Then you can use function in WHERE clause.

If you can't convert it into the function...

Its Better to Rename both the columns instead of doing this stuff.

Naveen,

Try this:

DECLARE @Output smallint

EXEC @Output = ProcName

SELECT @Output

If @Output value is 0 then SP is executed successfully. If it is less than ZERO then there is an error.

No,

In that case, you can select the table (don't click on columns, just select table) and set the border color as you wish.

This will resolve your issue.

Vikas,

Its also easy to implement. You need to change the expression as mentioned below:

Default = None

Left, Right,Top and Bottom (all)

=IIF(Fields!ID.Value=Previous(Fields!ID.Value),"None","Solid")

Let me know if you have still any problem.