DTS Package Errors

I have created several DTS packages that run if I execute them imidiatly, but error out if scheduled with the following error...

Executed as user: Domain\Username. DTSRun: Loading... Error: -2147467259 (80004005); Provider Error: 17 (11) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0. Process Exit Code 1. The step failed.Most likely it's that it doesn't have access to the drive...

You need to set DTS up so that when you manually run, it will find the same location on the server.

When you run, it runs under the context of your client, when scheduled it runs under the context of the agent id.

Make sure there is the same directory stucture on the server as you have (or vica versa) and make sure to copy the file there...|||Both are being run from the same server.|||What user is the owner of the job. That user may not have rights to execute the DTS package. Also check who the owner of the DTS package is?|||Already verified those and they are good.
The error states which user it is using and it is the same user name that SQL agent is started with. and it has all needed privalges that I can see.|||How did you create the job? Did you right click the job and select schedule?|||Yes|||Is the server SQL 7??|||No, it is SQL server 2000 Enterprise.|||Connections in the package are good? Anything dynamic going on?? Did you get the error message from the job logs??|||I get the same error on all my scheduled DTS jobs, including a test job I created that drops a test table. I find the error in the history of the job after it has run.|||Sorry running out of ideas. Is the owner of the job SA?? not the sql agent|||nope.|||Can you log onto the machine that actually runs the package and execute the package from there? Turned out to be the trick for me -- if I executed from nearly anywhere else there was a DSN set up to map the DNS name to a connection. Just not on the box itself, so EM could execute the package anywhere but on the actual box. I know sounds odd, but it's true...

dts package errors

I am transferring data from a text file to a table in SQL Server. Is
there any way to export the dts package logs or a similar error log to
a text file. I need to know if the errors are duplicate keys or
missing files. I don't know if I need to write some code or what I
need to do. Any help'It largely depends on what type of transformation you're using. If you are
using the Transform Data Task then on the options tab of the task properties
you can set a filename for the "Exception file". If you uncheck the '7.0
format' option and select the other 3 check boxes you'll get an exception
file and 2 other files - each containing the erroring rows. If you are using
the BULK INSERT task then there is no such granular option. You could try
package logging (right-click on the white background, "Package Properties",
"Logging" tab and "Error file:" text box) but AFAIR you don't get much
useful info there.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||I have tried the exception file but if the file does not exist there is
no error written to that file. I will need to know this.
Paul Ibison wrote:
> It largely depends on what type of transformation you're using. If you are
> using the Transform Data Task then on the options tab of the task properties
> you can set a filename for the "Exception file". If you uncheck the '7.0
> format' option and select the other 3 check boxes you'll get an exception
> file and 2 other files - each containing the erroring rows. If you are using
> the BULK INSERT task then there is no such granular option. You could try
> package logging (right-click on the white background, "Package Properties",
> "Logging" tab and "Error file:" text box) but AFAIR you don't get much
> useful info there.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .

dts package errors

I am transferring data from a text file to a table in SQL Server. Is
there any way to export the dts package logs or a similar error log to
a text file. I need to know if the errors are duplicate keys or
missing files. I don't know if I need to write some code or what I
need to do. Any help'It largely depends on what type of transformation you're using. If you are
using the Transform Data Task then on the options tab of the task properties
you can set a filename for the "Exception file". If you uncheck the '7.0
format' option and select the other 3 check boxes you'll get an exception
file and 2 other files - each containing the erroring rows. If you are using
the BULK INSERT task then there is no such granular option. You could try
package logging (right-click on the white background, "Package Properties",
"Logging" tab and "Error file:" text box) but AFAIR you don't get much
useful info there.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||I have tried the exception file but if the file does not exist there is
no error written to that file. I will need to know this.
Paul Ibison wrote:
> It largely depends on what type of transformation you're using. If you are
> using the Transform Data Task then on the options tab of the task properti
es
> you can set a filename for the "Exception file". If you uncheck the '7.0
> format' option and select the other 3 check boxes you'll get an exception
> file and 2 other files - each containing the erroring rows. If you are usi
ng
> the BULK INSERT task then there is no such granular option. You could try
> package logging (right-click on the white background, "Package Properties"
,
> "Logging" tab and "Error file:" text box) but AFAIR you don't get much
> useful info there.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .

DTS invalid object name error

When I try to import or export between my laptop and our SQL Server 2000
server I get 2 errors stating [Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid object name 'dbo.vw_LaborTotalsAll'
I looked it up in TechNet and said it had something to do with the order of
dependent objects (e.g. tables) and that it could be resolved with SP3. I
have SP3 on both the laptop and server. The only difference is that the
laptop is the Developers Edition and the Server is Standard Edition.
Any ideas how to resolve/fix this error? Thanks.
David
Assuming vw_LaborTotalsAll is a view. Who's the owner of it on both the
laptop and the server?
"David C" wrote:

> When I try to import or export between my laptop and our SQL Server 2000
> server I get 2 errors stating [Microsoft][ODBC SQL Server Driver][SQL
> Server]Invalid object name 'dbo.vw_LaborTotalsAll'
> I looked it up in TechNet and said it had something to do with the order of
> dependent objects (e.g. tables) and that it could be resolved with SP3. I
> have SP3 on both the laptop and server. The only difference is that the
> laptop is the Developers Edition and the Server is Standard Edition.
> Any ideas how to resolve/fix this error? Thanks.
> David
>
>
|||All objects have the same owner. Out of 100 views, only 2 are giving
this error.
David
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

DTS invalid object name error

When I try to import or export between my laptop and our SQL Server 2000
server I get 2 errors stating [Microsoft][ODBC SQL Server Driver]
1;SQL
Server]Invalid object name 'dbo.vw_LaborTotalsAll'
I looked it up in technet and said it had something to do with the order of
dependent objects (e.g. tables) and that it could be resolved with SP3. I
have SP3 on both the laptop and server. The only difference is that the
laptop is the Developers Edition and the Server is Standard Edition.
Any ideas how to resolve/fix this error? Thanks.
DavidAssuming vw_LaborTotalsAll is a view. Who's the owner of it on both the
laptop and the server?
"David C" wrote:

> When I try to import or export between my laptop and our SQL Server 2000
> server I get 2 errors stating [Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]Invalid object name 'dbo.vw_LaborTotalsAll'
> I looked it up in technet and said it had something to do with the order o
f
> dependent objects (e.g. tables) and that it could be resolved with SP3. I
> have SP3 on both the laptop and server. The only difference is that the
> laptop is the Developers Edition and the Server is Standard Edition.
> Any ideas how to resolve/fix this error? Thanks.
> David
>
>|||All objects have the same owner. Out of 100 views, only 2 are giving
this error.
David
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

DTS invalid object name error

When I try to import or export between my laptop and our SQL Server 2000
server I get 2 errors stating [Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid object name 'dbo.vw_LaborTotalsAll'
I looked it up in TechNet and said it had something to do with the order of
dependent objects (e.g. tables) and that it could be resolved with SP3. I
have SP3 on both the laptop and server. The only difference is that the
laptop is the Developers Edition and the Server is Standard Edition.
Any ideas how to resolve/fix this error? Thanks.
DavidAssuming vw_LaborTotalsAll is a view. Who's the owner of it on both the
laptop and the server?
"David C" wrote:
> When I try to import or export between my laptop and our SQL Server 2000
> server I get 2 errors stating [Microsoft][ODBC SQL Server Driver][SQL
> Server]Invalid object name 'dbo.vw_LaborTotalsAll'
> I looked it up in TechNet and said it had something to do with the order of
> dependent objects (e.g. tables) and that it could be resolved with SP3. I
> have SP3 on both the laptop and server. The only difference is that the
> laptop is the Developers Edition and the Server is Standard Edition.
> Any ideas how to resolve/fix this error? Thanks.
> David
>
>

DTS Import Text File Replacement - too many errors with DTS

I am using the DTS COM object to import a bunch of different text files.
some are 2 or 3 million rows. if there's an invalid row (can't find
row delimiter or column delimiter) sometimes DTS will crash and stop the
import... it even does it if I try to import it from the GUI, and going
into DTS tasks and messing with the errors rows, etc.
So, I am looking for a better way to batch import... can't use bulk
insert because of field qualifiers... any ideas? any 3rd party object i
can use to quickly import a large file?
i using c#, btw.
thanks
EdDid you look at the bcp utility? It ain't pretty, but for brute force,
it is hard to beat.|||Bulk insert and bcp both can use format file (i.e. you can specify your
custom terminator), batch size, and allowable max error. You should check
them out.
-oj
"Ed West" <west@.westville.com> wrote in message
news:OQxMbDxCFHA.3492@.TK2MSFTNGP12.phx.gbl...
>I am using the DTS COM object to import a bunch of different text files.
>some are 2 or 3 million rows. if there's an invalid row (can't find row
>delimiter or column delimiter) sometimes DTS will crash and stop the
>import... it even does it if I try to import it from the GUI, and going
>into DTS tasks and messing with the errors rows, etc.
> So, I am looking for a better way to batch import... can't use bulk insert
> because of field qualifiers... any ideas? any 3rd party object i can use
> to quickly import a large file?
> i using c#, btw.
> thanks
> Ed|||hi - many thanks, bcp/bulk insert is working great... i am creating a
format file dynamically.
thanks again
oj wrote:
> Bulk insert and bcp both can use format file (i.e. you can specify your
> custom terminator), batch size, and allowable max error. You should check
> them out.
>|||Hello - what about a Field Qualifier? how can I specify that? For some
files, the field qualifier is " and that is showing up in the database
field after being imported... thanks
- Ed
oj wrote:
> Bulk insert and bcp both can use format file (i.e. you can specify your
> custom terminator), batch size, and allowable max error. You should check
> them out.
>