DTS Network Traffic

Hi,
I am trying to confirm a hypothesis on the Network traffic that a certain
DTS will generate, my environment is configured as follows:
Server A: SQL Server Instance to act as source
Server B: SQL Server Instance to execute DTS Package
Server C: File Server at remote location to be target server
If I run a DTS package in Server B to extract information from Server A
and generate a fixed length flat file in Server C. Is it valid to say that,
all the information required to build the flat file will travel on my network
from Server A to Server B first and then it will be dumped in the flat file
on Server C?
Is there any way to still use Server B to execute the DTS package but, have
the network traffic go directly from Server A to Server C?
Thanks a lot!
Ignacio
why dont you just have serverA execcute the DTS job straight to C?
"i-DLT" <iDLT@.discussions.microsoft.com> wrote in message
news:6871C29D-34CF-4D9C-85D8-FE08C3E420E9@.microsoft.com...
> Hi,
> I am trying to confirm a hypothesis on the Network traffic that a certain
> DTS will generate, my environment is configured as follows:
> Server A: SQL Server Instance to act as source
> Server B: SQL Server Instance to execute DTS Package
> Server C: File Server at remote location to be target server
> If I run a DTS package in Server B to extract information from Server A
> and generate a fixed length flat file in Server C. Is it valid to say
> that,
> all the information required to build the flat file will travel on my
> network
> from Server A to Server B first and then it will be dumped in the flat
> file
> on Server C?
> Is there any way to still use Server B to execute the DTS package but,
> have
> the network traffic go directly from Server A to Server C?
> Thanks a lot!
> Ignacio
|||They are on different newtorks and have different administrators, Server A's
security is much more strict than Server B which I administer.
"Immy" wrote:

> why dont you just have serverA execcute the DTS job straight to C?
> "i-DLT" <iDLT@.discussions.microsoft.com> wrote in message
> news:6871C29D-34CF-4D9C-85D8-FE08C3E420E9@.microsoft.com...
>
>

DTS Network Traffic

Hi,
I am trying to confirm a hypothesis on the Network traffic that a certain
DTS will generate, my environment is configured as follows:
Server A: SQL Server Instance to act as source
Server B: SQL Server Instance to execute DTS Package
Server C: File Server at remote location to be target server
If I run a DTS package in Server B to extract information from Server A
and generate a fixed length flat file in Server C. Is it valid to say that,
all the information required to build the flat file will travel on my networ
k
from Server A to Server B first and then it will be dumped in the flat file
on Server C?
Is there any way to still use Server B to execute the DTS package but, have
the network traffic go directly from Server A to Server C?
Thanks a lot!
Ignaciowhy dont you just have serverA execcute the DTS job straight to C?
"i-DLT" <iDLT@.discussions.microsoft.com> wrote in message
news:6871C29D-34CF-4D9C-85D8-FE08C3E420E9@.microsoft.com...
> Hi,
> I am trying to confirm a hypothesis on the Network traffic that a certain
> DTS will generate, my environment is configured as follows:
> Server A: SQL Server Instance to act as source
> Server B: SQL Server Instance to execute DTS Package
> Server C: File Server at remote location to be target server
> If I run a DTS package in Server B to extract information from Server A
> and generate a fixed length flat file in Server C. Is it valid to say
> that,
> all the information required to build the flat file will travel on my
> network
> from Server A to Server B first and then it will be dumped in the flat
> file
> on Server C?
> Is there any way to still use Server B to execute the DTS package but,
> have
> the network traffic go directly from Server A to Server C?
> Thanks a lot!
> Ignacio|||They are on different newtorks and have different administrators, Server A's
security is much more strict than Server B which I administer.
"Immy" wrote:

> why dont you just have serverA execcute the DTS job straight to C?
> "i-DLT" <iDLT@.discussions.microsoft.com> wrote in message
> news:6871C29D-34CF-4D9C-85D8-FE08C3E420E9@.microsoft.com...
>
>

DTS MAPI profile

I get "Unable to load MAPI profiles" error message in DTS Designer trying to
add "Send Mail" task.
SQLMail has been installed and configured (and tested, it works) on the same
server.
Please help, thank you in advanceWhen in the designer, it's using the current users windows
account and the current users mail profile from the location
or PC where you start up DTS.
Are you opening up the designer while logged onto the server
using the service account or are you doing this from your
PC? If it's from a PC, it doesn't matter what you have setup
on the server.
-Sue
On Fri, 11 Aug 2006 13:54:02 -0700, Leon Shargorodsky
<LeonShargorodsky@.discussions.microsoft.com> wrote:

>I get "Unable to load MAPI profiles" error message in DTS Designer trying t
o
>add "Send Mail" task.
>SQLMail has been installed and configured (and tested, it works) on the sam
e
>server.
>Please help, thank you in advance|||I'm logging on using service account (MSSQLServer and SQLServerAgent run
under this account)
"Sue Hoegemeier" wrote:

> When in the designer, it's using the current users windows
> account and the current users mail profile from the location
> or PC where you start up DTS.
> Are you opening up the designer while logged onto the server
> using the service account or are you doing this from your
> PC? If it's from a PC, it doesn't matter what you have setup
> on the server.
> -Sue
> On Fri, 11 Aug 2006 13:54:02 -0700, Leon Shargorodsky
> <LeonShargorodsky@.discussions.microsoft.com> wrote:
>
>|||If you are logging onto the server directly and logging on
using the service account used by SQL Server and SQL Agent.
And if from here you can see the mail profiles, they have
all been setup, tested and they are working correctly, and
from here you open up the DTS designer and it can't find
profiles when adding a Send Mail task, then I have no idea.
That sounds like a problem with the mail profile itself but
apparently your SQL Mail and SQL Agent Mail are both working
fine. Pretty much all of the typical issues that cause the
error you report as not being applicable so I haven't a
clue. Other than MAPI just is unreliable crap.
-Sue
On Mon, 14 Aug 2006 11:10:02 -0700, Leon Shargorodsky
<LeonShargorodsky@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I'm logging on using service account (MSSQLServer and SQLServerAgent run
>under this account)
>"Sue Hoegemeier" wrote:
>

DTS MAPI profile

I get "Unable to load MAPI profiles" error message in DTS Designer trying to
add "Send Mail" task.
SQLMail has been installed and configured (and tested, it works) on the same
server.
Please help, thank you in advanceWhen in the designer, it's using the current users windows
account and the current users mail profile from the location
or PC where you start up DTS.
Are you opening up the designer while logged onto the server
using the service account or are you doing this from your
PC? If it's from a PC, it doesn't matter what you have setup
on the server.
-Sue
On Fri, 11 Aug 2006 13:54:02 -0700, Leon Shargorodsky
<LeonShargorodsky@.discussions.microsoft.com> wrote:
>I get "Unable to load MAPI profiles" error message in DTS Designer trying to
>add "Send Mail" task.
>SQLMail has been installed and configured (and tested, it works) on the same
>server.
>Please help, thank you in advance|||I'm logging on using service account (MSSQLServer and SQLServerAgent run
under this account)
"Sue Hoegemeier" wrote:
> When in the designer, it's using the current users windows
> account and the current users mail profile from the location
> or PC where you start up DTS.
> Are you opening up the designer while logged onto the server
> using the service account or are you doing this from your
> PC? If it's from a PC, it doesn't matter what you have setup
> on the server.
> -Sue
> On Fri, 11 Aug 2006 13:54:02 -0700, Leon Shargorodsky
> <LeonShargorodsky@.discussions.microsoft.com> wrote:
> >I get "Unable to load MAPI profiles" error message in DTS Designer trying to
> >add "Send Mail" task.
> >SQLMail has been installed and configured (and tested, it works) on the same
> >server.
> >
> >Please help, thank you in advance
>|||If you are logging onto the server directly and logging on
using the service account used by SQL Server and SQL Agent.
And if from here you can see the mail profiles, they have
all been setup, tested and they are working correctly, and
from here you open up the DTS designer and it can't find
profiles when adding a Send Mail task, then I have no idea.
That sounds like a problem with the mail profile itself but
apparently your SQL Mail and SQL Agent Mail are both working
fine. Pretty much all of the typical issues that cause the
error you report as not being applicable so I haven't a
clue. Other than MAPI just is unreliable crap.
-Sue
On Mon, 14 Aug 2006 11:10:02 -0700, Leon Shargorodsky
<LeonShargorodsky@.discussions.microsoft.com> wrote:
>I'm logging on using service account (MSSQLServer and SQLServerAgent run
>under this account)
>"Sue Hoegemeier" wrote:
>> When in the designer, it's using the current users windows
>> account and the current users mail profile from the location
>> or PC where you start up DTS.
>> Are you opening up the designer while logged onto the server
>> using the service account or are you doing this from your
>> PC? If it's from a PC, it doesn't matter what you have setup
>> on the server.
>> -Sue
>> On Fri, 11 Aug 2006 13:54:02 -0700, Leon Shargorodsky
>> <LeonShargorodsky@.discussions.microsoft.com> wrote:
>> >I get "Unable to load MAPI profiles" error message in DTS Designer trying to
>> >add "Send Mail" task.
>> >SQLMail has been installed and configured (and tested, it works) on the same
>> >server.
>> >
>> >Please help, thank you in advance
>>