Monday, March 26, 2012
Error opening datafile: The filename, directory name, or volume labe syntax inco
"Error opening datafile: The filename, directory name, or volume labe syntax is incorrect."
I set the file name property of the Text File (Source) to a valid file, but when I run the package and it returns the above error message, it sets the file name property to <not displayable>.
Does anyone have any experience with such a problem? If so please help!!! ThanksRunning scheduled or manual?|||it's run manually triggerred from an ASP page.|||bump|||Well...
It's running under the context of the login that calls it...but how are you executing from an asp page?
From a job or sproc?
Usually when it runs under the contect of the server the file paths and names have to exists ON the server, not the client.
Is that your understanding?|||It throws the afforementioned error when I call it from ASP or from the Enterprise Manager.
I'm executing it from asp like:
Set oPkg = Server.CreateObject("DTS.Package")
oPkg.Execute
But the fact that it throws the error from EM on the server is most alarming. I just returned from vacation and I have no idea what could be causing this.
The file names do exist on the local server, but when the package is run it sets the file name property to "<not displayable>"sql
Wednesday, March 21, 2012
error on DTS scheduling
delete and then copy data from SQL server to DB2 on mainframe. I
installed the Host Intergration Server 2000 client to get OLEDB for
Db2. The DTS is working fine, when I run it myself from the server.
But when I schedule it it get the following error:
Executed as user: LOMBARD\sqlexec. DTSRun: Loading... DTSRun:
Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun
OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147217900 (80040E14)
Error string: Internal NetLib Error Error source: Microsoft
DB2 OLE DB Provider Help file: Help context: 0 Error
Detail Records: Error: -2147217900 (80040E14); Provider Error: 0
(0) Error string: Internal NetLib Error Error source:
Microsoft DB2 OLE DB Provider Help file: Help context: 0
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: Package
execution complete. Process Exit Code 1. The step failed.
I have been trying to solve this for the last couple of days, but not
getting anywhere...could somebody please help ?
Thanks
Roger
This is because (most probably) because when you schedule a package it runs on the server so everything you need must be on the
scheduling server. You probably have the drivers installed on your workstation which is why it works when you run it.
Have a look here
http://support.microsoft.com/?kbid=269074
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com
"sql rookie" <anytasks@.gmail.com> wrote in message news:1104952964.389735.87880@.z14g2000cwz.googlegro ups.com...
>I am pretty new to SQL server. I have setup a DTS package that would
> delete and then copy data from SQL server to DB2 on mainframe. I
> installed the Host Intergration Server 2000 client to get OLEDB for
> Db2. The DTS is working fine, when I run it myself from the server.
> But when I schedule it it get the following error:
> Executed as user: LOMBARD\sqlexec. DTSRun: Loading... DTSRun:
> Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun
> OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147217900 (80040E14)
> Error string: Internal NetLib Error Error source: Microsoft
> DB2 OLE DB Provider Help file: Help context: 0 Error
> Detail Records: Error: -2147217900 (80040E14); Provider Error: 0
> (0) Error string: Internal NetLib Error Error source:
> Microsoft DB2 OLE DB Provider Help file: Help context: 0
> DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: Package
> execution complete. Process Exit Code 1. The step failed.
>
> I have been trying to solve this for the last couple of days, but not
> getting anywhere...could somebody please help ?
> Thanks
> Roger
>
|||You,
it sounds to me like a problem with users.
My aasumption is that you installed drivers for DB2 logged-in as
Administrator.
So everything is working when you run the DTS package as Administrator.
But when the package runs as LOMBARD\sqlexec it cannot find the drivers.
Maybe you can try and install the drivers also logged-in as sqlexec.
Danijel
"sql rookie" <anytasks@.gmail.com> wrote in message
news:1104955716.152873.292710@.z14g2000cwz.googlegr oups.com...
> No , I executed the DTS on the server itself. I am using Terminal
> server to login to the server. I can execute the DTS via EM and also
> using DTSRUN on command line. But when I schedule it , it throws this
> error.
>
|||No , I executed the DTS on the server itself. I am using Terminal
server to login to the server. I can execute the DTS via EM and also
using DTSRUN on command line. But when I schedule it , it throws this
error.
|||There is a new developement on this:
I tried to change the sqlserver and agent service account to Local
systems and then the scheduling was working fine. I created a new
domain account , added it to the admin group to the server, made that
domain user the service account for sqlserver and agent. Gave sysadmin
privelege to the domain user. Now when I schedule it , I doesn't work.
I gives the same error
Am I doing something wrong ?
Please help
Monday, March 19, 2012
error on DTS scheduling
delete and then copy data from SQL server to DB2 on mainframe. I
installed the Host Intergration Server 2000 client to get OLEDB for
Db2. The DTS is working fine, when I run it myself from the server.
But when I schedule it it get the following error:
Executed as user: LOMBARD\sqlexec. DTSRun: Loading... DTSRun:
Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun
OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147217900 (80040E14)
Error string: Internal NetLib Error Error source: Microsoft
DB2 OLE DB Provider Help file: Help context: 0 Error
Detail Records: Error: -2147217900 (80040E14); Provider Error: 0
(0) Error string: Internal NetLib Error Error source:
Microsoft DB2 OLE DB Provider Help file: Help context: 0
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: Package
execution complete. Process Exit Code 1. The step failed.
I have been trying to solve this for the last couple of days, but not
getting anywhere...could somebody please help ?
Thanks
RogerThis is because (most probably) because when you schedule a package it runs on the server so everything you need must be on the
scheduling server. You probably have the drivers installed on your workstation which is why it works when you run it.
Have a look here
http://support.microsoft.com/?kbid=269074
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com
"sql rookie" <anytasks@.gmail.com> wrote in message news:1104952964.389735.87880@.z14g2000cwz.googlegroups.com...
>I am pretty new to SQL server. I have setup a DTS package that would
> delete and then copy data from SQL server to DB2 on mainframe. I
> installed the Host Intergration Server 2000 client to get OLEDB for
> Db2. The DTS is working fine, when I run it myself from the server.
> But when I schedule it it get the following error:
> Executed as user: LOMBARD\sqlexec. DTSRun: Loading... DTSRun:
> Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun
> OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147217900 (80040E14)
> Error string: Internal NetLib Error Error source: Microsoft
> DB2 OLE DB Provider Help file: Help context: 0 Error
> Detail Records: Error: -2147217900 (80040E14); Provider Error: 0
> (0) Error string: Internal NetLib Error Error source:
> Microsoft DB2 OLE DB Provider Help file: Help context: 0
> DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: Package
> execution complete. Process Exit Code 1. The step failed.
>
> I have been trying to solve this for the last couple of days, but not
> getting anywhere...could somebody please help ?
> Thanks
> Roger
>|||No , I executed the DTS on the server itself. I am using Terminal
server to login to the server. I can execute the DTS via EM and also
using DTSRUN on command line. But when I schedule it , it throws this
error.|||You,
it sounds to me like a problem with users.
My aasumption is that you installed drivers for DB2 logged-in as
Administrator.
So everything is working when you run the DTS package as Administrator.
But when the package runs as LOMBARD\sqlexec it cannot find the drivers.
Maybe you can try and install the drivers also logged-in as sqlexec.
Danijel
"sql rookie" <anytasks@.gmail.com> wrote in message
news:1104955716.152873.292710@.z14g2000cwz.googlegroups.com...
> No , I executed the DTS on the server itself. I am using Terminal
> server to login to the server. I can execute the DTS via EM and also
> using DTSRUN on command line. But when I schedule it , it throws this
> error.
>|||There is a new developement on this:
I tried to change the sqlserver and agent service account to Local
systems and then the scheduling was working fine. I created a new
domain account , added it to the admin group to the server, made that
domain user the service account for sqlserver and agent. Gave sysadmin
privelege to the domain user. Now when I schedule it , I doesn't work.
I gives the same error
Am I doing something wrong ?
Please help
error on DTS scheduling
delete and then copy data from SQL server to DB2 on mainframe. I
installed the Host Intergration Server 2000 client to get OLEDB for
Db2. The DTS is working fine, when I run it myself from the server.
But when I schedule it it get the following error:
Executed as user: LOMBARD\sqlexec. DTSRun: Loading... DTSRun:
Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun
OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147217900 (80040E14)
Error string: Internal NetLib Error Error source: Microsoft
DB2 OLE DB Provider Help file: Help context: 0 Error
Detail Records: Error: -2147217900 (80040E14); Provider Error: 0
(0) Error string: Internal NetLib Error Error source:
Microsoft DB2 OLE DB Provider Help file: Help context: 0
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: Package
execution complete. Process Exit Code 1. The step failed.
I have been trying to solve this for the last couple of days, but not
getting anywhere...could somebody please help ?
Thanks
RogerThis is because (most probably) because when you schedule a package it runs
on the server so everything you need must be on the
scheduling server. You probably have the drivers installed on your workstat
ion which is why it works when you run it.
Have a look here
http://support.microsoft.com/?kbid=269074
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com
"sql rookie" <anytasks@.gmail.com> wrote in message news:1104952964.389735.87880@.z14g2000cwz.
googlegroups.com...
>I am pretty new to SQL server. I have setup a DTS package that would
> delete and then copy data from SQL server to DB2 on mainframe. I
> installed the Host Intergration Server 2000 client to get OLEDB for
> Db2. The DTS is working fine, when I run it myself from the server.
> But when I schedule it it get the following error:
> Executed as user: LOMBARD\sqlexec. DTSRun: Loading... DTSRun:
> Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun
> OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147217900 (80040E14)
> Error string: Internal NetLib Error Error source: Microsoft
> DB2 OLE DB Provider Help file: Help context: 0 Error
> Detail Records: Error: -2147217900 (80040E14); Provider Error: 0
> (0) Error string: Internal NetLib Error Error source:
> Microsoft DB2 OLE DB Provider Help file: Help context: 0
> DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: Package
> execution complete. Process Exit Code 1. The step failed.
>
> I have been trying to solve this for the last couple of days, but not
> getting anywhere...could somebody please help ?
> Thanks
> Roger
>|||You,
it sounds to me like a problem with users.
My aasumption is that you installed drivers for DB2 logged-in as
Administrator.
So everything is working when you run the DTS package as Administrator.
But when the package runs as LOMBARD\sqlexec it cannot find the drivers.
Maybe you can try and install the drivers also logged-in as sqlexec.
Danijel
"sql rookie" <anytasks@.gmail.com> wrote in message
news:1104955716.152873.292710@.z14g2000cwz.googlegroups.com...
> No , I executed the DTS on the server itself. I am using Terminal
> server to login to the server. I can execute the DTS via EM and also
> using DTSRUN on command line. But when I schedule it , it throws this
> error.
>|||No , I executed the DTS on the server itself. I am using Terminal
server to login to the server. I can execute the DTS via EM and also
using DTSRUN on command line. But when I schedule it , it throws this
error.|||There is a new developement on this:
I tried to change the sqlserver and agent service account to Local
systems and then the scheduling was working fine. I created a new
domain account , added it to the admin group to the server, made that
domain user the service account for sqlserver and agent. Gave sysadmin
privelege to the domain user. Now when I schedule it , I doesn't work.
I gives the same error
Am I doing something wrong ?
Please help
Error on copying the database
I can't find what is wrong.
I am copying a database via DTS and I get an error mid way "Invalid object dbo.fx_get_role_from_ownerid". But the object does exist and it has benn in production for a while now.
Why would I get his error, if the object does exist?Sounds like a user defined function...|||it is, and it's there. Why would I get this error?|||On the face of it...I'd say the stupid Object Id is out of whack with the object name...
try and recompile the function...then try it...
Why are you using DTS instead of dump and restore?|||Hi,
I have recompiled the function and still get the error.
I am using DTS to copy all databases on the server to another server every week automaticaly.
Any other ideas?|||How often do you back up the databases?
Why not attach them...
Would be the fastest thing to do...
Sunday, February 19, 2012
Error message in DTS
In my DTS I am updating an Ingres database on a different server.
I'm getting the following error immedtiately ...
HResult of 0x80040e09 (-2147217911) returned
Unexpected error occured. An error was returned without an error message
Anyone know what its about ?
Thanks !!Ok guys, I worked this one out and thought maybe some of you would be
interested in hearing it (even though no one responded to the initial
posting).
I searched the net a bit and saw that other ppl get the same message
when performing actions on databases (of any kind) on other servers.
The message I put in the posting was what I got when I ran the DTS step
by step when I was writing and checking it.
The error message I got when running it as a package was an ODBC message
giving me the actual Ingres error.
Hence the error message ...
"Unexpected error occured. An error was returned without an error message"
There is no error message within SqlServer because the error message is
external from Ingres.
David Greenberg wrote:
Quote:
Originally Posted by
Hi
In my DTS I am updating an Ingres database on a different server.
I'm getting the following error immedtiately ...
>
HResult of 0x80040e09 (-2147217911) returned
Unexpected error occured. An error was returned without an error message
>
Anyone know what its about ?
>
Thanks !!
>