can you please explain in brief how to use,we have to script task in any loop container

can you please explain in brief how to use,we have to script task in any loop container

Hi all,

Actual my requirement is like this,

I have a table which lists the list of text files, for which I have to check if they exist on the file share....

Hi ,

I have to create an ssis package regarding this,can you please explain me briefly on this.

HI Everyone..

Sorry for posting this silly question,i done it,its very simple.

HI da..

NO conversion is not necessary ,please modify my expression and repost the correct one.it will be help ful to me,its very urgent.

Hi John..

My startdatetime and enddatetime variables datatypes are object,so iam converting to string..

Hi Phil And John..

here is the exact error message

Error at Data Flow Task [OLE DB Source [16]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code:...

hi da zero..

i tried like this

EXECUTE [GetAllChangesByDateTime] "+ (DT_WSTR,30) @[User::TableName] + "," + (DT_WSTR,30)(DT_DBDATE)

@[User::StartDateTime] + "," + (DT_WSTR,30)(DT_DBDATE) @[User::EndDateTime] +"

it is giving the following errors..

Error converting...

HI ....

Actual i tried like this

EXECUTE [GetAllChangesByDateTime] "+ (DT_WSTR,30) @[User::TableName] + "," + (DT_WSTR,30)(DT_DBDATE)

@[User::StartDateTime] + "," + (DT_WSTR,30)(DT_DBDATE) @[User::EndDateTime] +"

the error message is::

Error converting data type...

Hi DA ......

I have created one Package variable with datatype string and given value like this

"EXECUTE [GetAllChangesByDateTime] " + (DT_WSTR,10) @User::TableName + ", " + @User::StartDateTime +"," + @User::EndDateTime +""

my...

HI DA ZERO...

Can you explain briefly explain how to do this,i have taken one execute sqltask and execute the procedure like this

EXECUTE [GetAllChangesByDateTime] " + (DT_WSTR,10) @TableName + ", "...

Hi...

i want to put all records into a variable,it is resultset.

Sorry everyone..

i have a stored procedure like GETALLCHANGESDATETIME with input variables @tablename,@Startdate,@Enddate

HI steve ,DA zero..

THanks for your supporting the issue is resolved,in my procedure for the out put parameter i have given string datatype,string is not supporting the binaray type,so i...