I have a ASP.NET (VB) web application running. The DTS package is suppose to
generates a flat file to a file path (aka: \\myStation\outputFiles\). When
it runs it generates the following error on one of the steps (the others run
successfully):
Step 'Copy Data from Results to H:\Data\outfilename.txt Step' failed
Step Error Source: Microsoft Data Transformation Services Flat File Rowset
Provider
Step Error Description:Error opening datafile: The referenced account is
currently locked out and may not be logged on to.
I am using DTS active X in code behine to execute the package. The web
server is on one machine and the sqlserver is on another. Also I am
impersonating a domain account (aka: mydomain\RequestAccount ) that has
verified access to the path. I have run the package with DTSRun.exe
successfully from DOS and successfully from Enterprise Manager (with the
afore mentioned impersonating account). I know I'm successfully running
under the impersonated account because it shows it in the DTS log header:
Package Name: PG_WCSOUTPUTFILE
Package Description: DTS package description
Package ID: {6CC1492D-C5A4-427D-9D1A-7A4BE050ED56}
Package Version: {515B6214-F967-413D-AE1C-35FB78692E3E}
Package Execution Lineage: {36DD6EC4-190E-4900-BD8A-28F1AA95CBA3}
Executed On: ISBSA-WS05
Executed By: RequestAccount
Execution Started: 1/7/2005 10:50:28 AM
Execution Completed: 1/7/2005 10:50:29 AM
Total Execution Time: 1.063 seconds
Any idea why this is taking place?
Code:
Dim pkg As New DTS.Package2
Dim DTSServerName As String =
ConfigurationSettings.AppSettings(Constants.DTS_SE RVER_NAME)
Dim impObj As New Impersonate(Constants.ImpersonateAccount, _
Constants.ImpersonatePassword, _
Constants.ImpersonateDomain)
Dim DTSUserName As String =
ConfigurationSettings.AppSettings(Constants.DTS_US ER_NAME)
Dim DTSPassword As String =
ConfigurationSettings.AppSettings(Constants.DTS_PA SSWORD)
impObj.BeginImpersonation()
pkg.LoadFromSQLServer( DTSServerName, _
DTSUserName, DTSPassword, _
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default , _
"", _
"", _
"", _
Constants.DTS_PACKAGE_NAME, _
Nothing )
pkg.WriteCompletionStatusToNTEventLog = True
pkg.Execute()
pkg.UnInitialize()
impObj.EndImpersonation()
Thanks.
Page
6  1980 
It sounds as if everything is properly prepared. Can you enable security
auditing on the various servers to see which account is having the difficulty
(and where)? http://www.pluralsight.com/keith/boo...eauditing.html
--
Scott http://www.OdeToCode.com/blogs/scott/ I have a ASP.NET (VB) web application running. The DTS package is
suppose to generates a flat file to a file path (aka:
\\myStation\outputFiles\). When it runs it generates the following
error on one of the steps (the others run successfully):
Step 'Copy Data from Results to H:\Data\outfilename.txt Step' failed
Step Error Source: Microsoft Data Transformation Services Flat File
Rowset
Provider
Step Error Description:Error opening datafile: The referenced account
is
currently locked out and may not be logged on to.
I am using DTS active X in code behine to execute the package. The
web server is on one machine and the sqlserver is on another. Also I
am impersonating a domain account (aka: mydomain\RequestAccount ) that
has verified access to the path. I have run the package with
DTSRun.exe successfully from DOS and successfully from Enterprise
Manager (with the afore mentioned impersonating account). I know I'm
successfully running under the impersonated account because it shows
it in the DTS log header:
Package Name: PG_WCSOUTPUTFILE
Package Description: DTS package description
Package ID: {6CC1492D-C5A4-427D-9D1A-7A4BE050ED56}
Package Version: {515B6214-F967-413D-AE1C-35FB78692E3E}
Package Execution Lineage: {36DD6EC4-190E-4900-BD8A-28F1AA95CBA3}
Executed On: ISBSA-WS05
Executed By: RequestAccount
Execution Started: 1/7/2005 10:50:28 AM
Execution Completed: 1/7/2005 10:50:29 AM
Total Execution Time: 1.063 seconds
Any idea why this is taking place?
Code:
Dim pkg As New DTS.Package2
Dim DTSServerName As String =
ConfigurationSettings.AppSettings(Constants.DTS_SE RVER_NAME)
Dim impObj As New Impersonate(Constants.ImpersonateAccount, _
Constants.ImpersonatePassword, _
Constants.ImpersonateDomain)
Dim DTSUserName As String =
ConfigurationSettings.AppSettings(Constants.DTS_US ER_NAME) Dim
DTSPassword As String =
ConfigurationSettings.AppSettings(Constants.DTS_PA SSWORD)
impObj.BeginImpersonation()
pkg.LoadFromSQLServer( DTSServerName, _
DTSUserName, DTSPassword,
_
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default , _
"", _
"", _
"", _
Constants.DTS_PACKAGE_NAME, _
Nothing )
pkg.WriteCompletionStatusToNTEventLog = True
pkg.Execute()
pkg.UnInitialize()
impObj.EndImpersonation()
Thanks.
Page
Thanks for responding Scott, I have auditing on and checked the event logs
on the particpating machines and nothing. As a side note when I utilized
DTSRun from DOS to test the package (which ran successfully) it was from the
same machine that is acting as the web server (using same account that I
impersonated).
Page
"Scott Allen" <sc***@nospam.OdeToCode.com> wrote in message
news:41*********************@msnews.microsoft.com. .. It sounds as if everything is properly prepared. Can you enable security
auditing on the various servers to see which account is having the
difficulty (and where)?
http://www.pluralsight.com/keith/boo...eauditing.html
--
Scott
http://www.OdeToCode.com/blogs/scott/
I have a ASP.NET (VB) web application running. The DTS package is
suppose to generates a flat file to a file path (aka:
\\myStation\outputFiles\). When it runs it generates the following
error on one of the steps (the others run successfully):
Step 'Copy Data from Results to H:\Data\outfilename.txt Step' failed
Step Error Source: Microsoft Data Transformation Services Flat File
Rowset
Provider
Step Error Description:Error opening datafile: The referenced account
is
currently locked out and may not be logged on to.
I am using DTS active X in code behine to execute the package. The
web server is on one machine and the sqlserver is on another. Also I
am impersonating a domain account (aka: mydomain\RequestAccount ) that
has verified access to the path. I have run the package with
DTSRun.exe successfully from DOS and successfully from Enterprise
Manager (with the afore mentioned impersonating account). I know I'm
successfully running under the impersonated account because it shows
it in the DTS log header:
Package Name: PG_WCSOUTPUTFILE
Package Description: DTS package description
Package ID: {6CC1492D-C5A4-427D-9D1A-7A4BE050ED56}
Package Version: {515B6214-F967-413D-AE1C-35FB78692E3E}
Package Execution Lineage: {36DD6EC4-190E-4900-BD8A-28F1AA95CBA3}
Executed On: ISBSA-WS05
Executed By: RequestAccount
Execution Started: 1/7/2005 10:50:28 AM
Execution Completed: 1/7/2005 10:50:29 AM
Total Execution Time: 1.063 seconds
Any idea why this is taking place?
Code:
Dim pkg As New DTS.Package2
Dim DTSServerName As String =
ConfigurationSettings.AppSettings(Constants.DTS_SE RVER_NAME)
Dim impObj As New Impersonate(Constants.ImpersonateAccount, _
Constants.ImpersonatePassword, _
Constants.ImpersonateDomain)
Dim DTSUserName As String =
ConfigurationSettings.AppSettings(Constants.DTS_US ER_NAME) Dim
DTSPassword As String =
ConfigurationSettings.AppSettings(Constants.DTS_PA SSWORD)
impObj.BeginImpersonation()
pkg.LoadFromSQLServer( DTSServerName, _
DTSUserName, DTSPassword,
_
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default , _
"", _
"", _
"", _
Constants.DTS_PACKAGE_NAME, _
Nothing )
pkg.WriteCompletionStatusToNTEventLog = True
pkg.Execute()
pkg.UnInitialize()
impObj.EndImpersonation()
Thanks.
Page
Interesting. How do you do the impersonation? With a username and password
in web.config?
Also, most DTS components should not need this setting, but try turning on
asp compatibility mode for your page. This adjusts the environment slightly
to use COM components, which is how DTS exposes functionality.
<%@ Page ... AspCompat="true" %>
HTH,
--
Scott http://www.OdeToCode.com/blogs/scott/ Thanks for responding Scott, I have auditing on and checked the event
logs on the particpating machines and nothing. As a side note when I
utilized DTSRun from DOS to test the package (which ran successfully)
it was from the same machine that is acting as the web server (using
same account that I impersonated).
Page
"Scott Allen" <sc***@nospam.OdeToCode.com> wrote in message
news:41*********************@msnews.microsoft.com. ..
It sounds as if everything is properly prepared. Can you enable
security auditing on the various servers to see which account is
having the
difficulty
(and where)?
http://www.pluralsight.com/keith/boo...eauditing.html
--
Scott
http://www.OdeToCode.com/blogs/scott/ I have a ASP.NET (VB) web application running. The DTS package is
suppose to generates a flat file to a file path (aka:
\\myStation\outputFiles\). When it runs it generates the following
error on one of the steps (the others run successfully):
Step 'Copy Data from Results to H:\Data\outfilename.txt Step' failed
Step Error Source: Microsoft Data Transformation Services Flat File
Rowset
Provider
Step Error Description:Error opening datafile: The referenced
account
is
currently locked out and may not be logged on to.
I am using DTS active X in code behine to execute the package. The
web server is on one machine and the sqlserver is on another. Also
I
am impersonating a domain account (aka: mydomain\RequestAccount )
that
has verified access to the path. I have run the package with
DTSRun.exe successfully from DOS and successfully from Enterprise
Manager (with the afore mentioned impersonating account). I know
I'm
successfully running under the impersonated account because it shows
it in the DTS log header:
Package Name: PG_WCSOUTPUTFILE
Package Description: DTS package description
Package ID: {6CC1492D-C5A4-427D-9D1A-7A4BE050ED56}
Package Version: {515B6214-F967-413D-AE1C-35FB78692E3E}
Package Execution Lineage: {36DD6EC4-190E-4900-BD8A-28F1AA95CBA3}
Executed On: ISBSA-WS05
Executed By: RequestAccount
Execution Started: 1/7/2005 10:50:28 AM
Execution Completed: 1/7/2005 10:50:29 AM
Total Execution Time: 1.063 seconds
Any idea why this is taking place?
Code:
Dim pkg As New DTS.Package2
Dim DTSServerName As String =
ConfigurationSettings.AppSettings(Constants.DTS_SE RVER_NAME)
Dim impObj As New Impersonate(Constants.ImpersonateAccount, _
Constants.ImpersonatePassword, _
Constants.ImpersonateDomain)
Dim DTSUserName As String =
ConfigurationSettings.AppSettings(Constants.DTS_US ER_NAME) Dim
DTSPassword As String =
ConfigurationSettings.AppSettings(Constants.DTS_PA SSWORD)
impObj.BeginImpersonation()
pkg.LoadFromSQLServer( DTSServerName, _
DTSUserName, DTSPassword,
_
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default , _
"", _
"", _
"", _
Constants.DTS_PACKAGE_NAME, _
Nothing )
pkg.WriteCompletionStatusToNTEventLog = True
pkg.Execute()
pkg.UnInitialize()
impObj.EndImpersonation()
Thanks.
Page
Scott,
Add AspCompt="True" to the page header and it made no difference. In as far
as the username/password, for the impersonated account, is for now in plain
text in the executable (for testing purposes -- note: the account only works
in our lab environment which is a closed network). Once I get it all to
work properly our security department will put the account info into our
encypted repository where I will pull it from at execution time (I will pass
the impersonate object and the repository object will populate it for me).
Page
"Scott Allen" <sc***@nospam.OdeToCode.com> wrote in message
news:41*********************@msnews.microsoft.com. .. Interesting. How do you do the impersonation? With a username and password
in web.config?
Also, most DTS components should not need this setting, but try turning on
asp compatibility mode for your page. This adjusts the environment
slightly to use COM components, which is how DTS exposes functionality.
<%@ Page ... AspCompat="true" %>
HTH,
--
Scott
http://www.OdeToCode.com/blogs/scott/
Thanks for responding Scott, I have auditing on and checked the event
logs on the particpating machines and nothing. As a side note when I
utilized DTSRun from DOS to test the package (which ran successfully)
it was from the same machine that is acting as the web server (using
same account that I impersonated).
Page
"Scott Allen" <sc***@nospam.OdeToCode.com> wrote in message
news:41*********************@msnews.microsoft.com. ..
It sounds as if everything is properly prepared. Can you enable
security auditing on the various servers to see which account is
having the
difficulty
(and where)?
http://www.pluralsight.com/keith/boo...eauditing.html
--
Scott
http://www.OdeToCode.com/blogs/scott/
I have a ASP.NET (VB) web application running. The DTS package is
suppose to generates a flat file to a file path (aka:
\\myStation\outputFiles\). When it runs it generates the following
error on one of the steps (the others run successfully):
Step 'Copy Data from Results to H:\Data\outfilename.txt Step' failed
Step Error Source: Microsoft Data Transformation Services Flat File
Rowset
Provider
Step Error Description:Error opening datafile: The referenced
account
is
currently locked out and may not be logged on to.
I am using DTS active X in code behine to execute the package. The
web server is on one machine and the sqlserver is on another. Also
I
am impersonating a domain account (aka: mydomain\RequestAccount )
that
has verified access to the path. I have run the package with
DTSRun.exe successfully from DOS and successfully from Enterprise
Manager (with the afore mentioned impersonating account). I know
I'm
successfully running under the impersonated account because it shows
it in the DTS log header:
Package Name: PG_WCSOUTPUTFILE
Package Description: DTS package description
Package ID: {6CC1492D-C5A4-427D-9D1A-7A4BE050ED56}
Package Version: {515B6214-F967-413D-AE1C-35FB78692E3E}
Package Execution Lineage: {36DD6EC4-190E-4900-BD8A-28F1AA95CBA3}
Executed On: ISBSA-WS05
Executed By: RequestAccount
Execution Started: 1/7/2005 10:50:28 AM
Execution Completed: 1/7/2005 10:50:29 AM
Total Execution Time: 1.063 seconds
Any idea why this is taking place?
Code:
Dim pkg As New DTS.Package2
Dim DTSServerName As String =
ConfigurationSettings.AppSettings(Constants.DTS_SE RVER_NAME)
Dim impObj As New Impersonate(Constants.ImpersonateAccount, _
Constants.ImpersonatePassword, _
Constants.ImpersonateDomain)
Dim DTSUserName As String =
ConfigurationSettings.AppSettings(Constants.DTS_US ER_NAME) Dim
DTSPassword As String =
ConfigurationSettings.AppSettings(Constants.DTS_PA SSWORD)
impObj.BeginImpersonation()
pkg.LoadFromSQLServer( DTSServerName, _
DTSUserName, DTSPassword,
_
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default , _
"", _
"", _
"", _
Constants.DTS_PACKAGE_NAME, _
Nothing )
pkg.WriteCompletionStatusToNTEventLog = True
pkg.Execute()
pkg.UnInitialize()
impObj.EndImpersonation()
Thanks.
Page
Hi Page:
I'm running out of ideas..
Any chance H: is a mapped drive? Impersonation doesn't load a profile with
such settings.
--
Scott http://www.OdeToCode.com/blogs/scott/ Scott,
Add AspCompt="True" to the page header and it made no difference. In
as far as the username/password, for the impersonated account, is for
now in plain text in the executable (for testing purposes -- note: the
account only works in our lab environment which is a closed network).
Once I get it all to work properly our security department will put
the account info into our encypted repository where I will pull it
from at execution time (I will pass the impersonate object and the
repository object will populate it for me).
Page
"Scott Allen" <sc***@nospam.OdeToCode.com> wrote in message
news:41*********************@msnews.microsoft.com. ..
Interesting. How do you do the impersonation? With a username and
password in web.config?
Also, most DTS components should not need this setting, but try
turning on asp compatibility mode for your page. This adjusts the
environment
slightly
to use COM components, which is how DTS exposes functionality.
<%@ Page ... AspCompat="true" %>
HTH,
--
Scott
http://www.OdeToCode.com/blogs/scott/ Thanks for responding Scott, I have auditing on and checked the
event logs on the particpating machines and nothing. As a side note
when I utilized DTSRun from DOS to test the package (which ran
successfully) it was from the same machine that is acting as the web
server (using same account that I impersonated).
Page
"Scott Allen" <sc***@nospam.OdeToCode.com> wrote in message
news:41*********************@msnews.microsoft.com. ..
It sounds as if everything is properly prepared. Can you enable
security auditing on the various servers to see which account is
having the
difficulty
(and where)?
http://www.pluralsight.com/keith/boo...leauditing.htm
l
--
Scott
http://www.OdeToCode.com/blogs/scott/
> I have a ASP.NET (VB) web application running. The DTS package is
> suppose to generates a flat file to a file path (aka:
> \\myStation\outputFiles\). When it runs it generates the
> following error on one of the steps (the others run successfully):
>
> Step 'Copy Data from Results to H:\Data\outfilename.txt Step'
> failed
>
> Step Error Source: Microsoft Data Transformation Services Flat
> File
> Rowset
> Provider
> Step Error Description:Error opening datafile: The referenced
> account
> is
> currently locked out and may not be logged on to.
> I am using DTS active X in code behine to execute the package.
> The
> web server is on one machine and the sqlserver is on another.
> Also
> I
> am impersonating a domain account (aka: mydomain\RequestAccount )
> that
> has verified access to the path. I have run the package with
> DTSRun.exe successfully from DOS and successfully from Enterprise
> Manager (with the afore mentioned impersonating account). I know
> I'm
> successfully running under the impersonated account because it
> shows
> it in the DTS log header:
> Package Name: PG_WCSOUTPUTFILE
> Package Description: DTS package description
> Package ID: {6CC1492D-C5A4-427D-9D1A-7A4BE050ED56}
> Package Version: {515B6214-F967-413D-AE1C-35FB78692E3E}
> Package Execution Lineage: {36DD6EC4-190E-4900-BD8A-28F1AA95CBA3}
> Executed On: ISBSA-WS05
> Executed By: RequestAccount
> Execution Started: 1/7/2005 10:50:28 AM
> Execution Completed: 1/7/2005 10:50:29 AM
> Total Execution Time: 1.063 seconds
> Any idea why this is taking place?
> Code:
> Dim pkg As New DTS.Package2
> Dim DTSServerName As String =
> ConfigurationSettings.AppSettings(Constants.DTS_SE RVER_NAME)
> Dim impObj As New Impersonate(Constants.ImpersonateAccount, _
> Constants.ImpersonatePassword, _
> Constants.ImpersonateDomain)
>
> Dim DTSUserName As String =
> ConfigurationSettings.AppSettings(Constants.DTS_US ER_NAME) Dim
> DTSPassword As String =
> ConfigurationSettings.AppSettings(Constants.DTS_PA SSWORD)
>
> impObj.BeginImpersonation()
>
> pkg.LoadFromSQLServer( DTSServerName, _
> DTSUserName, DTSPassword,
> _
> DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default , _
> "", _
> "", _
> "", _
> Constants.DTS_PACKAGE_NAME, _
> Nothing )
> pkg.WriteCompletionStatusToNTEventLog = True
> pkg.Execute()
> pkg.UnInitialize()
> impObj.EndImpersonation()
> Thanks.
> Page
Actually H is a mapped drive, but its never used in the DTS package (no
drive letters are referenced in the package). To be honest that is the one
that has really thrown me. Our H drive is mapped as our My Documents area.
Even though the dts package creates the file with the path \\mynode\file...
does it still try to write to My Document path? But if impersonation
doesn't load a profile it wouldn't have the path would it? I do find it
puzzling because the initial output file is called outfilename.txt (then
renamed in the next step).
Page
"Scott Allen" <sc***@nospam.OdeToCode.com> wrote in message
news:41*********************@msnews.microsoft.com. .. Hi Page:
I'm running out of ideas..
Any chance H: is a mapped drive? Impersonation doesn't load a profile with
such settings.
--
Scott
http://www.OdeToCode.com/blogs/scott/
Scott,
Add AspCompt="True" to the page header and it made no difference. In
as far as the username/password, for the impersonated account, is for
now in plain text in the executable (for testing purposes -- note: the
account only works in our lab environment which is a closed network).
Once I get it all to work properly our security department will put
the account info into our encypted repository where I will pull it
from at execution time (I will pass the impersonate object and the
repository object will populate it for me).
Page
"Scott Allen" <sc***@nospam.OdeToCode.com> wrote in message
news:41*********************@msnews.microsoft.com. ..
Interesting. How do you do the impersonation? With a username and
password in web.config?
Also, most DTS components should not need this setting, but try
turning on asp compatibility mode for your page. This adjusts the
environment
slightly
to use COM components, which is how DTS exposes functionality.
<%@ Page ... AspCompat="true" %>
HTH,
--
Scott
http://www.OdeToCode.com/blogs/scott/
Thanks for responding Scott, I have auditing on and checked the
event logs on the particpating machines and nothing. As a side note
when I utilized DTSRun from DOS to test the package (which ran
successfully) it was from the same machine that is acting as the web
server (using same account that I impersonated).
Page
"Scott Allen" <sc***@nospam.OdeToCode.com> wrote in message
news:41*********************@msnews.microsoft.com. ..
> It sounds as if everything is properly prepared. Can you enable
> security auditing on the various servers to see which account is
> having the
>
difficulty
> (and where)?
>
> http://www.pluralsight.com/keith/boo...leauditing.htm
> l
>
> --
> Scott
> http://www.OdeToCode.com/blogs/scott/
>> I have a ASP.NET (VB) web application running. The DTS package is
>> suppose to generates a flat file to a file path (aka:
>> \\myStation\outputFiles\). When it runs it generates the
>> following error on one of the steps (the others run successfully):
>>
>> Step 'Copy Data from Results to H:\Data\outfilename.txt Step'
>> failed
>>
>> Step Error Source: Microsoft Data Transformation Services Flat
>> File
>> Rowset
>> Provider
>> Step Error Description:Error opening datafile: The referenced
>> account
>> is
>> currently locked out and may not be logged on to.
>> I am using DTS active X in code behine to execute the package.
>> The
>> web server is on one machine and the sqlserver is on another.
>> Also
>> I
>> am impersonating a domain account (aka: mydomain\RequestAccount )
>> that
>> has verified access to the path. I have run the package with
>> DTSRun.exe successfully from DOS and successfully from Enterprise
>> Manager (with the afore mentioned impersonating account). I know
>> I'm
>> successfully running under the impersonated account because it
>> shows
>> it in the DTS log header:
>> Package Name: PG_WCSOUTPUTFILE
>> Package Description: DTS package description
>> Package ID: {6CC1492D-C5A4-427D-9D1A-7A4BE050ED56}
>> Package Version: {515B6214-F967-413D-AE1C-35FB78692E3E}
>> Package Execution Lineage: {36DD6EC4-190E-4900-BD8A-28F1AA95CBA3}
>> Executed On: ISBSA-WS05
>> Executed By: RequestAccount
>> Execution Started: 1/7/2005 10:50:28 AM
>> Execution Completed: 1/7/2005 10:50:29 AM
>> Total Execution Time: 1.063 seconds
>> Any idea why this is taking place?
>> Code:
>> Dim pkg As New DTS.Package2
>> Dim DTSServerName As String =
>> ConfigurationSettings.AppSettings(Constants.DTS_SE RVER_NAME)
>> Dim impObj As New Impersonate(Constants.ImpersonateAccount, _
>> Constants.ImpersonatePassword, _
>> Constants.ImpersonateDomain)
>>
>> Dim DTSUserName As String =
>> ConfigurationSettings.AppSettings(Constants.DTS_US ER_NAME) Dim
>> DTSPassword As String =
>> ConfigurationSettings.AppSettings(Constants.DTS_PA SSWORD)
>>
>> impObj.BeginImpersonation()
>>
>> pkg.LoadFromSQLServer( DTSServerName, _
>> DTSUserName, DTSPassword,
>> _
>> DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default , _
>> "", _
>> "", _
>> "", _
>> Constants.DTS_PACKAGE_NAME, _
>> Nothing )
>> pkg.WriteCompletionStatusToNTEventLog = True
>> pkg.Execute()
>> pkg.UnInitialize()
>> impObj.EndImpersonation()
>> Thanks.
>> Page
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Remy C. Cool |
last post by:
Hello,
My application uses a remote import scheme using the sys.path_hooks
solution as explained in PEP302
(http://www.python.org/peps/pep-0302.html)
The importer works fine for packages,...
|
by: kong |
last post by:
I created a package using pl/sql.
In this package i have a dblink to another Database, call it DB2.
Meanwhile, Server2 has a DBlink to another Database, call it DB3.
Within my package, i have a...
|
by: Chris |
last post by:
Background: I am using a MS Access 2000 front end with SQL Server 8.0
back end.
I have the requirement to import all text files (regardless of
filename) from a given folder on the network into a...
|
by: Ron |
last post by:
Hello,
I can run a dts package in a vb6 app multiple times. If I
run the same package once in a vb.net project, it runs
fine (did all the dotnet syntax conversions...). If I try
to run the...
|
by: mortenol |
last post by:
Hi, I am trying to connect a MS SSIS package to an AS400/DB2 database,
and I experience problem when I hit the "Create Package" button in
the "Data Link properties window".
I have understood that...
|
by: kelvin |
last post by:
Can anyone tell me what could cause the error below?
Starting installation ...
Loading zlib: ok
Downloading package: PEAR-stable......ok
Downloading package: Archive_Tar-stable....ok...
|
by: manish deshpande |
last post by:
Hi,
When i'm installing MySQL-server-standard-5.0.24a-0.rhel3.i386.rpm by the following command:
rpm -i MySQL-server-standard-5.0.24a-0.rhel3.i386.rpm the following error is being shown:
...
|
by: gngui |
last post by:
Hi,
I am using the Microsoft Office Access 2003 Developer Extensions to package a Ms Access application. After packaging & running setup, the installation works & is completed OK.
The problem is...
|
by: Conny Nehmer |
last post by:
For me that sounds like you don't have a rights problem but the database is
simply not able to find your package.
Can it be that you forgot to create a synonym for the package in first
schema?
...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |
