dbTalk Databases Forums  

DTS runs in Mode Design but no in IIS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS runs in Mode Design but no in IIS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Don Juan
 
Posts: n/a

Default DTS runs in Mode Design but no in IIS - 11-17-2008 , 03:01 AM






Hi all
I have a trouble with my dtsx package, these are the scenarios:
- When designing my webpage I call a package by code or by command line
(dtexec), I'm working in VB (Visual Studio 2005) when I compile the page
with F5 the page calls the package and the database is updated succesfully.
- When I setup my IIS in the same computer that point to the same directory,
I run my application via:
"http: // localhost / page_dstx.aspx" and... nothing happens no error
messages and the database is not loaded / uploaded

Thanks for your help.


Reply With Quote
  #2  
Old   
Sylvain Lafontaine
 
Posts: n/a

Default Re: DTS runs in Mode Design but no in IIS - 11-18-2008 , 12:15 AM






I do not know much about DTSx but most likely, you have simply a permission
problem here: the windows account used by IIS to run the package is not the
same account as your own when you are running this package interactively.

For example, see the last answer on the following thread:
http://bytes.com/forum/thread658958.html

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Don Juan" <Juanete (AT) gmail (DOT) com> wrote

Quote:
Hi all
I have a trouble with my dtsx package, these are the scenarios:
- When designing my webpage I call a package by code or by command line
(dtexec), I'm working in VB (Visual Studio 2005) when I compile the page
with F5 the page calls the package and the database is updated
succesfully.
- When I setup my IIS in the same computer that point to the same
directory, I run my application via:
"http: // localhost / page_dstx.aspx" and... nothing happens no error
messages and the database is not loaded / uploaded

Thanks for your help.



Reply With Quote
  #3  
Old   
Sylvain Lafontaine
 
Posts: n/a

Default Re: DTS runs in Mode Design but no in IIS - 11-18-2008 , 12:15 AM



I do not know much about DTSx but most likely, you have simply a permission
problem here: the windows account used by IIS to run the package is not the
same account as your own when you are running this package interactively.

For example, see the last answer on the following thread:
http://bytes.com/forum/thread658958.html

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Don Juan" <Juanete (AT) gmail (DOT) com> wrote

Quote:
Hi all
I have a trouble with my dtsx package, these are the scenarios:
- When designing my webpage I call a package by code or by command line
(dtexec), I'm working in VB (Visual Studio 2005) when I compile the page
with F5 the page calls the package and the database is updated
succesfully.
- When I setup my IIS in the same computer that point to the same
directory, I run my application via:
"http: // localhost / page_dstx.aspx" and... nothing happens no error
messages and the database is not loaded / uploaded

Thanks for your help.



Reply With Quote
  #4  
Old   
Sylvain Lafontaine
 
Posts: n/a

Default Re: DTS runs in Mode Design but no in IIS - 11-18-2008 , 12:15 AM



I do not know much about DTSx but most likely, you have simply a permission
problem here: the windows account used by IIS to run the package is not the
same account as your own when you are running this package interactively.

For example, see the last answer on the following thread:
http://bytes.com/forum/thread658958.html

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Don Juan" <Juanete (AT) gmail (DOT) com> wrote

Quote:
Hi all
I have a trouble with my dtsx package, these are the scenarios:
- When designing my webpage I call a package by code or by command line
(dtexec), I'm working in VB (Visual Studio 2005) when I compile the page
with F5 the page calls the package and the database is updated
succesfully.
- When I setup my IIS in the same computer that point to the same
directory, I run my application via:
"http: // localhost / page_dstx.aspx" and... nothing happens no error
messages and the database is not loaded / uploaded

Thanks for your help.



Reply With Quote
  #5  
Old   
Sylvain Lafontaine
 
Posts: n/a

Default Re: DTS runs in Mode Design but no in IIS - 11-18-2008 , 12:15 AM



I do not know much about DTSx but most likely, you have simply a permission
problem here: the windows account used by IIS to run the package is not the
same account as your own when you are running this package interactively.

For example, see the last answer on the following thread:
http://bytes.com/forum/thread658958.html

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Don Juan" <Juanete (AT) gmail (DOT) com> wrote

Quote:
Hi all
I have a trouble with my dtsx package, these are the scenarios:
- When designing my webpage I call a package by code or by command line
(dtexec), I'm working in VB (Visual Studio 2005) when I compile the page
with F5 the page calls the package and the database is updated
succesfully.
- When I setup my IIS in the same computer that point to the same
directory, I run my application via:
"http: // localhost / page_dstx.aspx" and... nothing happens no error
messages and the database is not loaded / uploaded

Thanks for your help.



Reply With Quote
  #6  
Old   
Sylvain Lafontaine
 
Posts: n/a

Default Re: DTS runs in Mode Design but no in IIS - 11-18-2008 , 12:15 AM



I do not know much about DTSx but most likely, you have simply a permission
problem here: the windows account used by IIS to run the package is not the
same account as your own when you are running this package interactively.

For example, see the last answer on the following thread:
http://bytes.com/forum/thread658958.html

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Don Juan" <Juanete (AT) gmail (DOT) com> wrote

Quote:
Hi all
I have a trouble with my dtsx package, these are the scenarios:
- When designing my webpage I call a package by code or by command line
(dtexec), I'm working in VB (Visual Studio 2005) when I compile the page
with F5 the page calls the package and the database is updated
succesfully.
- When I setup my IIS in the same computer that point to the same
directory, I run my application via:
"http: // localhost / page_dstx.aspx" and... nothing happens no error
messages and the database is not loaded / uploaded

Thanks for your help.



Reply With Quote
  #7  
Old   
Sylvain Lafontaine
 
Posts: n/a

Default Re: DTS runs in Mode Design but no in IIS - 11-18-2008 , 12:15 AM



I do not know much about DTSx but most likely, you have simply a permission
problem here: the windows account used by IIS to run the package is not the
same account as your own when you are running this package interactively.

For example, see the last answer on the following thread:
http://bytes.com/forum/thread658958.html

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Don Juan" <Juanete (AT) gmail (DOT) com> wrote

Quote:
Hi all
I have a trouble with my dtsx package, these are the scenarios:
- When designing my webpage I call a package by code or by command line
(dtexec), I'm working in VB (Visual Studio 2005) when I compile the page
with F5 the page calls the package and the database is updated
succesfully.
- When I setup my IIS in the same computer that point to the same
directory, I run my application via:
"http: // localhost / page_dstx.aspx" and... nothing happens no error
messages and the database is not loaded / uploaded

Thanks for your help.



Reply With Quote
  #8  
Old   
Sylvain Lafontaine
 
Posts: n/a

Default Re: DTS runs in Mode Design but no in IIS - 11-18-2008 , 12:15 AM



I do not know much about DTSx but most likely, you have simply a permission
problem here: the windows account used by IIS to run the package is not the
same account as your own when you are running this package interactively.

For example, see the last answer on the following thread:
http://bytes.com/forum/thread658958.html

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Don Juan" <Juanete (AT) gmail (DOT) com> wrote

Quote:
Hi all
I have a trouble with my dtsx package, these are the scenarios:
- When designing my webpage I call a package by code or by command line
(dtexec), I'm working in VB (Visual Studio 2005) when I compile the page
with F5 the page calls the package and the database is updated
succesfully.
- When I setup my IIS in the same computer that point to the same
directory, I run my application via:
"http: // localhost / page_dstx.aspx" and... nothing happens no error
messages and the database is not loaded / uploaded

Thanks for your help.



Reply With Quote
  #9  
Old   
Sylvain Lafontaine
 
Posts: n/a

Default Re: DTS runs in Mode Design but no in IIS - 11-18-2008 , 12:15 AM



I do not know much about DTSx but most likely, you have simply a permission
problem here: the windows account used by IIS to run the package is not the
same account as your own when you are running this package interactively.

For example, see the last answer on the following thread:
http://bytes.com/forum/thread658958.html

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Don Juan" <Juanete (AT) gmail (DOT) com> wrote

Quote:
Hi all
I have a trouble with my dtsx package, these are the scenarios:
- When designing my webpage I call a package by code or by command line
(dtexec), I'm working in VB (Visual Studio 2005) when I compile the page
with F5 the page calls the package and the database is updated
succesfully.
- When I setup my IIS in the same computer that point to the same
directory, I run my application via:
"http: // localhost / page_dstx.aspx" and... nothing happens no error
messages and the database is not loaded / uploaded

Thanks for your help.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.