Hi guys thank you for your reply, I created below CURSOR and its work fine,

DECLARE @sidint

Declare InsertSID Cursor For

Select DISTINCT Sid from MDB

where ADate = dateadd(day,datediff(day,1,GETDATE()),0)

...

Here is more explanation with test data.

fIRST STEP-

Main Query

S.p = USP_SUMMARY

Create Procedure USP_SUMMARY

@R_TypeVarchar(50)

as

Begin

SELECT * FROM Sales

Where R_TYPE IN (@R_TYPE)

End

Second Step:-

First Parameter

Parameter_Name = T_TYPE

SELECT DISTINCT T_TYPE FROM SALES

Third Step:-

Second Parameter

Parameter_Name...

I am creating a report in SSRS that's y i am creating Parameter in SSRS Instead of main query. I can't create same Parameter twice (Main Query & SSRS). If...

Jeff,

Thanks for your reply and advice, if you can show me right path/ articles/tutorials that you can think is good learning for me that would be great, if you...

Jeff, I really appreciate your reply in detail. I will definite need your help here. Please could you provide me your email add so i can fwd SP to you.Once...

Thanks for the Clarification Old Hand!

Thank you guys.

If i am understand right you are saying "what is the point of my Original Question?" Or you are asking my second reply?

Thanks for Prompt reply!

I mean lets say i am using bunch of Select Statement on Employee Table & at the same time other user trying to insert or delete on...

Thanks for your reply, Here is the Solution,

In solution properties, Run64BitRuntime = false.

-----------ANSWERED-------------------------

Guys, I thought there is no special way, just use Source (Flat File) and destination is my Oracle DB. Everything is looks ok before i run my package. I test...

Here is the problem, I can't select that folder, that have all .pdf files. If you please explain me it would be great. Thank You!

Thanks for reply, But how i can use .pdf as a source, which source should i use

ADO NET Source, Excel Source, Flat File Source, OLE DB Source, Raw File Source...

Thanks for help. I config my package on my machine and copy it to client machine, Here is my problem, i want to know how i can change my xml...

Thanks Jeff!

Its work fine.

Jeff thanks for reply and good question, but in my case i don't have any PO Box Address.