No,we have shared folders in old web server,and the old server is going out now.they want to move to new server for that what i have to do.

I need to...

I am getting problem in the script task -- full path failed

I have two variables

1.filename - SDE_5_7_2012.csv

2.fullpath - X:\ExportCSV\CDE_REPORTS

Public Sub Main()

...

Hi jim,

I am about to try your stuff function instead of replace function in my code,can...

Actually,what i am trying to do here is ..option to select multi select option for @as_firmselection parameter...in this drop down list i am having 3 charachters

WCM,WBNA,WBFS

Select @as_firmSelection ='''' + ...

you are saying just to replace that step instead of mine....beyond that my entire code is correct....can you correct at the replace function please its getting error incorrect syntax near...

shall i send you the entire porocedure..

Then whom i have to post the question,thats a t-sql code right?

I think your approach will work,you can create two datasets and join them into a table object.

can i use this either of teh expression

=iif(Trd_linked()=0,N,Y) or =iif(fields!Trd_Linked.value =0,"N","Y")