DTSX package data transfer error

I will try to explain things the best I can.

When the data is transferred from source to destination (replace not append), the data in one field in one table is incorrect. Both source and destination tables have the same number of rows (8493). The ProductID field data range at the source is from 58958 to 73008. When the table is copied the ProductID field data runs from 1 to 8493.

What would cause this skewing of data?

This happens on brand new dtsx packages and this only happens in one field out of 5 different tables.

I am baffled. Any help is appreciated.

Thanks.

Andrew

Sounds like ProductID is an identity field.

In the OLE DB destination, ensure that you are using a data access mode of "Table or view - fast load" and then make sure the check box is selected for "Keep identity."

See if that helps.|||

Thanks for the quick response Phil.

Where exactly do I look for this setting in Visual Studio?

I must be overlooking it.

Thanks.

Andrew

|||It's in the OLE DB Destination component. Double click on it.|||Did you develop the package, or use the Import/Export wizard?|||I devolped it.|||

FordyH500HP wrote:

I devolped it.

Then what destination are you using? Use the OLE DB Destination if you're not using it already.|||

I'm using the Transfer SQL Server Objects Task from the toolbox.

Will that work for what you are talking about?

|||

FordyH500HP wrote:

I'm using the Transfer SQL Server Objects Task from the toolbar.

Will that work for what you are talking about?

Ahh... What values for the options under "Table Options" do you have?|||

Sorry if I should have stated that sooner.

I'm just above Newbie status in Visual Studio.

CopyIndexes - True

CopyTriggers - False

CopyFullTextIndexes - False

CopyPrimaryKeys - False

CopyForeignKeys - False

GenerateScriptsInUnicode - False

|||What happens if you set CopyPrimaryKeys and CopyForeignKeys to True?|||Same result. It renumbers the ProductID field starting with 1.|||

FordyH500HP wrote:

Same result. It renumbers the ProductID field starting with 1.

Yep, doing a quick search shows that the Transfer SQL Server Objects task does not support identity columns. Will future versions?

Let's find out:
[Microsoft follow-up]

You can do this on your own though, by using an execute sql task in the control flow to truncate the destination tables and then as many data flows as you have tables. Inside the data flows, you can use an OLE DB source and hook it up to an OLE DB destination, and use the options I suggested above.|||

Ok. I think I understand.

So I want to check Keep Identity then in the data flow destination?

Also, can I put multiple Source/Destinations in one data flow?

|||Yep

DTS: Visual FoxPro to SQL Server

Hi,

Today was my first day to use DTS. I tried to transfer a Visual FoxPro Database to my SQL Server. I noticed that I am getting errors on the data that contains date fields. So, for testing purposes I transformed the Visual FoxPro fields that contained datefields into char fields. And this works, but obviously I cannot hunt around in a huge database looking for datefields in tables and change them manually. Plus, by changing to char fields I noticed that those fields that are empty are transformed as 1899-12-30. :p

Does anyone have any ideas?

Thanks,
LauraWhat's the source field datatype?|||The field types are smalldate.|||To make it as paifull as possible, I'd DTS the FP table into a staging table and go from there.

DTS, SMO, SSIS

Database Transfer Services, replaced now by SMO now as I know..

In SQL Server 2005 is SSIS (SQL Server Integration Services).From Microsoft web page:SQL Server Integration Services, or SSIS, is an engine for building data import and export solutions and performing transformations on data as it is transferred.

pls. explain SSIS than? what is latest technology?

SSIS is the new, and very much improved, DTS.

SMO, or SQL Managment Objects, are used to automate common SQL Server functions, I believe...

DTS vs triggers

Hi,

I've got the following problem:

I'm using DTS to transfer fata from csv files into a table.
In the file there are often duplicated rows, therefore I made a
trigger
on the table.

The trigger works fine when i tried in query analyzer, but it not
launched
from the dts.

I've learned that i have to turn of the fast load option in the
properties of the transform data task object.
When I turn this option off, the task will fail with the following
message:

"The number of failing rows exceed the maximum specified.
Cursor operation conflict."

I wonder why this happens. There are no check constraints on the table
against duplication.

Thanks in advance for any helpBijesz wrote:
...
> "The number of failing rows exceed the maximum specified.
> Cursor operation conflict."
> I wonder why this happens. There are no check constraints on the table
> against duplication.

I may have an answer:

Let's assume you've saved your DTS job on the SQL Server, so that when
you are in Ent. Mgr. you can click on the DTS folder, click on the
'local packages' icon, and find your saved DTS job there.

Once there, you'll see the DTS job displayed as a set of 3 objects: 1)
the Excel icon for your source; 2) an arrow pointing to your MSSQL
destination, and; 3) your MSSQL destination.

If you right-click on the Excel or MSSQL objects and open the
Properties window, as I did, you'll be perplexed.

It finally occurred to me to right-click on that arrow and open-up yet
another Properties window there.

Once there, if you click on the 'Options' tab, you'll find a 'Max Error
Count' property. Nice place to hide it, eh?

hth,

victor dileo

DTS Versus Linked Servers

Hello Everyone,
Is it usually faster to transfer data using DTS or over a Linked Server?
Thank you.
Scott
It all depends on what are you transferring. In my experience:
-. For small number of records and ad-hoc transfers, linked server does the
trick
-. For import jobs with transformation, extraction and load, that need to be
performed regularly, DTS may be your candidate
-. For massive amount of data to be transferrend to single tables, BCP out
to text files and BCP in to the target server is faster than linked server or
DTS.
"Scott Yu" wrote:

> Hello Everyone,
> Is it usually faster to transfer data using DTS or over a Linked Server?
> Thank you.
> Scott

DTS Versus Linked Servers

Hello Everyone,
Is it usually faster to transfer data using DTS or over a Linked Server?
Thank you.
ScottIt all depends on what are you transferring. In my experience:
-. For small number of records and ad-hoc transfers, linked server does the
trick
-. For import jobs with transformation, extraction and load, that need to be
performed regularly, DTS may be your candidate
-. For massive amount of data to be transferrend to single tables, BCP out
to text files and BCP in to the target server is faster than linked server o
r
DTS.
"Scott Yu" wrote:

> Hello Everyone,
> Is it usually faster to transfer data using DTS or over a Linked Server?
> Thank you.
> Scott

DTS Versus Linked Servers

Hello Everyone,
Is it usually faster to transfer data using DTS or over a Linked Server?
Thank you.
ScottIt all depends on what are you transferring. In my experience:
-. For small number of records and ad-hoc transfers, linked server does the
trick
-. For import jobs with transformation, extraction and load, that need to be
performed regularly, DTS may be your candidate
-. For massive amount of data to be transferrend to single tables, BCP out
to text files and BCP in to the target server is faster than linked server or
DTS.
"Scott Yu" wrote:
> Hello Everyone,
> Is it usually faster to transfer data using DTS or over a Linked Server?
> Thank you.
> Scott

DTS utility

Hello,
I am using the DTS utility available with Enterprise Manager in MSSQL server 2000. I can transfer the tables and views without any issues but when i try to transfer the stored procedures it always gives an error. I have tried transferring individual objects too but it does'nt works. The error given is "the user <username> cannot perform the following action". Any help is appreciated.
Thanks in AdvanceEasy is to script them and run at target server.|||I always liked Nigel's sig...

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

http://www.sqlteam.com/forums/pop_profile.asp?mode=display&id=1578

And what that basically means, is what your are fundamentally trying to do is not the best way to skin a cat...

You need to undestand the methodolgy of deployement...

If you describe what you are ultimatley trying to do, I'm sure we can help..|||On the lighter side Brett conveyed the message... :D
On the hardest part I feel DTS must be used for data transfer and for this sort of things use Generate Script utility.

Also one of my peer raised this may be a security issue, so convey the permissions for this user on database objects.|||Got the point guys!!! I used the generate script utility, it is easier and without any issues.
Thanks

DTS Unspecified error

I have a DTS to transfer logins from one server to a another server. I have put the syslogins.dat file in the share directory. But this DTS is giving 'Unspecified Error'. Any help would be appreciated.
ThanksI would not try copying a dat file. Use tranfer SQL Objects.|||I guess, the dat file has nothing to do with this DTS. Because, the transfer logins task takes just the source and destination servers. I'm not sure how it transfers the logins and why it should give 'Unspecified error'.|||Are you saying you are not copying the dat? And the DTS is trying to transfer the logins?

What about permissions on both servers?|||I'm not copying the dat file.
What permissions should I check. I ran this DTS from Enterprise Manager. The logins are same in source and destination server.

I just tried to run it through a job and it failed with error 2147467259 (80004005).|||I just tried SQL Server Authentication instead of Windows Authentication and it still gives the same problem. I don't know what the heck this 'Unspecified error' means and this is driving me crazy|||If you have not tried this...
Change the task to something that should have no trouble completeing.
In other words does any work with that DTS?|||Yes. All the other DTS packages execute properly. I just tried 'create table','delete table', 'connection to excel'..etc. and everything just completed fine.

DTS Trimming My Data

Hi

I have a DTS package that pulls data from oracle and inserts it into SQL.
During this transfer, any data that has trailing spaces, loses those spaces
in SQL. i.e. it's been trimmed.

Any way to set DTS not to trim the data ?

Thanks

SteveHi

This may be due to the ANSI_PADDING setting being OFF

http://msdn.microsoft.com/library/d...asp?frame=true

John

"Steve Thorpe" <stephenthorpe@.nospam.hotmail.com> wrote in message
news:bj4qt9$752$1@.titan.btinternet.com...
> Hi
> I have a DTS package that pulls data from oracle and inserts it into SQL.
> During this transfer, any data that has trailing spaces, loses those
spaces
> in SQL. i.e. it's been trimmed.
> Any way to set DTS not to trim the data ?
> Thanks
> Steve

DTS Transfer Table with Text Column slow

I am using DTS to transfer some tables from one server to another as part of a migration. We want to be down for as little time as possible, but we need the most up-to-date copy of the database tables in question.

I am currently testing the transfer process in our test environment by migrating the data from one database to another on the same SQL instance.

There are 7 tables to transfer and the total size of the database is 450 MB (with around 117 MB used). The two largest tables have around 17,000 records each.

One table (the header) has no text column and it takes just a few seconds to transfer. The other table (the detail) has two columns, one of which is a text column (actually, its not fair to call it the detail table; the relationship is actually one-to-one, but for the sake of this discussion, let's leave it at that).

The header takes seconds to transfer, but the detail takes up to 18 minutes.

Physically, our test server is quite robust; 2 processors, a 3 disk RAID-5 for the data files and a separate RAID 1 partition for the logs. Performance counters don't indicate any real issues: during the transfer, the disk utilization on the data partition occasionally spikes to a high level, but comes right back down until the next spike (the spikes being separated by about 1 minute. No issues with memory, paging or CPU.

I have removed the clustered index on the affected table as well as the PK. No help.

Are text columns just slow? Is there something that I am missing?

Regards,

hmscottAre you migraging the entire database, or just the seven tables? If it's the entire database, you should really just detach, move the data and log file, and attach them. Text columns are naturally slower due to how they are stored though.|||Just as in other posts, I'd pick BCP...out...-n/BCP...in...-n -a32764 -h"TABLOCK"|||'kay. Thanks for the responses. Detach/Attach may be a realistic alternative. My only worry is that the servers are in different domains (though I think that should be manageable).

Regards,

hmscott|||He's a question though...

What is the best way to get text out? What about image?

DTS Transfer of 'view over view' fails

Hi - I'm doing a simple SQL object transfer.
If I have a SQL view, aaView that, is for example
Create view aaView as Select * from xxView
View aaView will not be transferred. It appears this is because the creation
of aaView fails because of the reference to xxView (since DTS appears to
re-create the views in alphabetical order of name).
How do I get around this simple issue?
THanks,
Paul.
There is no *good* way...
You can change the name of the view ( painful)... Or simply add another Move
Objects task after the initial and select only the *funky* stuff...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul W" <qqq@.qqq.com> wrote in message
news:eBlcKp1EFHA.2456@.TK2MSFTNGP10.phx.gbl...
> Hi - I'm doing a simple SQL object transfer.
> If I have a SQL view, aaView that, is for example
> Create view aaView as Select * from xxView
> View aaView will not be transferred. It appears this is because the
> creation
> of aaView fails because of the reference to xxView (since DTS appears to
> re-create the views in alphabetical order of name).
> How do I get around this simple issue?
> THanks,
> Paul.
>

DTS Transfer of 'view over view' fails

Hi - I'm doing a simple SQL object transfer.
If I have a SQL view, aaView that, is for example
Create view aaView as Select * from xxView
View aaView will not be transferred. It appears this is because the creation
of aaView fails because of the reference to xxView (since DTS appears to
re-create the views in alphabetical order of name).
How do I get around this simple issue?
THanks,
Paul.There is no *good* way...
You can change the name of the view ( painful)... Or simply add another Move
Objects task after the initial and select only the *funky* stuff...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul W" <qqq@.qqq.com> wrote in message
news:eBlcKp1EFHA.2456@.TK2MSFTNGP10.phx.gbl...
> Hi - I'm doing a simple SQL object transfer.
> If I have a SQL view, aaView that, is for example
> Create view aaView as Select * from xxView
> View aaView will not be transferred. It appears this is because the
> creation
> of aaView fails because of the reference to xxView (since DTS appears to
> re-create the views in alphabetical order of name).
> How do I get around this simple issue?
> THanks,
> Paul.
>

DTS Transfer of 'view over view' fails

Hi - I'm doing a simple SQL object transfer.
If I have a SQL view, aaView that, is for example
Create view aaView as Select * from xxView
View aaView will not be transferred. It appears this is because the creation
of aaView fails because of the reference to xxView (since DTS appears to
re-create the views in alphabetical order of name).
How do I get around this simple issue?
THanks,
Paul.There is no *good* way...
You can change the name of the view ( painful)... Or simply add another Move
Objects task after the initial and select only the *funky* stuff...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul W" <qqq@.qqq.com> wrote in message
news:eBlcKp1EFHA.2456@.TK2MSFTNGP10.phx.gbl...
> Hi - I'm doing a simple SQL object transfer.
> If I have a SQL view, aaView that, is for example
> Create view aaView as Select * from xxView
> View aaView will not be transferred. It appears this is because the
> creation
> of aaView fails because of the reference to xxView (since DTS appears to
> re-create the views in alphabetical order of name).
> How do I get around this simple issue?
> THanks,
> Paul.
>

Dts transfer of a 'view over a view'

Hi - I'm doing a simple SQL object transfer.
If I have a SQL view, aaView that, is for example
Create view aaView as Select * from xxView
View aaView will not be transferred. It appears this is because the creation
of aaView fails because of the reference to xxView (since DTS appears to
re-create the views in alphabetical order of name).
How do I get around this simple issue?
THanks,
Paul.Sorry for the inadvertent re-post.
Paul.
--
"Paul W" <qqq@.qqq.com> wrote in message
news:eQL9hW3EFHA.3504@.TK2MSFTNGP12.phx.gbl...
> Hi - I'm doing a simple SQL object transfer.
> If I have a SQL view, aaView that, is for example
> Create view aaView as Select * from xxView
> View aaView will not be transferred. It appears this is because the
> creation
> of aaView fails because of the reference to xxView (since DTS appears to
> re-create the views in alphabetical order of name).
> How do I get around this simple issue?
> THanks,
> Paul.
>
>

Dts transfer of a 'view over a view'

Hi - I'm doing a simple SQL object transfer.
If I have a SQL view, aaView that, is for example
Create view aaView as Select * from xxView
View aaView will not be transferred. It appears this is because the creation
of aaView fails because of the reference to xxView (since DTS appears to
re-create the views in alphabetical order of name).
How do I get around this simple issue?
THanks,
Paul.
Sorry for the inadvertent re-post.
Paul.
"Paul W" <qqq@.qqq.com> wrote in message
news:eQL9hW3EFHA.3504@.TK2MSFTNGP12.phx.gbl...
> Hi - I'm doing a simple SQL object transfer.
> If I have a SQL view, aaView that, is for example
> Create view aaView as Select * from xxView
> View aaView will not be transferred. It appears this is because the
> creation
> of aaView fails because of the reference to xxView (since DTS appears to
> re-create the views in alphabetical order of name).
> How do I get around this simple issue?
> THanks,
> Paul.
>
>

Dts transfer of a 'view over a view'

Hi - I'm doing a simple SQL object transfer.
If I have a SQL view, aaView that, is for example
Create view aaView as Select * from xxView
View aaView will not be transferred. It appears this is because the creation
of aaView fails because of the reference to xxView (since DTS appears to
re-create the views in alphabetical order of name).
How do I get around this simple issue?
THanks,
Paul.Sorry for the inadvertent re-post.
Paul.
--
"Paul W" <qqq@.qqq.com> wrote in message
news:eQL9hW3EFHA.3504@.TK2MSFTNGP12.phx.gbl...
> Hi - I'm doing a simple SQL object transfer.
> If I have a SQL view, aaView that, is for example
> Create view aaView as Select * from xxView
> View aaView will not be transferred. It appears this is because the
> creation
> of aaView fails because of the reference to xxView (since DTS appears to
> re-create the views in alphabetical order of name).
> How do I get around this simple issue?
> THanks,
> Paul.
>
>

DTS transfer

Hi,

I have the following method which transfers data SQL to SQL on the same server but when I try to change the destination server it won't transfer the data. The method runs through as expected with no exceptions or errors but with no data transfered.

Private

Sub TransferSQLData(ByVal SourceDetailsAs Admin_upload.EnvironmentDetails,ByVal DestinationDetailsAs Admin_upload.EnvironmentDetails)

'Transfer database from source to destination.Dim oPackageAsNew DTS.Package2Dim oConnectionAs DTS.Connection2Dim oStepAs DTS.Step2Dim oTaskAs DTS.TaskDim oCustomTaskAs DTS.TransferObjectsTask2Try

oStep = oPackage.Steps.New

oTask = oPackage.Tasks.New(

"DTSTransferObjectsTask")

oCustomTask = oTask.CustomTask

oPackage.FailOnError =

FalseWith oStep

.Name =

"Copy Database design and data"

.ExecuteInMainThread =

TrueEndWithWith oTask

.Name =

"GenericPkgTask"EndWithWith oCustomTask

.Name =

"DTSTransferObjectsTask"

.SourceServer = "MYSERVER"

.SourceUseTrustedConnection =

True

.SourceDatabase = SourceDetails.MetaDB

.SourceLogin = SourceDetails.MetaUser

.SourcePassword = SourceDetails.MetaPWD

.DestinationServer = "MYSERVER"

.DestinationUseTrustedConnection =

True

.DestinationDatabase = DestinationDetails.MetaDB

.DestinationLogin = DestinationDetails.MetaUser

.DestinationPassword = DestinationDetails.MetaPWD

.CopyAllObjects =

True

.IncludeDependencies =

False

.IncludeLogins =

False

.IncludeUsers =

False

.DropDestinationObjectsFirst =

True

.CopySchema =

True

.CopyData = DTS.DTSTransfer_CopyDataOption.DTSTransfer_ReplaceData

EndWith

oStep.TaskName = oCustomTask.Name

oPackage.Steps.Add(oStep)

oPackage.Tasks.Add(oTask)

oPackage.Execute()

Catch exAs Exception

LabelUploadMeta.Text =

"Failed to Upload MetaData: " & ex.MessageThrow exFinally

oConnection =

Nothing

oCustomTask =

Nothing

oTask =

Nothing

oStep =

Nothing

IfNot (oPackageIsNothing)Then

oPackage.UnInitialize()

EndIfEndTryEndSub

This works fine but when I set the following within the method:

.DestinationServer = "ANOTHERSERVER"

It won't transfer the data.

I can access the remote server and read and write data to it.

Any ideas?

Is the second SQL server registered on the SQL server where you run your DTS?

Does you user under DTS is running has rights to access second server?

Thanks

DTS to transfer data from different database failed

My SQL server is SQL 2000. The DTS package uses SQL anthentication to
transfer data from database A to database B. It fails. The error message
shows Windows NT user or group 'A\Guest' not found.
In DTS package, on Copy SQL Server Objects Task Properties screen, if I
don't select Create destination objects, copy data works. However the
destination tables do not have keys adn indexes.
How can I fix it? Any thoughts? Thanks.Hi
I am not sure why it will allow you to do this assuming that you use the
same users to authenticate when using copy objects and copy tables!
You may want to try scripting the tables including the indexes/pk/fks and
create them before populating them with data. If you have FKs then you will
need to load the data in the correct order if you don't want to
disable/enable the constraint.
John
"Sean" wrote:

> My SQL server is SQL 2000. The DTS package uses SQL anthentication to
> transfer data from database A to database B. It fails. The error message
> shows Windows NT user or group 'A\Guest' not found.
> In DTS package, on Copy SQL Server Objects Task Properties screen, if I
> don't select Create destination objects, copy data works. However the
> destination tables do not have keys adn indexes.
> How can I fix it? Any thoughts? Thanks.
>
>|||Please correct me if I am wrong. When I use SQL authentication for
destination database in DTS package when using copy objects and copy tables,
I thought it should be allowed. Otherwise, how do I make it work? Is there
anything missing?
Thanks.
"John Bell" wrote:
> Hi
> I am not sure why it will allow you to do this assuming that you use the
> same users to authenticate when using copy objects and copy tables!
> You may want to try scripting the tables including the indexes/pk/fks and
> create them before populating them with data. If you have FKs then you wil
l
> need to load the data in the correct order if you don't want to
> disable/enable the constraint.
> John
> "Sean" wrote:
>|||Hi
If you have permissions to create the table then you should be able to use
either method regardless of whether you use SQL Authentication or Windows
Authentication, therefore I am not sure why the copy tables worked and the
copy objects did not (assuming that you did not create the tables first). Yo
u
may want to use SQL Profile to see what is being executed on each of the
servers.
By pre-creating the table you will only need to insert the new data.
John
"Sean" wrote:
> Please correct me if I am wrong. When I use SQL authentication for
> destination database in DTS package when using copy objects and copy table
s,
> I thought it should be allowed. Otherwise, how do I make it work? Is there
> anything missing?
> Thanks.
> "John Bell" wrote:
>|||I agree with you. I assigned public and db_owner role for the SQL account on
database B. I can use that SQL account to create SQL object on database B
manually. The thing I am not sure is, when I run DTS package, why SQL serve
r
chooses 'A\Guest' account on database B.
By the way, how can I use SQL Profile to see what is being executed on each
of the servers?
Thanks.
"John Bell" wrote:
> Hi
> If you have permissions to create the table then you should be able to use
> either method regardless of whether you use SQL Authentication or Windows
> Authentication, therefore I am not sure why the copy tables worked and the
> copy objects did not (assuming that you did not create the tables first).
You
> may want to use SQL Profile to see what is being executed on each of the
> servers.
> By pre-creating the table you will only need to insert the new data.
> John
> "Sean" wrote:
>|||John,
I figured out why the DTS package did not work by using SQL Profile. I have
a user 'A\Guest' on datatase A. That account could not be created on databas
e
B. After I removed that account, the DTS package works.
Thanks for your help.
"John Bell" wrote:
> Hi
> If you have permissions to create the table then you should be able to use
> either method regardless of whether you use SQL Authentication or Windows
> Authentication, therefore I am not sure why the copy tables worked and the
> copy objects did not (assuming that you did not create the tables first).
You
> may want to use SQL Profile to see what is being executed on each of the
> servers.
> By pre-creating the table you will only need to insert the new data.
> John
> "Sean" wrote:
>

dts to copy jobs

We are upgrading our SQL 2000 Enterprise Server to a new server running the
same. When using DTS to transfer the jobs from old server to new 4 of them
will not transfer over to the new server. It just gives a unspecified error.
Any ideas?
You can generate a script for the jobs instead, through Enterprise Manager
(right click a job name, and it is under Tasks). Just run the generated
script on the target server.
Andy Price,
Sr. Database Administrator,
MCDBA 2003
"Tom Reis" wrote:

> We are upgrading our SQL 2000 Enterprise Server to a new server running the
> same. When using DTS to transfer the jobs from old server to new 4 of them
> will not transfer over to the new server. It just gives a unspecified error.
> Any ideas?
>
>