HI da zero ..

Can you Explain briefly how to do conversion in ssis ,i have taken oledb source,

gave one connection and in sql comman

i wrote like this

Exec GETLASTLSN @tablename='Mas_customer',@LastLSN=? output;

but...

Hi Steveb..

Now it is giving new error

[Execute SQL Task] Error: Executing the query "EXEC GetLastLSN @Tablename=?,@LastLSN=? OUTPUT;" failed with the following error: "Implicit conversion from data type varchar to binary...

HI Steveb..

YEs i want to return a binary data type,i did like what you said it is throwing error...

[Execute SQL Task] Error: Executing the query "EXEC GetLastLSN @Tablename=?,@LastLSN=? OUTPUT;" failed...

Hi Steveb..

Can you explain briefly ont this,I am posting my procedure

ALTER PROCEDURE GetLastLSN

(

@TableName NVARCHAR(100),

@LastLSN BINARY(10) = NULL OUTPUT

)

AS

BEGIN

/*****************************************************************************************************************

Gets the last LSN that was parsed during the last run...

Hi Baskar..

I did like this ,created a file connection and for that connection string in expression i aasigned the variable wchich returns the full file path on fly,in execute sql...

Hi Phil..

I will try both and let you know the status,any way thanks for giving reply.

Hi Phil..

my file is saving like this,

D:\sync_scripts\SyncScript20100806111820.sql this is file path

Hi Baskar..

Thankyou for giving reply,from yesterday onwards i am waiting,i will try this and let you know the result.

HI Raunak...

Actual my requirement is we have a oltp source,so we want to create a staging oltp.It is replica of original oltp,if any thing changes in original OLTP the changes...

Hi Everyone..

nobody are there to give reply for my question,its very urgent ,i would be thnkful to you,please give reply.

Hi everyone..

Can anyone please give reply,its very urgent.

Hi Pradeep..

i am giving my requirement ,please provide answer,its very urgent.My requirement is I have a Dll file which contains 8 variables,example like sourcedabase,destinationdatabase,sourceservername,destinationservername userid and password.so for this i...

Hi Pradeep Adiga..

I din't find any related info in that link what you posted,please provide the exact link where can i get solution.Waiting for your replies..

Hi Everyone.....

Any one Please give the reply ,its very urgent..

Hi..

Use script task to solve this,write .net code for this .