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 |
|
sqlq
Starting Member
1 Post |
 Posted - 2003-08-08 : 19:30:47
|
| Hi there,I have a question. Is there way you can customize DTS. For example I am currently exporting a table in text file. And I want to convert the Entity to place on the comment. Therefore the out come would be 123,comment as one column file in the text file. Also I would like to customize the date. In the table it store as system date and I want to export as 0707 date.Thanks in advance,SQLq |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-08 : 19:41:48
|
| Everything that you said can be done in T-SQL if I am understanding you correctly. Then you just take your T-SQL and post it in the DTS package and export the data using the T-SQL into a file. Post the DDL (CREATE TABLE statement) for your table with some sample data (INSERT statements will get you a quicker answer). Also, post a sample result set.Tara |
 |
|
|
|
|
|
Customize DTS package