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 |
|
kelcog
Starting Member
3 Posts |
 Posted - 2006-03-13 : 14:47:47
|
| i have a package that imports data from a text file into a table in my database. one of the fields that is imported has comma delineated values. I need to use a SQL statement in my package to separate those values and place them into separate fields in my table.Can anyone give me a lead as to how to do this? I am stumped. |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-03-13 : 16:27:29
|
| U can make use of the DTS package and do ur taskOne way is to use TextFile as the Source |
 |
|
|
kelcog
Starting Member
3 Posts |
Posted - 2006-03-13 : 17:11:12
|
| Okay, but i am confused about where to begin.so far my packagegets files via ftpimports file to temp databaseuses sql query to format a few fields into format needed for real databaseand here is where i need to access a field in the temp database that has values that look like item1,item2,item3,etc. and put them in field1, field2, field3, etc of the real database.The "do ur task" is the part I don't understand |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
separate comma delineated data