i have the same problem as above but here both my source and destination are sql server 2005 db. my package is for incremental load was running fine for...

i was finally able to overcome the problem. previuosly i was following the method in the link below to update my rows

http://vsteamsystemcentral.com/cs21/blogs/applied_business_intelligence/archive/2007/05/21/ssis-design-pattern-incremental-loads.aspx

and i was having problems. but now...

the screenshot of the package had been attached. i hope this provides some more insight into the situation we are looking into

A very good explanation of how to incremental loads. I have implemented it and had no problems in the beginning. But recently i am having some issues and wondering if...

Thanks Gary,

It worked. Was able to kill the process and the table is no longer locked.

This is a real good forum. Very helpful for newbies like me..:)

Thanks for your replies. but now i am a little bit confused. So when i kill the process which is causing a lock on the table, are there any chances...

It finally worked for me. I figured out the reason for my error. in the foreach loop container for the retrive file name section, I had checked fully qualified option....

i created a fresh one and did it in the way you had mentioned earlier in one of your posts by creating 6 variables, but still i get the same...

hi gyanendra,

i have specified all the values in my tasks. can you go over them and let me know where the error might be. i checked the path names for...

for the above, i executed the file sytem task for renaming for a single file without using the foreach loop container and it works fine but when i put the...

i am trying to do the same but here i have to rename multiple files in a folder with the current date. when i execute the package i get the...

i checked my data file again and it is the problem with my row terminator. the row terminator is line feed but not new line. thanks a lot for...

i also had the same problem while posting. somehow cant make it to show up.

yes i am using new line for ROWTERMINATOR

the rpevious post showed it wrong again. the row terminator in my data is[ new line]

i am sorry... there was a typo... the actual row terminator i used is:

ROWTERMINATOR = ''.