March 31, 2006 at 5:07 am
Hi
I've been doing a fair bit of reading about DTS/IS (we'll hopefully be moving from SQL 2000 to 2005 shortly). I've pretty much convinced myself that DTS/IS is suitable for the task I want to perform.
I'd be grateful for any feedback/thoughts.
My task is to be able to accept document imports in csv, xml or some other structured type of document into a specified folder on the server then have SQL Server automatically import it into the database.
During the import process I would need to be able to read the data and make decisions/manipulate the data before it is inserted into the database.
I would also need to add data depending on certain decisions into the record before inserting it into the database.
Sound like a reasonable set of requirements for DTS/IS?
Windows 2008 Server | SQL Server 2008
March 31, 2006 at 5:21 am
No problem!
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 31, 2006 at 5:25 am
Excellent! That's the most succinct answer I've ever received on a forum! Thank you very much!
Windows 2008 Server | SQL Server 2008
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply