Oledb

Hello, If you pass a single value, it will work fine, but if you pass multiple values as you are doing 300,301,302, it will not take. You better stay with building your query , Execute SQL Task--> Expressions-->SqlStatementSource and then build your query in expressions. Thanks Aamirhttp://sqlage.blogspot.com/

Hi Aamir, thnka for ur reply ...... actually i am splitting that comma seperated string by using split function ...... and i am loading it into some temp table ..... as i mentioned above ...... While i am taking the query from variable it works fine .... when i taking it from the query the prob occurs .... Y it is not passing the string value into ? and i will try what u say ..... Thanks, Apps

Thnaks Aamir .... i got it ..... Regards, Appy .

Or in the query you could start by declaring the variable at the beginning of the query and set it by the parameter. And later use this variable in the query as many times you want it to...My Blog | Ask Me

Hi Sudeep, I tried like that also ..... Declare @a varchar(50) set @a=? and i am passing this variable into sql query .... &&& i tried with sp also .... finally i got it ...... as aamir's way ... Thanks, Apps

Hi All ... Thanks for all ur valuble responses ..... Here is one situation ..... initially i need to execute the package and some records loaded into table ... and i am passing the null value .... in place of comma seperated value ...... Later if i pass the comma seperated value ...then i need to execute the package from stopping point .... no need to rerun entire package .... like only updation part .. Thanks & Regards, Apps

Hi All , Plz reply me ..... My package is not failing at any conditions .... Only thing is based on variable value changed ... i need to reexecute the packge from stopping point .... Is it possible ...... Thanks Apps

Start a new thread for a new question as people generally donot open the closed threads. And your requirement is not very clear.My Blog | Ask Me

I am using sql 2005 ... Im facing this issue in ssis Execute sql task ..... when i am selecting the sql query from variable it works fine ..... like this "if object_id('temp..#tmp_app') is not null Drop table #tmp_app select id=identity(int,1,1),* into #tmp_app from dbo.split_app('"+(DT_WSTR,20)@[User::Users]+"',',')" when i am writing a sql query directly in Execute Sql Task .... like this if object_id('temp..#tmp_app') is not null Drop table #tmp_app select id=identity(int,1,1),* into #tmp_app from dbo.split_app(?,',') and i am mapping the parammeter with 0 possition ..... and it is not taking the varible .... into ? ....it is taking ? only directly ..... in the varible i am passing like this 300,301,302 .... I tried everything ..... Thanks in advance .... Apps

what is the connection type? is it OLEDB or ADO.NET?My Blog | Ask Me