Ya thats correct!

But i did not want to loop as it adds more tasks to the pkg.

Hi,

we have scenario something like this

mapping table resides in sql server

it have data in mapping table as shown below

codeflag

Ascrapped

Brepaired

Crepaired

Dmodified

i have a table in oracle from where i need to extract...

Hi Kingston Dhasian,

i implemented as per your inputs it is working as expected.

thank you!!!

Hi Brain,

first query also running as

' select name from dbo.Proposal where ProposalId in ('+ @SampleArray +')'

let me re frame the question while it is passed to dynamic SQL it...

Hi,

if i use Print SQL

i am getting below query and it is fine.

select name from dbo.Proposal where ProposalId in (1,2,3)

where as in static sql it is thrrowing error cannot convert...

Hi Koen,

as per your suggestion,setting the property of excel while reading the data worked fine

Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

thank you!!!!

Hi,

sorry i did not go through the link....

i just checked now,it is providing good info.I will try that and let you know the results...

Hi,

There is also another way to change the way the Excel drivers 'determine' the datatype of a column and that is to use the IMEX=1 switch on the connections string.

Could...

Yep,you are right.

But in that case, if first 10 rows are integer then we might have to hardcode some sample values in the first row so that table will be...

Hey Hi,

I know we can use SSIS to get data from excel and load in to SQL table from where i can achieve requirements.

I thought of using only SQL to...

coool....

thank you for your help.

Hi,

Actually i have not build any SSIS package yet,i was going through the deatils in google to check how to read Oracle data using OLEDB source.

http://msdn.microsoft.com/en-us/library/windows/desktop/ms719652(v=vs.85).aspx

it was mentioned...

Great info!

ya i checked the values, all the values will be selected in the query and i could see records for all the values.But prob is only displaying those parameters...

hi,

we have four 5 parameters totally

hierarchy(to select hierarchy 1 or hierarchy 2)

region(to select region when we go for hierarchy1)

country(to select country based on region selected for hierarchy 1)

customer(to select customer...

yes i have used the if condition.

it says

if(hierarchy-1)

(

display values for region and country parameters

)

else

default value

if(hierarchy-2)

(

display values for region and country parameters

)

else

default value

but in this case

when i select hierarchy...