Thanks, the same kind a query got worked.

Regards

Viji

hi,

thanks for your reply.

it got solved once i changed the "existing file" to "existing folder" option

thanks

regards

viji

Hi,

Thanks for your replies

We started taking care of EDI files from VB.NET environment as we couldnot handle it in SSIS.

Thanks,

Regards,

Viji

Hi Steve,

I did the same.

and following is the link to that.

http://www.sqlservercentral.com/Forums/Topic625677-364-1.aspx

Thanks,

Regards

Viji

Hi,

i'm facing the same problem.

I don't know how to give access only to SSIS packages.

could please explain me that?

Thanks

regards

viji

correct mukthi,

but how to go about it is my doubt.

the steps involved and i'm from database side and i don't know VB.net to write scripts.

but if the ways are clear...

Hi Mukti,

I'm creating in the same way. but when i issue

select clientid, servername from clienttable

i'm getting multiple rows and each client is having separate dates and timings for...

hi,

i'm trying something what you people are discussing.

it means that, store procedures should be written in C#or VB.NET, (but the coding is nothing but mdx queries and not conventional coding??)kind...

Thanks Chris. i'll try both

Take care

Regards

viji

Thanks chris. nice explanation.

Could you please suggest some thing to get best performance on this??

thanks

regards

viji

amazing chris it works.

but i couldn't understand how it works. could you please explain me how it works.!!!

thanks

regards

viji

sorry i didn't because, for us '%' means 'all' and if storeattribute is '%' the storeattributevalue will also be '%' and there is no column in the database to deal...

sorry, let me explain the scene fully.

it is something like if it is '%' then select all the locationkey from stores.

if it is 'country' then select the attributevalue of that...

Thanks Chris, Even before I went to the same page while searching for this information_schema view. But might be because of my laziness i didn't go through all the...

Hi Adi,

Thanks its working !!! really it is highly helpful

i was trying with something storeprocedures and not with routines.

By the way can you give me either list...