DTS packet size

I have a dts package that transfers data from a view into
a table structure on another server. Occassionly the
scheduled package will fail with the following error:

Error = -2147467259 (80004005) Error string:
[DBNETLIB][ConnectionRead (recv()).]General network error.
Check your network documentation. Error source:
Microsoft OLE DB Provider for SQL Server Help
file: Help context: 0 Error Detail
Records: Error: -2147467259 (80004005); Provider
Error: 11 (B) Error string: [DBNETLIB]
[ConnectionRead (recv()).]General network error. Check
your network documentation. Error source: Microsoft
OLE DB Provider for SQL Server Help file: Help
context: 0 DTSRun OnFinish: Copy Data from PS...
Process Exit Code 1. The step failed.

Once the package fails I will rerun it several times
without any modifications and eventually it will run to
completion successfully. One change that I have made while
troubleshooting is to change the default network package
size from 1 to 1024 or 2048. Although this has worked I'm
not confident that the package wouldn't have run without
that change.

Has anyone seen this error before or anything similar?Default network packet size is 4096. How did you manage to make it 1?|||Under the Data Link Connection tab the default packet size is 1. It gives you the option to Edit the value so I bumped it up to 2048.

DTS packages fail after server migration

Hi All
My DTS packages fail after i have migrated my sql server from a NT based
network to a windows 2003 based network and unattached the old domain, I
know that the users that was once on the server as %old domain%\user will no
longer have any rights on the sql server, But how can i change the ownership
of those DTS packages to %New Domain%\New AD User.?
some input would be great.
thanksHave you checked SQLDTS.com. I believe package ownership issues are covered
on that site.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Todd" <Todd_c_wright@.hotmail.com> wrote in message
news:uVew3tSDEHA.3348@.TK2MSFTNGP11.phx.gbl...
Hi All
My DTS packages fail after i have migrated my sql server from a NT based
network to a windows 2003 based network and unattached the old domain, I
know that the users that was once on the server as %old domain%\user will no
longer have any rights on the sql server, But how can i change the ownership
of those DTS packages to %New Domain%\New AD User.?
some input would be great.
thanks|||You can change the owner using the undocumented
sp_reassign_dtspackageowner but the package ownership
probably has nothing to do with the packages failing. You
can sometimes run into issues when someone who isn't the
owner and isn't a sysadmin attempts to modify and save
packages owned by someone else but that's about it.
You can find more info on this at the site Vyas referred you
to:
Package Ownership Issues
http://www.sqldts.com/default.aspx?212
Are these scheduled packages that are failing or do they
fail when run manually as well? What are the errors?
-Sue
On Fri, 19 Mar 2004 09:56:27 +1300, "Todd"
<Todd_c_wright@.hotmail.com> wrote:

>Hi All
>My DTS packages fail after i have migrated my sql server from a NT based
>network to a windows 2003 based network and unattached the old domain, I
>know that the users that was once on the server as %old domain%\user will n
o
>longer have any rights on the sql server, But how can i change the ownershi
p
>of those DTS packages to %New Domain%\New AD User.?
> some input would be great.
> thanks
>

DTS Job - Suspend on fail?

Hi,

Is it possible to somehow set a SQL Server DTS job to automatically
disable itself, when it encounters a fail, so that future scheduled
occurrences don't happen until the problem has been fixed?

I've hunted about for this on the web, but drawn a blank unfortunately!

Many thanks if anyone can help at all.One option would be to configure the job step to quit the job when it
succeeds, but if it fails, then to run a second step. In the second
step, you can then use sp_update_job to disable the job entirely.

Simon|||Thank you Simon, that works great.

The only problem I'm having now is that a failure in my child package
doesn't appear to trigger a failure in the parent package, even though
I have 'Fail Package on First Error' set in both - will have to look
into that.

Simon Hayes wrote:
> One option would be to configure the job step to quit the job when it
> succeeds, but if it fails, then to run a second step. In the second
> step, you can then use sp_update_job to disable the job entirely.
> Simon

DTS import data fail

I try to import data from other database ( that data base is in other country ) and insert into my table .It's succeeded normally but a few day ago it sometime fail .It's seem the data were selected but can't insert into my table . I have already checked filed name and field properties of both source and destination table .It''s same .The error message is below.

Executed as user: SCTINET1\sqlservice. ...t: Create Table TBL_ASCP_PLAN Step DTSRun OnFinish: Create Table TBL_ASCP_PLAN Step DTSRun OnStart: Copy Data from Results to TBL_ASCP_PLAN Step DTSRun OnProgress: Copy Data from Results to TBL_ASCP_PLAN Step; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: Copy Data from Results to TBL_ASCP_PLAN Step; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: Copy Data from Results to TBL_ASCP_PLAN Step; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: Copy Data from Results to TBL_ASCP_PLAN Step; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress: Copy Data from Results to TBL_ASCP_PLAN Step; 5000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 5000 DTSRun OnProg... Process Exit Code 1. The step failed.

Please help me.Sounds like it could be a network problem.

Have you spoke to your network admin staff to see if there are any issues that have not been brought to your attention.

Cheers|||Originally posted by aldo_2003
Sounds like it could be a network problem.

Have you spoke to your network admin staff to see if there are any issues that have not been brought to your attention.

Cheers

Thank you so much "Cheers" . I think it may not concern with the network problem because there are many jobs like this run at the sam time and it 's complete normally.

Waiting for reply|||Ok Mate,

We have elimainated the network issues as the cause. Good.

We can also eliminate the design of the package because becuse it worked before.

What do we have left ? The Data ......

Try this - In your DTS use a SELECT TOP from your source and see if you can get say 100 rows to work without fail.

If you can then you know that somewhere in the data is something that is making your insert fail. Dodgy character , pish data - have a look around and see - esp around the 5000th row.

Hope this helps|||Use DTS Package Logs to know in-depth details about package failure.
Also take help from this KBA (http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074) to resolve the dts when scheduled as a job.

HTH|||Originally posted by aldo_2003
Ok Mate,

We have elimainated the network issues as the cause. Good.

We can also eliminate the design of the package because becuse it worked before.

What do we have left ? The Data ......

Try this - In your DTS use a SELECT TOP from your source and see if you can get say 100 rows to work without fail.

If you can then you know that somewhere in the data is something that is making your insert fail. Dodgy character , pish data - have a look around and see - esp around the 5000th row.

Hope this helps

Thank you so much for many help. Today My DTS package is run complete normally . Yesterday I added some condition "where" in my sql package the run duration is used around 1 hours .( last time I selected all data without any condition ,the run duration was used around 2.00 hours )

Is it possible the set DTS waiting time until the job complete ( no limited ) ? Because the network traffic may busy in some time .

Jupiter_111