Copy objects with DTS Import/Export Wizard?

Has the functionality of copying objects using the DTS Import/Export Wizard been removed in SQL Server 2005?

MSDN says this about the wizard:

"With the DTS Import/Export Wizard, you can transfer database objects such as indexes, views, roles, stored procedures, and referential integrity constraints. For more information, see Copy SQL Server Objects Task."

But the "for more imformation" link describes adding a task to a DTS package to copy an object, not how to use the wizard to copy objects.

It's been awhile since I've used SQL Server 2000, but as I recall it was possible to copy objects as well as data using the DTS Import/Export Wizard.

Thanks,

Ron

DTS has been enhanced to SSIS(Integration Services) in SQL 2005, so in this case you can use SSIS package to perform that copy SQL Server objects tasks which is similar to the copying the database objects.|||

You have a few options:

Copy Database Wizard:
Use this if you want to copy an entire database.

Right-click on a database in Management Studio, go to "Tasks", and choose "Copy Database...".|||

I also share in their frustrations... When you only have a few objects, in this case tables to transfer; you have very little options in the SQL2005 Import/Export wizard as compared to the SQL2000 DTS (Import/Export) wizard. Copy Database is out of the question for this scenario.

My problem lies in the fact that the SQL2005 Import/Export wizard does not create the indexes and keys when the table needs to be created in the target database, even if the source schema exists on the target database. Is there any way around this without pre-creating the target tables from scripts generated on the source DB? Seems that this manual step should be built into the wizard? Ay suggestions? We are running SP2 for SQL 2005.

There are suggestions that SSIS can be used, thats fine, but given the entirely different interface as compared to DTS, I don't have the time to deal with that when the wizard should be able to do this in a few minutes.

|||That option is fine for SQL2000/2005 to SQL2005, but is there any option to copy to SQL2000?|||I am getting very frustrated, for two days now I've been trying to work out how to copy a database (SQL express version) to my ISP which has the full MS 2005 server. I keep losing keys, stored procedures etc. When you right click on the database as you say and click on tasks there's no copy database there.|||Yey! now I get to spend 2 hours with ssis doing what used to take 2 minutes with dts import wizard.|||

I now use MS Database Publishing wizard which attaches to Database Explorer in Microsoft Developer Express. It works better than DTS Import/Export as I do not lose keys and can copy all object in the database. Great for making backups too.

Copy objects with DTS Import/Export Wizard?

Has the functionality of copying objects using the DTS Import/Export Wizard been removed in SQL Server 2005?

MSDN says this about the wizard:

"With the DTS Import/Export Wizard, you can transfer database objects such as indexes, views, roles, stored procedures, and referential integrity constraints. For more information, see Copy SQL Server Objects Task."

But the "for more imformation" link describes adding a task to a DTS package to copy an object, not how to use the wizard to copy objects.

It's been awhile since I've used SQL Server 2000, but as I recall it was possible to copy objects as well as data using the DTS Import/Export Wizard.

Thanks,

Ron

DTS has been enhanced to SSIS(Integration Services) in SQL 2005, so in this case you can use SSIS package to perform that copy SQL Server objects tasks which is similar to the copying the database objects.|||

You have a few options:

Copy Database Wizard:
Use this if you want to copy an entire database.

Right-click on a database in Management Studio, go to "Tasks", and choose "Copy Database...".|||

I also share in their frustrations... When you only have a few objects, in this case tables to transfer; you have very little options in the SQL2005 Import/Export wizard as compared to the SQL2000 DTS (Import/Export) wizard. Copy Database is out of the question for this scenario.

My problem lies in the fact that the SQL2005 Import/Export wizard does not create the indexes and keys when the table needs to be created in the target database, even if the source schema exists on the target database. Is there any way around this without pre-creating the target tables from scripts generated on the source DB? Seems that this manual step should be built into the wizard? Ay suggestions? We are running SP2 for SQL 2005.

There are suggestions that SSIS can be used, thats fine, but given the entirely different interface as compared to DTS, I don't have the time to deal with that when the wizard should be able to do this in a few minutes.

|||That option is fine for SQL2000/2005 to SQL2005, but is there any option to copy to SQL2000?|||I am getting very frustrated, for two days now I've been trying to work out how to copy a database (SQL express version) to my ISP which has the full MS 2005 server. I keep losing keys, stored procedures etc. When you right click on the database as you say and click on tasks there's no copy database there.|||Yey! now I get to spend 2 hours with ssis doing what used to take 2 minutes with dts import wizard.|||

I now use MS Database Publishing wizard which attaches to Database Explorer in Microsoft Developer Express. It works better than DTS Import/Export as I do not lose keys and can copy all object in the database. Great for making backups too.

sqlsql

Copy objects with DTS Import/Export Wizard?

Has the functionality of copying objects using the DTS Import/Export Wizard been removed in SQL Server 2005?

MSDN says this about the wizard:

"With the DTS Import/Export Wizard, you can transfer database objects such as indexes, views, roles, stored procedures, and referential integrity constraints. For more information, see Copy SQL Server Objects Task."

But the "for more imformation" link describes adding a task to a DTS package to copy an object, not how to use the wizard to copy objects.

It's been awhile since I've used SQL Server 2000, but as I recall it was possible to copy objects as well as data using the DTS Import/Export Wizard.

Thanks,

Ron

DTS has been enhanced to SSIS(Integration Services) in SQL 2005, so in this case you can use SSIS package to perform that copy SQL Server objects tasks which is similar to the copying the database objects.|||

You have a few options:

Copy Database Wizard:
Use this if you want to copy an entire database.

Right-click on a database in Management Studio, go to "Tasks", and choose "Copy Database...".|||

I also share in their frustrations... When you only have a few objects, in this case tables to transfer; you have very little options in the SQL2005 Import/Export wizard as compared to the SQL2000 DTS (Import/Export) wizard. Copy Database is out of the question for this scenario.

My problem lies in the fact that the SQL2005 Import/Export wizard does not create the indexes and keys when the table needs to be created in the target database, even if the source schema exists on the target database. Is there any way around this without pre-creating the target tables from scripts generated on the source DB? Seems that this manual step should be built into the wizard? Ay suggestions? We are running SP2 for SQL 2005.

There are suggestions that SSIS can be used, thats fine, but given the entirely different interface as compared to DTS, I don't have the time to deal with that when the wizard should be able to do this in a few minutes.

|||That option is fine for SQL2000/2005 to SQL2005, but is there any option to copy to SQL2000?|||I am getting very frustrated, for two days now I've been trying to work out how to copy a database (SQL express version) to my ISP which has the full MS 2005 server. I keep losing keys, stored procedures etc. When you right click on the database as you say and click on tasks there's no copy database there.|||Yey! now I get to spend 2 hours with ssis doing what used to take 2 minutes with dts import wizard.|||

I now use MS Database Publishing wizard which attaches to Database Explorer in Microsoft Developer Express. It works better than DTS Import/Export as I do not lose keys and can copy all object in the database. Great for making backups too.

Copy objects with DTS Import/Export Wizard?

Has the functionality of copying objects using the DTS Import/Export Wizard been removed in SQL Server 2005?

MSDN says this about the wizard:

"With the DTS Import/Export Wizard, you can transfer database objects such as indexes, views, roles, stored procedures, and referential integrity constraints. For more information, see Copy SQL Server Objects Task."

But the "for more imformation" link describes adding a task to a DTS package to copy an object, not how to use the wizard to copy objects.

It's been awhile since I've used SQL Server 2000, but as I recall it was possible to copy objects as well as data using the DTS Import/Export Wizard.

Thanks,

Ron

DTS has been enhanced to SSIS(Integration Services) in SQL 2005, so in this case you can use SSIS package to perform that copy SQL Server objects tasks which is similar to the copying the database objects.|||

You have a few options:

Copy Database Wizard:
Use this if you want to copy an entire database.

Right-click on a database in Management Studio, go to "Tasks", and choose "Copy Database...".|||

I also share in their frustrations... When you only have a few objects, in this case tables to transfer; you have very little options in the SQL2005 Import/Export wizard as compared to the SQL2000 DTS (Import/Export) wizard. Copy Database is out of the question for this scenario.

My problem lies in the fact that the SQL2005 Import/Export wizard does not create the indexes and keys when the table needs to be created in the target database, even if the source schema exists on the target database. Is there any way around this without pre-creating the target tables from scripts generated on the source DB? Seems that this manual step should be built into the wizard? Ay suggestions? We are running SP2 for SQL 2005.

There are suggestions that SSIS can be used, thats fine, but given the entirely different interface as compared to DTS, I don't have the time to deal with that when the wizard should be able to do this in a few minutes.

|||That option is fine for SQL2000/2005 to SQL2005, but is there any option to copy to SQL2000?|||I am getting very frustrated, for two days now I've been trying to work out how to copy a database (SQL express version) to my ISP which has the full MS 2005 server. I keep losing keys, stored procedures etc. When you right click on the database as you say and click on tasks there's no copy database there.|||Yey! now I get to spend 2 hours with ssis doing what used to take 2 minutes with dts import wizard.|||

I now use MS Database Publishing wizard which attaches to Database Explorer in Microsoft Developer Express. It works better than DTS Import/Export as I do not lose keys and can copy all object in the database. Great for making backups too.

Copy just new rows

Hi,
I need to copy just the new rows from a Oracle DB to a MS-SQL table. I
created a DTS and I can get the information with no problems the issues is
that I only want to insert the new rows or records created.
Any tipsHow do you expect to define "new rows"?
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"julio delgado" <jdelgado89@.hotmail.com> wrote in message
news:u5z3eMiLFHA.2120@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I need to copy just the new rows from a Oracle DB to a MS-SQL table. I
> created a DTS and I can get the information with no problems the issues is
> that I only want to insert the new rows or records created.
> Any tips
>|||If you're talking about rows with keys that do not exist in the target, you
can use a linked server as follows:
INSERT INTO Target(column_list)
SELECT <column_list> FROM Source AS S
WHERE NOT EXISTS
(SELECT * FROM Target AS T
WHERE T.key = S.key)
Just specify instead of source or target (depending on where you're
connected to) the full four part name (server.db.owner.object).
BG, SQL Server MVP
www.SolidQualityLearning.com
"julio delgado" <jdelgado89@.hotmail.com> wrote in message
news:u5z3eMiLFHA.2120@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I need to copy just the new rows from a Oracle DB to a MS-SQL table. I
> created a DTS and I can get the information with no problems the issues is
> that I only want to insert the new rows or records created.
> Any tips
>|||Thanks
"Itzik Ben-Gan" <itzik@.REMOVETHIS.SolidQualityLearning.com> wrote in message
news:O%23M548iLFHA.1392@.TK2MSFTNGP10.phx.gbl...
> If you're talking about rows with keys that do not exist in the target,
you
> can use a linked server as follows:
> INSERT INTO Target(column_list)
> SELECT <column_list> FROM Source AS S
> WHERE NOT EXISTS
> (SELECT * FROM Target AS T
> WHERE T.key = S.key)
> Just specify instead of source or target (depending on where you're
> connected to) the full four part name (server.db.owner.object).
> --
> BG, SQL Server MVP
> www.SolidQualityLearning.com
>
> "julio delgado" <jdelgado89@.hotmail.com> wrote in message
> news:u5z3eMiLFHA.2120@.TK2MSFTNGP10.phx.gbl...
is
>sqlsql

Copy DTS to another sql-server

Hey,
How can I copy an DTS to another SQL-server?
I made the dts on a testmachine and want to move it now to the SQL-server on
the production machine.
Thanks
Nic
Hi
Open the Package in DTS Designer and then select "Save As". Save it as
structured storage file.
Copy the file to the new server.
From BOL:
To open a DTS package saved to a structured storage file
In the SQL Server Enterprise Manager console tree, right-click Data
Transformation Services, and then click Open Package.
In the Select File dialog box, click the .dts file you want, and then click
Open.
If multiple Data Transformation Services (DTS) packages or package versions
were saved, the Select Package dialog box appears. Click the package or
package version you want to open.
This is all documented in SQL Server Books Online.
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Nic" <Nic@.discussions.microsoft.com> wrote in message
news:F524682D-55CA-4546-BD06-A14B845FFA81@.microsoft.com...
> Hey,
> How can I copy an DTS to another SQL-server?
> I made the dts on a testmachine and want to move it now to the SQL-server
on
> the production machine.
> Thanks
> Nic
|||Hi,
Alternative approaches.
http://databasejournal.com/features/...le.php/1461521
http://www.sqldts.com/default.aspx?242
Thanks
Hari
SQL Server MVP
"Nic" <Nic@.discussions.microsoft.com> wrote in message
news:F524682D-55CA-4546-BD06-A14B845FFA81@.microsoft.com...
> Hey,
> How can I copy an DTS to another SQL-server?
> I made the dts on a testmachine and want to move it now to the SQL-server
> on
> the production machine.
> Thanks
> Nic

Copy DTS to another sql-server

Hey,
How can I copy an DTS to another SQL-server?
I made the dts on a testmachine and want to move it now to the SQL-server on
the production machine.
Thanks
NicHi
Open the Package in DTS Designer and then select "Save As". Save it as
structured storage file.
Copy the file to the new server.
From BOL:
To open a DTS package saved to a structured storage file
In the SQL Server Enterprise Manager console tree, right-click Data
Transformation Services, and then click Open Package.
In the Select File dialog box, click the .dts file you want, and then click
Open.
If multiple Data Transformation Services (DTS) packages or package versions
were saved, the Select Package dialog box appears. Click the package or
package version you want to open.
This is all documented in SQL Server Books Online.
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Nic" <Nic@.discussions.microsoft.com> wrote in message
news:F524682D-55CA-4546-BD06-A14B845FFA81@.microsoft.com...
> Hey,
> How can I copy an DTS to another SQL-server?
> I made the dts on a testmachine and want to move it now to the SQL-server
on
> the production machine.
> Thanks
> Nic|||Hi,
Alternative approaches.
http://databasejournal.com/features...cle.php/1461521
http://www.sqldts.com/default.aspx?242
Thanks
Hari
SQL Server MVP
"Nic" <Nic@.discussions.microsoft.com> wrote in message
news:F524682D-55CA-4546-BD06-A14B845FFA81@.microsoft.com...
> Hey,
> How can I copy an DTS to another SQL-server?
> I made the dts on a testmachine and want to move it now to the SQL-server
> on
> the production machine.
> Thanks
> Nic

Copy DTS to another sql-server

Hey,
How can I copy an DTS to another SQL-server?
I made the dts on a testmachine and want to move it now to the SQL-server on
the production machine.
Thanks
NicHi
Open the Package in DTS Designer and then select "Save As". Save it as
structured storage file.
Copy the file to the new server.
From BOL:
To open a DTS package saved to a structured storage file
In the SQL Server Enterprise Manager console tree, right-click Data
Transformation Services, and then click Open Package.
In the Select File dialog box, click the .dts file you want, and then click
Open.
If multiple Data Transformation Services (DTS) packages or package versions
were saved, the Select Package dialog box appears. Click the package or
package version you want to open.
This is all documented in SQL Server Books Online.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Nic" <Nic@.discussions.microsoft.com> wrote in message
news:F524682D-55CA-4546-BD06-A14B845FFA81@.microsoft.com...
> Hey,
> How can I copy an DTS to another SQL-server?
> I made the dts on a testmachine and want to move it now to the SQL-server
on
> the production machine.
> Thanks
> Nic|||Hi,
Alternative approaches.
http://databasejournal.com/features/mssql/article.php/1461521
http://www.sqldts.com/default.aspx?242
Thanks
Hari
SQL Server MVP
"Nic" <Nic@.discussions.microsoft.com> wrote in message
news:F524682D-55CA-4546-BD06-A14B845FFA81@.microsoft.com...
> Hey,
> How can I copy an DTS to another SQL-server?
> I made the dts on a testmachine and want to move it now to the SQL-server
> on
> the production machine.
> Thanks
> Nic

Copy DTS Package from one server to another

Hi all,
I have a need to copy a DTS Package from one server to another, is this possible?
Thanks,
KenI found the answer I was looking for! Guess Coffee is in need this morning!

copy DTS from a user to another

Hi,
I have some local packages that are owned by the old sqlserver dba.I'm not
able to see them, nor to save them with my user (i have granted the system
administrator role).
I want to see these packages and move them to a new user.
How can I do this?
Thanks in advance,If you are trying to change the owner of these packages, then you can use
the undocumented procedure, sp_reassign_dtspackageowner.
For details refer to: http://www.sqldts.com/?212
http://support.microsoft.com/?kbid=247052
Anith|||Hi,
I saved the DTS package as my user but I'm still not able to edit them.
Is it possible that there's a password?
Thanks,
Tarek
"Anith Sen" wrote:

> If you are trying to change the owner of these packages, then you can use
> the undocumented procedure, sp_reassign_dtspackageowner.
> For details refer to: http://www.sqldts.com/?212
> http://support.microsoft.com/?kbid=247052
> --
> Anith
>
>sqlsql

Copy Database Wizard and DTS Transfer Database Task don't work

Hello,
I work with two SQL-Server 2000 computers. Both hav SP4 for SQL Server
2000. Both belong to the same domain and can see each other without
problems. A mutual registration of the other sql server in Enterprise
Manager is no problem.
One Server's operating system is win2003Server, the other one's is
Win2000Server.
In both servers the domain account I use for logging in and for
authentification purposes is a member of the server's local
administrators group. And the local administrators have sysadmin rights
in sql server 2000 via builtin\administrators.
After some tests I added my windows domain account explicitly as
sysadmin in both SQL-Servers.
The security mode is "mixed" (SQL-Login and Windows).
Trying to transfer a Test database with 1MB space fails. No matter
whether I use a Transfer Database Task or whether I use the Copy
Database Wizard (which also uses DTS in the background).
The Transfer Database Task needs FIVE minutes for the dialog window
"Transfer Database Properties" to reappear after clicking on the
tab-card [file locations].
Below the grid is a green check mark: Files are ready to be moved or
copied.".
Below that is a red X: Files on the source have the same name as on the
destination or there is not enough free disk space on the destination.
On both servers there is plenty of space (dozens of GB).
In the end I only get the error description "Unspecified error".
Doing the same with the Copy Database wizard" in the Grid beside the
..mdf file and the .ldf file shows the STATUS: OK
Below, again two error messages:
Name conflict: Type a new name into the Destination Files fields
Disk space: Change the destination or free disk space
At the same time is shown the space needed and available:
E: Available Space: 56956,00 MB, Required Space: 2,00 MB.
So I run the job in the wizard immediately and get the following
errors:
Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 28000)
Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL
Server]Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection.
Step Error code: 80004005
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:700
Apparently DTS uses odbc and can not establish the connection despite
Sysadmin rights on both servers. I tried to specify the account sa of
sql server for authentication instead of using windows authentication
but that yields the same result.
Would someone know the solution?
Thank you.
Andreas.meyer@.dmc-group.de wrote:
> Hello,
> I work with two SQL-Server 2000 computers. Both hav SP4 for SQL Server
> 2000. Both belong to the same domain and can see each other without
> problems. A mutual registration of the other sql server in Enterprise
> Manager is no problem.
> One Server's operating system is win2003Server, the other one's is
> Win2000Server.
> In both servers the domain account I use for logging in and for
> authentification purposes is a member of the server's local
> administrators group. And the local administrators have sysadmin rights
> in sql server 2000 via builtin\administrators.
> After some tests I added my windows domain account explicitly as
> sysadmin in both SQL-Servers.
> The security mode is "mixed" (SQL-Login and Windows).
> Trying to transfer a Test database with 1MB space fails. No matter
> whether I use a Transfer Database Task or whether I use the Copy
> Database Wizard (which also uses DTS in the background).
> The Transfer Database Task needs FIVE minutes for the dialog window
> "Transfer Database Properties" to reappear after clicking on the
> tab-card [file locations].
> Below the grid is a green check mark: Files are ready to be moved or
> copied.".
> Below that is a red X: Files on the source have the same name as on the
> destination or there is not enough free disk space on the destination.
> On both servers there is plenty of space (dozens of GB).
> In the end I only get the error description "Unspecified error".
> Doing the same with the Copy Database wizard" in the Grid beside the
> .mdf file and the .ldf file shows the STATUS: OK
> Below, again two error messages:
> Name conflict: Type a new name into the Destination Files fields
> Disk space: Change the destination or free disk space
> At the same time is shown the space needed and available:
> E: Available Space: 56956,00 MB, Required Space: 2,00 MB.
> So I run the job in the wizard immediately and get the following
> errors:
> Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 28000)
> Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL
> Server]Login failed for user '(null)'. Reason: Not associated with a
> trusted SQL Server connection.
> Step Error code: 80004005
> Step Error Help File:SQLDMO80.hlp
> Step Error Help Context ID:700
> Apparently DTS uses odbc and can not establish the connection despite
> Sysadmin rights on both servers. I tried to specify the account sa of
> sql server for authentication instead of using windows authentication
> but that yields the same result.
> Would someone know the solution?
> Thank you.
>
Save yourself the headache and stop using these wizards for such a
simple task. Simply take a backup of the source database, then restore
that onto the destination server. The syntax for the BACKUP and RESTORE
commands is pretty simple, see Books Online for details.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Hi Tracy,
of course, I did already.
However, there is so much fuss being made of what sql server 2000 can
do.
Also it is so much stressed in the exams: and dare you you wouldn't
know what the copy database wizard or DTS is able to to and that to use
it is so much easier and surely the best solution when asked for "the
least administrative effort", etc.
Then you try with one of the simplest tasks and in practice it just
fails in an environment where it is truly hard that it wouldn't work.
Yet it doesn't.
Nothing left any more of all the glory...
This is annoying.
Then again, I would like to know the reason for the error message in
odbc.
My impression is: a lot is just marketing but not working, really.
Sincerely
Andreas
Tracy McKibben schrieb:

> Andreas.meyer@.dmc-group.de wrote:
> Save yourself the headache and stop using these wizards for such a
> simple task. Simply take a backup of the source database, then restore
> that onto the destination server. The syntax for the BACKUP and RESTORE
> commands is pretty simple, see Books Online for details.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

Copy Database Wizard and DTS Transfer Database Task don't work

Hello,
I work with two SQL-Server 2000 computers. Both hav SP4 for SQL Server
2000. Both belong to the same domain and can see each other without
problems. A mutual registration of the other sql server in Enterprise
Manager is no problem.
One Server's operating system is win2003Server, the other one's is
Win2000Server.
In both servers the domain account I use for logging in and for
authentification purposes is a member of the server's local
administrators group. And the local administrators have sysadmin rights
in sql server 2000 via builtin\administrators.
After some tests I added my windows domain account explicitly as
sysadmin in both SQL-Servers.
The security mode is "mixed" (SQL-Login and Windows).
Trying to transfer a Test database with 1MB space fails. No matter
whether I use a Transfer Database Task or whether I use the Copy
Database Wizard (which also uses DTS in the background).
The Transfer Database Task needs FIVE minutes for the dialog window
"Transfer Database Properties" to reappear after clicking on the
tab-card [file locations].
Below the grid is a green check mark: Files are ready to be moved or
copied.".
Below that is a red X: Files on the source have the same name as on the
destination or there is not enough free disk space on the destination.
On both servers there is plenty of space (dozens of GB).
In the end I only get the error description "Unspecified error".
Doing the same with the Copy Database wizard" in the Grid beside the
.mdf file and the .ldf file shows the STATUS: OK
Below, again two error messages:
Name conflict: Type a new name into the Destination Files fields
Disk space: Change the destination or free disk space
At the same time is shown the space needed and available:
E: Available Space: 56956,00 MB, Required Space: 2,00 MB.
So I run the job in the wizard immediately and get the following
errors:
Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 28000)
Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL
Server]Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection.
Step Error code: 80004005
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:700
Apparently DTS uses odbc and can not establish the connection despite
Sysadmin rights on both servers. I tried to specify the account sa of
sql server for authentication instead of using windows authentication
but that yields the same result.
Would someone know the solution?
Thank you.Andreas.meyer@.dmc-group.de wrote:
> Hello,
> I work with two SQL-Server 2000 computers. Both hav SP4 for SQL Server
> 2000. Both belong to the same domain and can see each other without
> problems. A mutual registration of the other sql server in Enterprise
> Manager is no problem.
> One Server's operating system is win2003Server, the other one's is
> Win2000Server.
> In both servers the domain account I use for logging in and for
> authentification purposes is a member of the server's local
> administrators group. And the local administrators have sysadmin rights
> in sql server 2000 via builtin\administrators.
> After some tests I added my windows domain account explicitly as
> sysadmin in both SQL-Servers.
> The security mode is "mixed" (SQL-Login and Windows).
> Trying to transfer a Test database with 1MB space fails. No matter
> whether I use a Transfer Database Task or whether I use the Copy
> Database Wizard (which also uses DTS in the background).
> The Transfer Database Task needs FIVE minutes for the dialog window
> "Transfer Database Properties" to reappear after clicking on the
> tab-card [file locations].
> Below the grid is a green check mark: Files are ready to be moved or
> copied.".
> Below that is a red X: Files on the source have the same name as on the
> destination or there is not enough free disk space on the destination.
> On both servers there is plenty of space (dozens of GB).
> In the end I only get the error description "Unspecified error".
> Doing the same with the Copy Database wizard" in the Grid beside the
> .mdf file and the .ldf file shows the STATUS: OK
> Below, again two error messages:
> Name conflict: Type a new name into the Destination Files fields
> Disk space: Change the destination or free disk space
> At the same time is shown the space needed and available:
> E: Available Space: 56956,00 MB, Required Space: 2,00 MB.
> So I run the job in the wizard immediately and get the following
> errors:
> Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 28000)
> Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL
> Server]Login failed for user '(null)'. Reason: Not associated with a
> trusted SQL Server connection.
> Step Error code: 80004005
> Step Error Help File:SQLDMO80.hlp
> Step Error Help Context ID:700
> Apparently DTS uses odbc and can not establish the connection despite
> Sysadmin rights on both servers. I tried to specify the account sa of
> sql server for authentication instead of using windows authentication
> but that yields the same result.
> Would someone know the solution?
> Thank you.
>
Save yourself the headache and stop using these wizards for such a
simple task. Simply take a backup of the source database, then restore
that onto the destination server. The syntax for the BACKUP and RESTORE
commands is pretty simple, see Books Online for details.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Hi Tracy,
of course, I did already.
However, there is so much fuss being made of what sql server 2000 can
do.
Also it is so much stressed in the exams: and dare you you wouldn't
know what the copy database wizard or DTS is able to to and that to use
it is so much easier and surely the best solution when asked for "the
least administrative effort", etc.
Then you try with one of the simplest tasks and in practice it just
fails in an environment where it is truly hard that it wouldn't work.
Yet it doesn't.
Nothing left any more of all the glory...
This is annoying.
Then again, I would like to know the reason for the error message in
odbc.
My impression is: a lot is just marketing but not working, really.
Sincerely
Andreas
Tracy McKibben schrieb:

> Andreas.meyer@.dmc-group.de wrote:
> Save yourself the headache and stop using these wizards for such a
> simple task. Simply take a backup of the source database, then restore
> that onto the destination server. The syntax for the BACKUP and RESTORE
> commands is pretty simple, see Books Online for details.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

Copy Database Wizard and DTS Transfer Database Task don't work

Hello,
I work with two SQL-Server 2000 computers. Both hav SP4 for SQL Server
2000. Both belong to the same domain and can see each other without
problems. A mutual registration of the other sql server in Enterprise
Manager is no problem.
One Server's operating system is win2003Server, the other one's is
Win2000Server.
In both servers the domain account I use for logging in and for
authentification purposes is a member of the server's local
administrators group. And the local administrators have sysadmin rights
in sql server 2000 via builtin\administrators.
After some tests I added my windows domain account explicitly as
sysadmin in both SQL-Servers.
The security mode is "mixed" (SQL-Login and Windows).
Trying to transfer a Test database with 1MB space fails. No matter
whether I use a Transfer Database Task or whether I use the Copy
Database Wizard (which also uses DTS in the background).
The Transfer Database Task needs FIVE minutes for the dialog window
"Transfer Database Properties" to reappear after clicking on the
tab-card [file locations].
Below the grid is a green check mark: Files are ready to be moved or
copied.".
Below that is a red X: Files on the source have the same name as on the
destination or there is not enough free disk space on the destination.
On both servers there is plenty of space (dozens of GB).
In the end I only get the error description "Unspecified error".
Doing the same with the Copy Database wizard" in the Grid beside the
.mdf file and the .ldf file shows the STATUS: OK
Below, again two error messages:
Name conflict: Type a new name into the Destination Files fields
Disk space: Change the destination or free disk space
At the same time is shown the space needed and available:
E: Available Space: 56956,00 MB, Required Space: 2,00 MB.
So I run the job in the wizard immediately and get the following
errors:
Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 28000)
Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL
Server]Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection.
Step Error code: 80004005
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:700
Apparently DTS uses odbc and can not establish the connection despite
Sysadmin rights on both servers. I tried to specify the account sa of
sql server for authentication instead of using windows authentication
but that yields the same result.
Would someone know the solution?
Thank you.Andreas.meyer@.dmc-group.de wrote:
> Hello,
> I work with two SQL-Server 2000 computers. Both hav SP4 for SQL Server
> 2000. Both belong to the same domain and can see each other without
> problems. A mutual registration of the other sql server in Enterprise
> Manager is no problem.
> One Server's operating system is win2003Server, the other one's is
> Win2000Server.
> In both servers the domain account I use for logging in and for
> authentification purposes is a member of the server's local
> administrators group. And the local administrators have sysadmin rights
> in sql server 2000 via builtin\administrators.
> After some tests I added my windows domain account explicitly as
> sysadmin in both SQL-Servers.
> The security mode is "mixed" (SQL-Login and Windows).
> Trying to transfer a Test database with 1MB space fails. No matter
> whether I use a Transfer Database Task or whether I use the Copy
> Database Wizard (which also uses DTS in the background).
> The Transfer Database Task needs FIVE minutes for the dialog window
> "Transfer Database Properties" to reappear after clicking on the
> tab-card [file locations].
> Below the grid is a green check mark: Files are ready to be moved or
> copied.".
> Below that is a red X: Files on the source have the same name as on the
> destination or there is not enough free disk space on the destination.
> On both servers there is plenty of space (dozens of GB).
> In the end I only get the error description "Unspecified error".
> Doing the same with the Copy Database wizard" in the Grid beside the
> .mdf file and the .ldf file shows the STATUS: OK
> Below, again two error messages:
> Name conflict: Type a new name into the Destination Files fields
> Disk space: Change the destination or free disk space
> At the same time is shown the space needed and available:
> E: Available Space: 56956,00 MB, Required Space: 2,00 MB.
> So I run the job in the wizard immediately and get the following
> errors:
> Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 28000)
> Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL
> Server]Login failed for user '(null)'. Reason: Not associated with a
> trusted SQL Server connection.
> Step Error code: 80004005
> Step Error Help File:SQLDMO80.hlp
> Step Error Help Context ID:700
> Apparently DTS uses odbc and can not establish the connection despite
> Sysadmin rights on both servers. I tried to specify the account sa of
> sql server for authentication instead of using windows authentication
> but that yields the same result.
> Would someone know the solution?
> Thank you.
>
Save yourself the headache and stop using these wizards for such a
simple task. Simply take a backup of the source database, then restore
that onto the destination server. The syntax for the BACKUP and RESTORE
commands is pretty simple, see Books Online for details.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Hi Tracy,
of course, I did already.
However, there is so much fuss being made of what sql server 2000 can
do.
Also it is so much stressed in the exams: and dare you you wouldn't
know what the copy database wizard or DTS is able to to and that to use
it is so much easier and surely the best solution when asked for "the
least administrative effort", etc.
Then you try with one of the simplest tasks and in practice it just
fails in an environment where it is truly hard that it wouldn't work.
Yet it doesn't.
Nothing left any more of all the glory...
This is annoying.
Then again, I would like to know the reason for the error message in
odbc.
My impression is: a lot is just marketing but not working, really.
Sincerely
Andreas
Tracy McKibben schrieb:
> Andreas.meyer@.dmc-group.de wrote:
> > Hello,
> > I work with two SQL-Server 2000 computers. Both hav SP4 for SQL Server
> > 2000. Both belong to the same domain and can see each other without
> > problems. A mutual registration of the other sql server in Enterprise
> > Manager is no problem.
> > One Server's operating system is win2003Server, the other one's is
> > Win2000Server.
> > In both servers the domain account I use for logging in and for
> > authentification purposes is a member of the server's local
> > administrators group. And the local administrators have sysadmin rights
> > in sql server 2000 via builtin\administrators.
> > After some tests I added my windows domain account explicitly as
> > sysadmin in both SQL-Servers.
> > The security mode is "mixed" (SQL-Login and Windows).
> >
> > Trying to transfer a Test database with 1MB space fails. No matter
> > whether I use a Transfer Database Task or whether I use the Copy
> > Database Wizard (which also uses DTS in the background).
> > The Transfer Database Task needs FIVE minutes for the dialog window
> > "Transfer Database Properties" to reappear after clicking on the
> > tab-card [file locations].
> > Below the grid is a green check mark: Files are ready to be moved or
> > copied.".
> > Below that is a red X: Files on the source have the same name as on the
> > destination or there is not enough free disk space on the destination.
> >
> > On both servers there is plenty of space (dozens of GB).
> > In the end I only get the error description "Unspecified error".
> >
> > Doing the same with the Copy Database wizard" in the Grid beside the
> > .mdf file and the .ldf file shows the STATUS: OK
> > Below, again two error messages:
> >
> > Name conflict: Type a new name into the Destination Files fields
> > Disk space: Change the destination or free disk space
> >
> > At the same time is shown the space needed and available:
> > E: Available Space: 56956,00 MB, Required Space: 2,00 MB.
> >
> > So I run the job in the wizard immediately and get the following
> > errors:
> >
> > Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 28000)
> > Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL
> > Server]Login failed for user '(null)'. Reason: Not associated with a
> > trusted SQL Server connection.
> > Step Error code: 80004005
> > Step Error Help File:SQLDMO80.hlp
> > Step Error Help Context ID:700
> >
> > Apparently DTS uses odbc and can not establish the connection despite
> > Sysadmin rights on both servers. I tried to specify the account sa of
> > sql server for authentication instead of using windows authentication
> > but that yields the same result.
> > Would someone know the solution?
> >
> > Thank you.
> >
> Save yourself the headache and stop using these wizards for such a
> simple task. Simply take a backup of the source database, then restore
> that onto the destination server. The syntax for the BACKUP and RESTORE
> commands is pretty simple, see Books Online for details.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

Copy Database Wizard

Hello at all,
I want to transfer sql2000 databases and DTS from machine to another; I have
tried to use "Copy Datebase Wizard", but I'm not sure this is the best
choice. Does anyone want to help me?
thank you
Thanks a lot.
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:eVmy20EnHHA.4424@.TK2MSFTNGP03.phx.gbl...
> hi
> see my blog
> http://oneplace4sql.blogspot.com/
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "acolmano" <acolmano@.tin.it> wrote in message
> news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
>
|||Another question. what does occur if don't copy master database to target
machine?
Can I restore all DB with sql backup/restore utility? It's the same?
Thanks
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:eVmy20EnHHA.4424@.TK2MSFTNGP03.phx.gbl...
> hi
> see my blog
> http://oneplace4sql.blogspot.com/
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "acolmano" <acolmano@.tin.it> wrote in message
> news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
>
sqlsql

Copy Database Wizard

Hello at all,
I want to transfer sql2000 databases and DTS from machine to another; I have
tried to use "Copy Datebase Wizard", but I'm not sure this is the best
choice. Does anyone want to help me?
thank youhi
see my blog
http://oneplace4sql.blogspot.com/
--
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"acolmano" <acolmano@.tin.it> wrote in message
news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
> Hello at all,
> I want to transfer sql2000 databases and DTS from machine to another; I
> have tried to use "Copy Datebase Wizard", but I'm not sure this is the
> best choice. Does anyone want to help me?
> thank you|||Thanks a lot.
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:eVmy20EnHHA.4424@.TK2MSFTNGP03.phx.gbl...
> hi
> see my blog
> http://oneplace4sql.blogspot.com/
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "acolmano" <acolmano@.tin.it> wrote in message
> news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
>> Hello at all,
>> I want to transfer sql2000 databases and DTS from machine to another; I
>> have tried to use "Copy Datebase Wizard", but I'm not sure this is the
>> best choice. Does anyone want to help me?
>> thank you
>|||Another question. what does occur if don't copy master database to target
machine?
Can I restore all DB with sql backup/restore utility? It's the same?
Thanks
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:eVmy20EnHHA.4424@.TK2MSFTNGP03.phx.gbl...
> hi
> see my blog
> http://oneplace4sql.blogspot.com/
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "acolmano" <acolmano@.tin.it> wrote in message
> news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
>> Hello at all,
>> I want to transfer sql2000 databases and DTS from machine to another; I
>> have tried to use "Copy Datebase Wizard", but I'm not sure this is the
>> best choice. Does anyone want to help me?
>> thank you
>|||Hi
You can restore master database restore backup cmd. Microsoft recomended way
is using sqlcmd tool
http://msdn2.microsoft.com/en-us/library/ms190679.aspx
--
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"acolmano" <acolmano@.tin.it> wrote in message
news:eHwb62FnHHA.4196@.TK2MSFTNGP06.phx.gbl...
> Another question. what does occur if don't copy master database to target
> machine?
> Can I restore all DB with sql backup/restore utility? It's the same?
> Thanks
>
> "vt" <vinu.t.1976@.gmail.com> wrote in message
> news:eVmy20EnHHA.4424@.TK2MSFTNGP03.phx.gbl...
>> hi
>> see my blog
>> http://oneplace4sql.blogspot.com/
>> --
>> VT
>> Knowledge is power, share it...
>> http://oneplace4sql.blogspot.com/
>> "acolmano" <acolmano@.tin.it> wrote in message
>> news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
>> Hello at all,
>> I want to transfer sql2000 databases and DTS from machine to another; I
>> have tried to use "Copy Datebase Wizard", but I'm not sure this is the
>> best choice. Does anyone want to help me?
>> thank you
>>
>

Copy Database Wizard

I want to copy a database that is currently in use. The
DTS package fails if any user is connected. What command
would I issue to block all new connections to the
database? With new connections blocked and existing ones
finished, I should be able to copy the file the way the
wizard configures the package.Check out the ALTER DATABASE command in BOL
Nathan H.O.|||I assume that you are recommending something like:
ALTER DATABASE myDB SET SINGLE_USER
This command locks when the database is already in use.
>--Original Message--
>Check out the ALTER DATABASE command in BOL
>Nathan H.O.
>|||Not if you specify the proper ROLLBACK option.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Dan" <deletethisprefixandthefirstperiod.cathedr@.dshs.wa.gov> wrote in message
news:2aab201c39270$35205650$a601280a@.phx.gbl...
> I assume that you are recommending something like:
> ALTER DATABASE myDB SET SINGLE_USER
> This command locks when the database is already in use.
>
> >--Original Message--
> >Check out the ALTER DATABASE command in BOL
> >
> >Nathan H.O.
> >

Copy Database Wizard

Hello at all,
I want to transfer sql2000 databases and DTS from machine to another; I have
tried to use "Copy Datebase Wizard", but I'm not sure this is the best
choice. Does anyone want to help me?
thank youhi
see my blog
http://oneplace4sql.blogspot.com/
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"acolmano" <acolmano@.tin.it> wrote in message
news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
> Hello at all,
> I want to transfer sql2000 databases and DTS from machine to another; I
> have tried to use "Copy Datebase Wizard", but I'm not sure this is the
> best choice. Does anyone want to help me?
> thank you|||Thanks a lot.
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:eVmy20EnHHA.4424@.TK2MSFTNGP03.phx.gbl...
> hi
> see my blog
> http://oneplace4sql.blogspot.com/
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "acolmano" <acolmano@.tin.it> wrote in message
> news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
>|||Another question. what does occur if don't copy master database to target
machine?
Can I restore all DB with sql backup/restore utility? It's the same?
Thanks
"vt" <vinu.t.1976@.gmail.com> wrote in message
news:eVmy20EnHHA.4424@.TK2MSFTNGP03.phx.gbl...
> hi
> see my blog
> http://oneplace4sql.blogspot.com/
> --
> VT
> Knowledge is power, share it...
> http://oneplace4sql.blogspot.com/
> "acolmano" <acolmano@.tin.it> wrote in message
> news:OL37WlEnHHA.3952@.TK2MSFTNGP03.phx.gbl...
>|||Hi
You can restore master database restore backup cmd. Microsoft recomended way
is using sqlcmd tool
http://msdn2.microsoft.com/en-us/library/ms190679.aspx
--
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"acolmano" <acolmano@.tin.it> wrote in message
news:eHwb62FnHHA.4196@.TK2MSFTNGP06.phx.gbl...
> Another question. what does occur if don't copy master database to target
> machine?
> Can I restore all DB with sql backup/restore utility? It's the same?
> Thanks
>
> "vt" <vinu.t.1976@.gmail.com> wrote in message
> news:eVmy20EnHHA.4424@.TK2MSFTNGP03.phx.gbl...
>

copy database from web host to local?

Hi,
I also posted this question in sqlserver.DTS because I'm not sure where it
should go.
I'm trying to restore my local db from the one in my web host. I asked the
web host for help, and the only help they can offer is that: "Use SQL Server
Integrated Services (SSIS), which is integrated with the commercial version
of SQL Server Management Studio Express." I don't know what that means.
I also tried the DTSWizard.exe, but it only copies the data. It leaves out
my relationships, the keys, the SPs, etc...
What's the best way to copy a database from one sever to the other so that
everything is included?
Both are sql server 2005, and I want to copy from my web host to my local
server.
Thanks.
VMI (VMI@.discussions.microsoft.com) writes:
> I also posted this question in sqlserver.DTS because I'm not sure where it
> should go.
> I'm trying to restore my local db from the one in my web host. I asked
> the web host for help, and the only help they can offer is that: "Use
> SQL Server Integrated Services (SSIS), which is integrated with the
> commercial version of SQL Server Management Studio Express." I don't
> know what that means.
Well, Integration Services is not included in Express as far as I know.
Probably what they have in mind is the Copy Database Wizard, but you
would need to cough up around 50 USD for Developer Edition to get it.
Problem, though is that you would have to use the SMO method, which is
not very reliable.

> I also tried the DTSWizard.exe, but it only copies the data. It leaves out
> my relationships, the keys, the SPs, etc...
You can use the scripting capabilities in SSMS Express to script the
database, and then copy the data separately.
What you really should have done is do have all your database definition
under version control.

> What's the best way to copy a database from one sever to the other so that
> everything is included?
BACKUP/RESTORE, but that option is not likely to be available in
your situation.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Copy Database from One SQL server to another fails

I am try to run a DTS package to copy a database from one SQL server to
another one.
The DTS package was running fine till yesterday morning but now I am getting
the error message
The Bulk Copy Execution Failed
Error Code 80045707
any thoughts?
drew
Does your SQL Server Service user have enough rights to copy files over the
network?
It might be a problem..
"drew" wrote:

> I am try to run a DTS package to copy a database from one SQL server to
> another one.
> The DTS package was running fine till yesterday morning but now I am getting
> the error message
> The Bulk Copy Execution Failed
> Error Code 80045707
> any thoughts?
> --
> drew
|||Yes the user right are okay, using SA on SQL and Administrator on the windows
2003 servers.
"Umut Nazlica" wrote:
[vbcol=seagreen]
> Does your SQL Server Service user have enough rights to copy files over the
> network?
> It might be a problem..
>
> "drew" wrote:
|||Hi,
Sorry if i'm not clear, what i meant is SQL Server Service on both SQL
servers are not running with Local System Account right?
"drew" wrote:
[vbcol=seagreen]
> Yes the user right are okay, using SA on SQL and Administrator on the windows
> 2003 servers.
> "Umut Nazlica" wrote:
|||The user account are okay. It seems to be a problem the database it self. If
we try and backup and the restore the database to another name on the same
SQL instance. The database hangs on the restore saying it is loading.
Regards Drew
"Umut Nazlica" wrote:
[vbcol=seagreen]
> Hi,
> Sorry if i'm not clear, what i meant is SQL Server Service on both SQL
> servers are not running with Local System Account right?
>
> "drew" wrote:
|||> The user account are okay. It seems to be a problem the database it self.
That would surprise me.

> If
> we try and backup and the restore the database to another name on the same
> SQL instance. The database hangs on the restore saying it is loading.
That is expected if you do the restore using NORECOVERY. Try using RECOVERY instead. Also, make sure
it isn't just EM that doesn't refreshed. Try logging in using Query Analyzer and access the
database.
My guess is that there has been some account changes for the Agent.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"drew" <drew@.discussions.microsoft.com> wrote in message
news:B128608B-0E23-4D66-BE8B-B40CC941B09C@.microsoft.com...[vbcol=seagreen]
> The user account are okay. It seems to be a problem the database it self. If
> we try and backup and the restore the database to another name on the same
> SQL instance. The database hangs on the restore saying it is loading.
> Regards Drew
> "Umut Nazlica" wrote:
|||We got the backup and restore working okay but still problems with the DTS
package.
We tried copying the database to another name name on the same SQL instance
but still get the problem.
If I detach the database and copy it to aother SQL server then attach it
there I again get the problem of not being able to copy it to another name on
the same SQL instance.
If I copy just the objects not the data everything is okay. If I then
compare the databases with SQL compare everything is okay.
If I try to use the DTS copy databse task to just copy the data. Using SQL
compare the permmisions on the databse tables change with the public role
being dropped and the not null constraint check becomig just not null.
Talkig with Microsoft but still not much further forward.
"Tibor Karaszi" wrote:

> That would surprise me.
>
> That is expected if you do the restore using NORECOVERY. Try using RECOVERY instead. Also, make sure
> it isn't just EM that doesn't refreshed. Try logging in using Query Analyzer and access the
> database.
> My guess is that there has been some account changes for the Agent.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "drew" <drew@.discussions.microsoft.com> wrote in message
> news:B128608B-0E23-4D66-BE8B-B40CC941B09C@.microsoft.com...
>
>
|||we final got the problem resolved with the help of Kevin at MSDN.
In the database some had created a blob bigger than 8 Meg, this caused the
DTS package to fail. hen we romved the offending records the package ran
okay.
see KB 257425
regards Drew
"drew" wrote:
[vbcol=seagreen]
> We got the backup and restore working okay but still problems with the DTS
> package.
> We tried copying the database to another name name on the same SQL instance
> but still get the problem.
> If I detach the database and copy it to aother SQL server then attach it
> there I again get the problem of not being able to copy it to another name on
> the same SQL instance.
> If I copy just the objects not the data everything is okay. If I then
> compare the databases with SQL compare everything is okay.
> If I try to use the DTS copy databse task to just copy the data. Using SQL
> compare the permmisions on the databse tables change with the public role
> being dropped and the not null constraint check becomig just not null.
> Talkig with Microsoft but still not much further forward.
> "Tibor Karaszi" wrote:

Copy Data to excel file using dts package in sql server 2000

Friends

Any one of you share your knowledge how to transfer data from a database to a excel using dts packages in sqlserver 2000.

I want clear steps how to create a dts package

Appreciate your help

Thanks

satish

http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg

You might try this group instead, as this forum is for SQL Server Integration Services