create table test2

( Id VARCHAR(20),

Location VARCHAR(255),

[Status] VARCHAR(20)

)

drop table test2

insert into test2

select '1','LocABCD','Active'

union all

select '2','LocABCD','Closed'

union all

select '3','LocDEFG','Closed'

union all

select '4','LocDEFG','Active'

union all

select '3401','FOOD & LIQUOR','Closed'

union all

select '3422','FOOD & LIQUOR','Active'

union all

select '3623','FOOD &...

Hi,

first of all thanks for your reply. It would be appreciable if you can share more information on my problem.

Thanks.

Moderators,

Can you please throw somelight on this problem.

It is very urgent task and I need help from you guys.

Thanks

Hi Everyone,

Can anyone provide me any solution or idea on this problem?

Thanks in advance

I want to know the names of the zip files and its creation time and I am not concerned about the contents inside the zip files. The reason...

Hi lowell,

I apologize if my post is not clear enough. I just want to loop through zip files inside the ftp site folder and I am not trying...

I am just using the standard input variable and one more small change what I did just now in compare to changes what I posted in my first post are

executable...

Hi phil,

No apologies please. I already tried replacing the success value from 0 to 1. When I change success value to 1 and then execute the task...

Hi Strickyn,

As I mentioned if I am executing the dos command manually I am able to get the result without any error.

Thanks

Hi Phil,

The dos command is there in my first post inside the variable value DOSCMD.

please let me know if you need any other info.

Thanks

Hi,

First of all thanks for your reply. The process is not VB or C# program I am trying to execute the dos command inside EXECUTE PROCESS TASK.

Thanks in advance.

Can anyone helpme urgently.....as my whole process got stuck with this problem.

Hi,

Please let me know if anyone has any solution to this problem.... its urgent.

Thanks

Hi all,

I apologize for not posting the error message. I am attaching the error screen shot for your reference and also I am giving the specific error message...

Hi Elliot and Divyanth,

Thanks for your replies. I will try with your solutions and I'll let you know whether I am able to execute the table valued function...