Suppose i have 250 records. If i tried by the above suggested queries i am getting 3 .All fine. But how to confirm those are the recoeds in 0th ,...

thanks prasad.

went thorugh the links but the problem still persists

Thanks for the reply.

I have gone thorug the website before but ia m still confused.

3GB /PAE switch comes into picture when i have 4 GB of RAM(certain versions) , and it...

first of all thanks for the reply, as at last i got one reply

1) As i mentioned when i am running it through QA it is running fine, only when...

i would appreciate if some one could me help me on this.

Regards,

Deb

Thanks everybody . Superb responses. I am going for a temp table approach.

1.Execute SQL task (create a temp table at the same DB)

2. On...

Thanks for the suggestion

how can  i create a temoprary table every time the DTS is run without haivng a permanent temporary table and store the data from csv file into...

Pls ignore this post.

Admin - Could you please delete this thread.

Thanks,

Deb

even i tried of doing that !!!.but there was a confusion in the quotes sign so i didnt tried it finally

Thanks anyways...

Deb

Hi Arvind,

here is the script..

It is run on boredev.workshop

SET NOCOUNT ON

  DECLARE @TableName sysname,

          @TableCount INT,

          @sql varchar(400),

          @cnt INT,

          @i...

Guys,

1. if there is no key defined  in a table , in that case will sysindexes contain the rowcount.

2.One more thing how to convert a row from Null to 0,if...

Any assistance would still be appreciated

Deb

Awesome !! It worked.

Earlier It used to take 35 minutes.

Arvind - Your suggestion brought it down to 25 minutes !!!

David -  Your suggestion brought it down to whopping 30...

Well the links were really useful(infact i have already visited few of them earlier).I would really appreciate if somebody who had been exposed to such error in past can just...