Thanks Shafat. I will try the link.

Thanks once again for you support.

Regards,

Arooj Ahmad

Thanks Shafat. I will try the link.

Thanks once again for you support.

Regards,

Arooj Ahmad

Hi Shafat,

I am Using SQL SERVER 2008R2. Thanks

Thanks Shafat , now its working fine 🙂

Thanks Gail and Gianluca for Swift response.

I got the answer clearly, apart from these two answer if anything is there, please let me know.

Thanks once again...:)

Hi Gail,

I have done each possibilty what I could do. I have written Grant Script and using GUI also I have given SELECT permission to all tables, but still user...

nice link.

its very helpful for me.

Thank you very much

Thank you Gentleman for giving such a good advice. I will do follow the same.:-)

I executed package in 64-bit only. I also tried with 32-bit , but issue is remain same.

Lookup table having 12 million records. we have 16 Gb of RAM.

We have five key columns , four are having data type int and one column is having nvarchar(50).

Hi Koen,

I have written query, and selected only the key column but still the problem is same.

1) In General tab, cache mode-full cache, connection type-oledb connection manager, specify how to handles rows with no matching entries-redirect rows to no match output

2)In connection tab, Oledb connection manager-...

Source db are production db, so obviously records will be increased and whatever changes is happend in live server samthing applying in the destination server through SSIS package for Reporting...

This is not a permission issue. Because from 1 year job is running, and we did not have any problem. But from two days job has started failing because the...

T is NTFS system type and data will be 12 M.