import excel in sql server 2005
-
i need to import inside a sql server 2005 table a file exel with a column with some strings. column ------- sfsdfsfd dsfsfgg 54432fd dss43r gdgdgdfgd43 gdfgdfg43 etc... how can i do?
Use DTS Look where you want to go not where you don't want to crash. Bikers Bible
-
Use DTS Look where you want to go not where you don't want to crash. Bikers Bible
-
DTS : Data Transformance Services Used to import export information by SQL server in Packages that can be run as timed or scheduled events. Look where you want to go not where you don't want to crash. Bikers Bible
-
DTS : Data Transformance Services Used to import export information by SQL server in Packages that can be run as timed or scheduled events. Look where you want to go not where you don't want to crash. Bikers Bible
Frank Kerrigan wrote:
DTS : Data Transformance Services
DTS was renamed SSIS (SQL Server Integration Services) in SQL Server 2005 - It didn't happen until the after the first beta went out so the development team decided not to rename all the classes - So the namespace for programatically accessing SSIS still refers to DTS or DataTransformationServices.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog