Dipti,

Your method of using sysdtspackagefolders90 table is quite intriguing and new to me.

But I usually follow this procedure to deploy the package to a particular folder:

1) With the cursor being...

I faced a similar kind of problem.

It was generating blank pages because the page size was more than what is being allocated to/used by the matrix.

I just dragged the report...

oops sorry, I misread your query.

Try the below query and check if it serves ur purporse:

select t.referece, t.date, (select top 1 ward

from tableX as t1 where t.reference=t1.reference) as ward,

(select top...

Use the ROWCOUNT Setting as below:

SET ROWCOUNT 1

select referece, date, first(ward), first(something)

from table X

group by reference, date

Regards,

Samata

Sreemati,

The query posted by mrpolecat is right and it should produce the required results.

SELECT ocr.*

FROM IMPORT_OCR_ADMIN_2000_1 AS ocr

left join IMPORT_CD_D...

Could you clarify on what do you mean by everything done on FTP site and not on shared server???

The above posted code works out everything on the FTP site but...

This is another way of the same workaround with better performance:

insert into empcheck1

select emp.*

from emp

left join empcheck1

on emp.empid=empcheck1.empid

where empcheck1.empid is null

An added functionality:

You can archive and delete the file after it has been copied over to the oracle table.

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

-- Copy the file to the archive folder.

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

SET @Cmd = 'COPY \\servername\path\'...

Nitin,

Follow the following steps:

1) Firstly create a new DTS package

2) Drag an Execute SQL Task with the following code to check if the file is present or not:

SET @Cmd =...

Nitin,

If it is a single valued parameter, you can follow what matthew has suggested.

If it is a multi valued parameter, use the following code

="End Date:"+join(Parameters!EndDate.Value,",")

Hope the above helps!

As it is prompting you for login details, I presume your report is using sql server authentication.

In the report server, navigate to your datasource (deployed already) using the DataSources option...

I think you copied over the layout of the table from another existing table in the same report.

Try re-building the table from scratch by dragging in a new table...

What do you mean by difficult to view/update?

Could you elaborate with an example please!

Using a Table, you can force an explicit page break after a certain number of rows. Because the Excel renderer creates a new worksheet for every explicit page break, you...

You need to create a schedule from the schedule tab for the job to execute at the specified time.

Make sure you check the Enabled checkbox in the schedule tab.

Regards,

Samata