Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-16 : 10:19:06
|
| Boris Tyukin writes "Hello! I need your help. I want to create dts package in MS SQL server database. It should get csv-formated file and copy data from it to MS SQL table. I have created dts-object in ColdFusion from saved package and point the source of csv-file. Csv-files are different from each other only in number of columns. The question is how to create dts-package, which can import data from cvs-files with different numbers of columns. I have an idea to create VBscript, which would be able to analize connection object of source cvs-file, get columns and create after it table with that columns and corresponding transformation task. But I am not goog at VB. Is there more easy way? or have you any working sample?Help me,pleaseAll the best" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-16 : 10:21:15
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=15866 |
 |
|
|
|
|
|
to create dts-package, which can import data from cvs-files with different numbers of columns