general data tansfer plantform

Question

general data tansfer plantform

nic162534

Valued Member

Points: 62
More actions
December 4, 2008 at 7:26 am

#216041

Hi everyone,
I need to develop a very general data transfer tool for our company with the help of sql server and vs2005.
I have no idea about this project.This tool would be used for data tranfer form client to server, or server to client. Maybe the transmission mode is ftp up/download, webservice form, SQL server DTS,or server to server.
Can someone give a help?
Are there some articles or project cases about data transmission?
Best Regards

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Please see the links in my signature to see how to post to get better answers.

We don't have enough information to give you proper advice. SSIS is designed for data transfer so you could start by investigating that in BOL.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 2

I agree that SSIS is generally going to be the tool that you would use for doing data transfers in almost all cases. It didn't fit our companies business requirements, and I created my own custom .NET Windows Service that works off a SQL database that has control tables that allow for a number of options to be configured and has a meta data table that defines file structures. Our problem is that with the number of vendors that we deal with, we have hundreds of file formats that we receive data in and we have a few dozen that we need to output data in. Since we pay our vendors this has never made since to me, but operations and management decisions don't always make sense to me. I think the vendors should meet my requirements, or we can find another vendor who will, but it is what it is.

You need to provide a whole lot more definition to your problem, and unless it really makes alot of sense to do so, don't reinvent the wheel.