Hi Jody Andrews, Grant Fritchey, ALZDBA,

Thanks for your valuable input. Jody, I agree with you that smaller columns takes less space when we create index to increase query performance...

Just replying to make others clear that issue has been solved after running update statistics as told by Marc. My sincere thanks goes to Marc.

Thanks ALZDBA for your response. "Autoshrink" option is turned off. Finally, it worked. When I checked the event log, there was "tempdbfull" error at exact same time when the package...

Hi Marc/Ninja,

I've a similar post below:

http://www.sqlservercentral.com/Forums/Topic564844-65-1.aspx

Thanks

Hi Marc,

A new puzzle in this package kind of surprised me. DTS package now failed with the error quoting destination table as Invalid object. However, when I check the database,...

Hi Marc,

Thanks for your response. Actually, I didn't include some of the information in my previous post so that we can concentrate only in the task with problem. I have...

Hi,

I just figured out that I missed something on the question. Actually, the destination table in this case is a Heap table. Just felt like it will help to troubleshoot...

Hi,

Just curious, what exactly the validation error was. Most of the time, the error occurs due to data length mismatch or the use of wrong connection strings. Other than this,...

Hi,

First of all, you have some typos in the code. In the case of code where it's not working, input parameter is @feildid, which should be @ fieldid.

The second...

Hi,

Can you please explain it in a more understandable way? I'm a slow learner. I'm having a same kind of problem. I'm using "Execute SQL Task" for the query "SELECT...