Yes,I am in developer position,but wanted to know the reason from a DBA perspective.....Thanks for the help ...Do you see any reason for that to happen?

Hi all,Thanks for your replies

Let me tell you guys the exact issue I have.

We have a table in the SQL...

And one more thing,

When I use the select query on that table in a UDF,it executes with out any error,but if I use the same select query separately it fails...

And one more thing,

When I use the select query on that table in a UDF,it executes with out any error,but if I use the same select query separately it fails...

To just check the Permission set on that table,

I used a Table valued function,but it didn't return any rows.

SELECT *

FROM fn_my_permissions('tablename', 'OBJECT')

0 rows returned

which tells me the permissions are...

I created a job and put T-SQL statements in it

alter table

alter column

and the job failed.

i have declared a package variable counter with a value 0.

@Count=0

In For loop i have

InitExpression @Counter

EvalExpression

AssignExpression @Counter+1

What should be there in evalExpression and should the email task...

Thanks for the reply...Can u elaborate on the point you made?

Thanks for the help guys...It did work for me using for each loop and I think I should go ahead with foreach because I might be getting multiple files in...

Hi Guys,

I too need solution to the same problem.The file names I have follow a certain pattern but...