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 |
|
bullied
Starting Member
4 Posts |
 Posted - 2008-08-20 : 20:36:09
|
| My input file is 20080812,0915,711,0 (date, time, job run duration and return code).Simply outputting the file it comes out in CSV format, but when I attempt to parse the file I get the actual file name. Some of the code follows. Dim oFSO, ntf Dim oFile Dim sSourceFilesSourceFile = \\directory\\...Set oFile = oFSO.Getfile(sSourceFile)pyrts1 = Left(eSourceFile,8)This produces \\direct, instead of 20080812. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-21 : 03:39:13
|
| what's that you're trying to do with this file in dts? |
 |
|
|
bullied
Starting Member
4 Posts |
Posted - 2008-08-21 : 11:13:46
|
quote:
Originally posted by visakh16
what's that you're trying to do with this file in dts?
I need to parse out the individual values and format and frmat emails based on the value of the job return code. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-21 : 12:45:59
|
| Cant you use a tranform data task to get this done? |
|
|
|
bullied
Starting Member
4 Posts |
Posted - 2008-08-21 : 13:12:52
|
quote:
Originally posted by visakh16
Cant you use a tranform data task to get this done?
Investigating these more. I understood transformations to merely map data to data by name. |
|
|
|
bullied
Starting Member
4 Posts |
Posted - 2008-08-21 : 14:42:31
|
| I have hit the same problem, I can print the input, but I cannot access the data directly, I get either blanks or the actual file name. Printing the input works fine. |
|
|
|
|
|
|
Basic understanding of DTS file processing