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 |
|
pazzy11
Posting Yak Master
145 Posts |
 Posted - 2008-05-27 : 10:28:21
|
| Hey I have this task i need to do, I have a table with email info..to, from, subject, body* *body is a path to a txt file that contains the body.I need to get all email info in a txt file, and the body (as the real body .. not the path) I thought this would be simple, I failed getting an ActiveX transformation to get the contents of the txts files, So my next way is using the BULK INSERT task to populate a tmp table with the contents of the files, problem is i need to pass the paths as arguments to the BULK INSERT task (or SP ) .. problem is it needs to loop somehow as the path is always different ... how can i approach this ? cursors ? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-05-28 : 03:12:57
|
| You mean you want to create a text file with all the info?Just create a text file with all the info apart from the body then concatenate the body text file with the one you just created.You shouldn't need to import the body text file unless the path isn't available to concatenate.Yes you will have to loop through the table that contains the email info. Usually there is an identity column on these tables to make it simple.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
SQL Task ..