Viewing 15 posts - 106 through 120 (of 156 total)
Thanks for the answer.... i am going to look in to what u have suggested.
also it appears its the script that is failling to run in the package
Insert epal_userdata
select...
February 10, 2011 at 9:40 am
the user does have datareader and datawriter permission on the table/database.
so how can i go about it...meaning how to fix this constraint/duplicate key issue..
sry i am a bit clueless...
February 10, 2011 at 8:44 am
First of all thank you so much for fast reply.
I was going towards the same direction but ... what stopped me was this is the same code and same...
February 10, 2011 at 8:30 am
ok , thank you so much for the answer.....
i understand what u mean ..... my issue is if i dont put it in master.... i cant transfer logins with the...
January 28, 2011 at 11:21 am
We are still trying to figure out what is the reason ,
increasing the Tempdb files are a way to clear the alert that tempdb is filling up.
Thanks
January 27, 2011 at 11:06 am
there was a IO bottleneck, and thats especially when tempdb is getting used.. also we had a alert recently that tempdb was reaching its limit.
January 27, 2011 at 8:33 am
thanks for the fast response,
Even if it doesnt help( 1 file per core) , but as far as what I know or have read.... placing the files on a seperate...
January 27, 2011 at 8:19 am
just wondering.. if the job is running on principal server , migrating to mirror server , than i suppose it means the ssis package is working.
does ssis package work on...
January 21, 2011 at 7:20 am
The job has been running since it was creaed until last night. funny thing is the job is still running perfectly on the production server.
Sry i dont know what u...
January 20, 2011 at 1:30 pm
SSIS package.
the package was created on production and job ran on it, still runing there , from production it moves using a sql transfer job task in ssis package and...
January 20, 2011 at 1:11 pm
the first node said simply " The Job was invoked by User sa. The last step to run was step 1 (step1).
and the second node says " domain\sqlagentaccount....
January 20, 2011 at 12:50 pm
any one has any idea??? I am banging my head to the wall here for hours .
January 18, 2011 at 1:21 pm
May be i need to change some setting in ssis ... as far as i know i have changed it all.
any help would be much appreciated.
January 18, 2011 at 8:31 am
I understand the SP. but the problem is when the execute the sql task run , it is looking for the domain\user as its showing in the error. that user...
January 18, 2011 at 7:44 am
Viewing 15 posts - 106 through 120 (of 156 total)