I have a problem importing data with SQL. I want to transfer data from one SQL server to another. Apparently I only managed to transfer data when the new table is empty. I am choosing Append data to existing table but this is not working for me.
What am I doing wrong?


************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Are you using the Transfer Objects task?

Drop this task and have a look at the following article. although it is
not SQL Server to SQL Server the pronciple if is the same

Building a Package in the DTS Designer
(http://www.sqldts.com/default.aspx?278)



powerpoint (AT) powerpoint (DOT) com.mt wrote:
--


Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com

Yes, I am using DTS Import/Export Data.
Funilly enough I manage to transfer data when there is nothing in the new table.
If there is already some date in the new table, it will not allow data to be updated in the table and instead creates a new table with the $ sign.
This is the first time I am using SQL.


************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

With the $ symbol?

You would seem to be moving data from Excel right?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Joe" <powerpoint (AT) powerpoint (DOT) com.mt> wrote

Yes indeed. I first copy data onto excell for some modifications and then move data onto the new server.
I get primary contstraints error sometimes.

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

OK

Follow the article I sent you to create a package. The data source used is in the main not really relevant when we are just
starting out.

PK errors.

Look at the destination/Ask the DBA about the Primary Key attributes on the table. Now have a look at your spreadsheet and you
should be able to look through the same attributes there nd spot the problems. You cannt have duplicate values across a PK
constraint.

Personally I would look to import the spreadsheet into a working table and then use TSQL to do the UPDATE, INSERT , DELETE.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Joe" <powerpoint (AT) powerpoint (DOT) com.mt> wrote

Eventually, that was my intention, to import data from an excel file. but I still can't find a clue.
Are you willing to show me how if I give you access through pc anywhere?
I am willing to pay a fee.
What do you think?


************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Contact me offline and we can develop your requirements further. We can maybe build a few packages together.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Joe" <powerpoint (AT) powerpoint (DOT) com.mt> wrote

Hi,
I installed WinSQL and I managed to transfer a great deal of data from one database onto another. But when it comes to Items I am getting the following question:
LOMG DATA IS NOT AT THE END OF THE QUERY RESULT.

HOw do I do this in an sql query?

and,

How do I contact you offline?

Thanks a lot
Regards
Joe.


************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

If you are taking the whole of one database from ServerA to ServerB the
easiest way to do it is to use BACKUP/RESTORE.

My eMail address is as you see in the posts - no-spam



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Joe" <powerpoint (AT) powerpoint (DOT) com.mt> wrote