by the way : how can i debug a script task?

ok : the problem is that you cant debug on 64bit machine

so where is the mistake in the code i have copied from the link above,with the example?

can you give code example?

what do you mean by that?

ok

and when i drag the green arrow to the next step

how can i check there if i can go to the next step if for example the value of the...

Alvin - i have tried out to do the same as :

http://rafael-salas.blogspot.com/2007/03/ssis-file-system-task-move-and-rename.html

and i have some problems :

1)how do i add a variable as you suggested, that will count...

OK

Thanks both of you

ok

thanks for the help anyway 🙂

ok

do you have an SSIS example code that i can download and learn from how to do it?

again!

i lnow that solution,but i dont want to use it,

i was lookin to get the same result,but in another way if possible

ok

but if there are no file to move

how can i prevent from the SSIS to go to the next step?

the view is like this :

select col1 from tbl1

union all

select col1 from tbl2

......

You might want to look at using the For Each container. You can configure it to only move the files it finds. If it does not find any...

what i want for each row :

col1,col2,tableOfIname

the FileSystemObject i know from vbscript, where do i find it in the SSIS?

what i want to to is :

if there are files in the Folder them move them...

first i use it with SQL2005 (mymistake)

and the result i get is empty

the thing is that i need the result for each row in 1 query

thanks

peleg