Mail failure in DTS package

Hi, Im trying to do a DTS that exports data to a excel file and then
mail it. It runs fine all way throw until the mail object get an
error. Like this:
Logon failed: Unable to get the default MAPI Message Store due to MAPI
error 273: Det g=E5r inte att =F6ppna informationsarkivet.
Does any one know what to do?
Cheers! /Karinkarin.w74@.hotmail.com wrote:
> Hi, Im trying to do a DTS that exports data to a excel file and then
> mail it. It runs fine all way throw until the mail object get an
> error. Like this:
> Logon failed: Unable to get the default MAPI Message Store due to MAPI
> error 273: Det går inte att öppna informationsarkivet.
> Does any one know what to do?
> Cheers! /Karin
Hi,
It sounds like the user that runs the SQLServer service hasn't got
access to logon to either the mailbox or to the Exchange server you are
using. You might have to check the the user that runs SQL Server also
is the one that has an Outlook profile setup on the server - otherwise
you might run into the problem.
Regards
Steen Schlüter Persson
CRM System Specialist / DBA
Denmark

Mail failure in DTS package

Hi, Im trying to do a DTS that exports data to a excel file and then
mail it. It runs fine all way throw until the mail object get an
error. Like this:
Logon failed: Unable to get the default MAPI Message Store due to MAPI
error 273: Det g=E5r inte att =F6ppna informationsarkivet.
Does any one know what to do?
Cheers! /K"liteblandat@.hotmail.com" wrote:
> Hi, Im trying to do a DTS that exports data to a excel file and then
> mail it. It runs fine all way throw until the mail object get an
> error. Like this:
> Logon failed: Unable to get the default MAPI Message Store due to MAPI
> error 273: Det går inte att öppna informationsarkivet.
> Does any one know what to do?
> Cheers! /K
>
Hi
Are you running this package from the designer or a job? The issue is that
the account under which it is running, does not have access to the MAPI
profile that you have configured for SQLMail. Check the accounts that SQL
Server and SQL Agent have been configured to run as and that they can access
the profile you have set up. Try logging in on the server as these accounts
and sending a test email.
HTH
John

Lsit of sql object owners

Hi,
What tsql statement do i need to run to get a list of all sql objects'
owner?
Thanks
What version of SQL Server are you using?
"Mecn" <mecn@.yahoo.com> wrote in message
news:Oi7rmRmlIHA.3876@.TK2MSFTNGP06.phx.gbl...
> Hi,
> What tsql statement do i need to run to get a list of all sql objects'
> owner?
> Thanks
>
|||SQL2K sp4
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:03024435-8BF2-4036-84C1-A8EC991B7187@.microsoft.com...
> What version of SQL Server are you using?
>
> "Mecn" <mecn@.yahoo.com> wrote in message
> news:Oi7rmRmlIHA.3876@.TK2MSFTNGP06.phx.gbl...
>
|||SELECT 'Table',TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
UNION ALL
SELECT 'View',TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.VIEWS
UNION ALL
SELECT 'Procedure/Function',ROUTINE_SCHEMA, ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES;
"Mecn" <mecn@.yahoo.com> wrote in message
news:eaSwkJnlIHA.3636@.TK2MSFTNGP02.phx.gbl...
> SQL2K sp4
>
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
> message news:03024435-8BF2-4036-84C1-A8EC991B7187@.microsoft.com...
>
|||It worded,
Thanks a lot
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:632943B2-7BD5-45C3-9C61-E28CA44C5A3D@.microsoft.com...
> SELECT 'Table',TABLE_SCHEMA, TABLE_NAME
> FROM INFORMATION_SCHEMA.TABLES
> UNION ALL
> SELECT 'View',TABLE_SCHEMA, TABLE_NAME
> FROM INFORMATION_SCHEMA.VIEWS
> UNION ALL
> SELECT 'Procedure/Function',ROUTINE_SCHEMA, ROUTINE_NAME
> FROM INFORMATION_SCHEMA.ROUTINES;
>
>
> "Mecn" <mecn@.yahoo.com> wrote in message
> news:eaSwkJnlIHA.3636@.TK2MSFTNGP02.phx.gbl...
>

Lsit of sql object owners

Hi,
What tsql statement do i need to run to get a list of all sql objects'
owner?
ThanksWhat version of SQL Server are you using?
"Mecn" <mecn@.yahoo.com> wrote in message
news:Oi7rmRmlIHA.3876@.TK2MSFTNGP06.phx.gbl...
> Hi,
> What tsql statement do i need to run to get a list of all sql objects'
> owner?
> Thanks
>|||SQL2K sp4
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:03024435-8BF2-4036-84C1-A8EC991B7187@.microsoft.com...
> What version of SQL Server are you using?
>
> "Mecn" <mecn@.yahoo.com> wrote in message
> news:Oi7rmRmlIHA.3876@.TK2MSFTNGP06.phx.gbl...
>> Hi,
>> What tsql statement do i need to run to get a list of all sql objects'
>> owner?
>> Thanks
>|||SELECT 'Table',TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
UNION ALL
SELECT 'View',TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.VIEWS
UNION ALL
SELECT 'Procedure/Function',ROUTINE_SCHEMA, ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES;
"Mecn" <mecn@.yahoo.com> wrote in message
news:eaSwkJnlIHA.3636@.TK2MSFTNGP02.phx.gbl...
> SQL2K sp4
>
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
> message news:03024435-8BF2-4036-84C1-A8EC991B7187@.microsoft.com...
>> What version of SQL Server are you using?
>>
>> "Mecn" <mecn@.yahoo.com> wrote in message
>> news:Oi7rmRmlIHA.3876@.TK2MSFTNGP06.phx.gbl...
>> Hi,
>> What tsql statement do i need to run to get a list of all sql objects'
>> owner?
>> Thanks
>>
>|||It worded,
Thanks a lot
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:632943B2-7BD5-45C3-9C61-E28CA44C5A3D@.microsoft.com...
> SELECT 'Table',TABLE_SCHEMA, TABLE_NAME
> FROM INFORMATION_SCHEMA.TABLES
> UNION ALL
> SELECT 'View',TABLE_SCHEMA, TABLE_NAME
> FROM INFORMATION_SCHEMA.VIEWS
> UNION ALL
> SELECT 'Procedure/Function',ROUTINE_SCHEMA, ROUTINE_NAME
> FROM INFORMATION_SCHEMA.ROUTINES;
>
>
> "Mecn" <mecn@.yahoo.com> wrote in message
> news:eaSwkJnlIHA.3636@.TK2MSFTNGP02.phx.gbl...
>> SQL2K sp4
>>
>> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
>> message news:03024435-8BF2-4036-84C1-A8EC991B7187@.microsoft.com...
>> What version of SQL Server are you using?
>>
>> "Mecn" <mecn@.yahoo.com> wrote in message
>> news:Oi7rmRmlIHA.3876@.TK2MSFTNGP06.phx.gbl...
>> Hi,
>> What tsql statement do i need to run to get a list of all sql objects'
>> owner?
>> Thanks
>>
>>
>