Hi

I didn't find any direct solution for this situation.

My situation was, I want to display Reporting Services reports on Web Based Application (Report Viewer Control). And also to define a...

Hi Robert

First of all thank you for your reply..

I am running BI studio on the same server.

I am dealing with network files in the workflow, But I noticed the...

Hi All

After going through some links and trying myself I understood that, ther is no easy and direct way to handle this situation..

But...

Very nice article...

Hi Zia

You can try this

SELECT * FROM OPENQUERY(linkedserver, 'Exec pubs.dbo.SP_Get_rows')Table1

Here U r getting a Table instance(Table1)..This instance you can use for updating your real table.

Hope this will help you.

Regards

Agson C...

Hi

You can try one more way...

Create an 'Execute SQL Task' for getting Source Table name

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

Ex:- Select Source_Table from Table_Names

Store the out put in a Global Variable....

Create an 'ActiveX Script Task'...

Nice Article..Very Helpful

  I have a small doubt regarding the 'Print' Option provided in the article..I created a SQL DTS Package with an ActiveX Script Task(With a Print Statement).Then I...

Hi Phill Carter

Thanks for your suggestion..I will try it out..

Regards

Agson Chellakudam

Hi Yan

Hope below link will answer your question regarding 'dt_adduserobject'..

http://dbforums.com/archive/70/2002/03/4/331642

Regards

Agson C A

Hi All

At last this issue have been Solved!!..After installing Service Pack3(MS SQL 2000), this issue have been solved..

since I went for a long vacation..I couldn't post it...

Regards

Agson

Hi All

At last this issue have been Solved!!..After installing Service Pack3(MS SQL 2000), this issue have been solved..

since I went for a long vacation..I couldn't post it...

Regards

Agson

Good Article!!..Simple presentation....Keep it up..

Hi Joseph

U r article is excellent!!!...

A small problem i noticed it, though it is working successfully, data getting appended with old data, so in effect SQL Excecute task is not dropping...

Thanks Calvin..

Actually I noticed one more thing..Small size(in Kbs) files are getting downloaded..But if I am trying to go for a large size file(2 to 3 Mbs), It is not happening!!!!

I...

Hi

I have faced the similar problem..But in that case 'select query was returning duplicate rows.

So I just given group by of all selected fields and the issue was solved

Agson...