Hi Santosh,

If u really wanted to know how DTS package worked as what is the real syntex used to load the data.

Run Sql Profiler and run ur DTS package SQL...

Hi Phill,

I think u did not understand what i asked for.

I know the about given information i can have all i asked for  but u see what i asked for...

Hi,

what do u mean about seriousness.

Do this is the way u ask a person who need help?

Ok see this i tried but i am not able to get few things

SELECT...

Hi Phill,

What u think i am playing with sql server or i am joking.

DBCC PERFOM did not give all the information.

from

Killer

Hi  ,

u can use DTS package bulk insert task.

Create a sql server connection giving a sever name where u want to insert the data from bcp file and then select...

Hi,

U can use dts package and u can set parameter by using bulk insert task.

hope thus help u.

from'

Killer

hi,

use DTS Bulk insert task there u can define ur format

from

doller

Hi,

use this to resolve ur error

use master

go

xp_grantlogin 'epg\killer'

go

xp_logininfo 'epg\killer'

go

from

killer

Hi,

U can run profilor and see what process is taking time.

from

killer

u can do as anurag said but are u deleting sa user if so then u cannot delete that user.

if else then u can delete it from login window.

from

killer

Hi,

I am working on the test.

Ok so that is only the way.

Thanx.

From

Killer

Hi Chris,

It will be remembered like titanic(1912)

Every night in my dreams i see SQL i feel SQL

that is how i come to know SQL.

Far across the JOINS and UNIONS between us

that is how i know SQL.

Far near...

Hi,

There is a way but that is not good.

Just make temporary tables for all the 12 tables used for cube .

delete the data from 12 tables and process ur cubes...

Hi,

I have all the permission and the sql agent start account has log on services permission

from

killer