January 10, 2010 at 11:57 am
Hello Comunity
I want to know, if it´s possible to import through DTS a text file into sql server 2008 table and also create a schedule to run this script on command line batch file.
Also , after importing my text file i want to rename it to myfile.txt.lido to prevent importing them again without loosing the same, if later i want to reimport it.
I think it´s possible, but i want to know best suggestions about to do it.
Many thanks
Luis Santos
January 10, 2010 at 1:43 pm
I would suggest using SSIS Packages.
| If in Doubt...don't do it!! |
January 10, 2010 at 3:04 pm
Before planning to use DTS to import data into a SQL 2008 DB I suggest you read the following articles, which basically say "it ain't simple"
Support for Data Transformation Services (DTS) in SQL Server 2008
Although SQL Server 2000 Data Transformation Services (DTS) is deprecated,
http://msdn.microsoft.com/en-us/library/bb500440.aspx
and to learn what additional items must be installed since they are not installed during an installation of SQL Server 2008
SQL Server 2008 Books Online (November 2009)
Data Transformation Services (DTS)
Data Transformation Services (DTS) has been replaced by SQL Server Integration Services.
SQL Server 2008 Setup does not install DTS support.
http://msdn.microsoft.com/en-us/library/cc707786.aspx
I would suggest following thlubbe's advice.
January 10, 2010 at 5:45 pm
If this is running on a SQL 2000 server, use DTS. If it runs from SQL 2008, use SSIS.
In either case, you can use the Import Wizard to get you a base package to do the work.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply