Hi Guys,
I'm trying to develop an application and I have been told right here in sql server getting started forum that SSIS or DTS are the best bits.
My old post has these questions:
Code Snippet
I'm making an application. I have 2 different sites running Sql Server 2005 workgroup and sql server express.
I have a 3rd main server and what I would need to do is to get some of the data from both of these sites, merge it and save it on Main server and then generate another file which should be placed in a directory on a network.
I don't have any idea of how I would do that. Its entirely a sql server app.
One person told me its an SSIS and the other one said to investigate replication.
I have checked a bit about both. I want to give it a try.
Where can i find tutorials on both of these. Complete tutorials to develop and design it.
Thanks
Gemma
books on line are a good starting point:
http://msdn2.microsoft.com/en-us/library/bb545450.aspx
|||Hi Rafael,
I was thinking more in terms apart of books online. I'm not that clever like you guys, you know.
Apart can you tell me if i put Sql Server 2000 as the main server Can i access the Sql Server 2005 and get some data as I tried it and it doesn't work using DTS.
Thanks
Gemma
|||
Gemma wrote:
Apart can you tell me if i put Sql Server 2000 as the main server Can i access the Sql Server 2005 and get some data as I tried it and it doesn't work using DTS.
Can somebody plz reply to this thread? plz. plz. plz.
Thanks
Gemma
This is a quick set of tutorials on SSIS (included as part of Books Online): http://msdn2.microsoft.com/en-us/library/ms169917.aspx
I'd really recommend going through that first, before getting other books.
As a more general reply to your question, SSIS should be able to accomplish what you want to do.
