May 8, 2006 at 11:52 am
Hi all,
I got 2 text files and need to transform the data into one single text file. On the first transformation, I used the following codes:
if DTSSource("Col015") <> "000" Then
DTSDestination("Col001") = DTSSource("Col009")
DTSDestination("Col002") = DTSSource("Col015")
Main = DTSTransformStat_OK
Else
Main = DTSTransformStat_SkipRow
End if
On the second transformation, I used the following codes:
Dim objFSO, objFolder, objShell, objTextFile, objFile
Dim strDirectory, strFile, strText
strDirectory = "e:\mcif\woodstone"
strFile = "\beacon-lkup.txt"
' Create the File System Object
Set objFSO = CreateObject("Scripting.FileSystemObject")
' Check that the strDirectory folder exists
If objFSO.FolderExists(strDirectory) Then
Set objFolder = objFSO.GetFolder(strDirectory)
Else
Set objFolder = objFSO.CreateFolder(strDirectory)
msgbox("Just created " & strDirectory)
End If
If objFSO.FileExists(strDirectory & strFile) Then
Set objFolder = objFSO.GetFolder(strDirectory)
Else
Set objFile = objFSO.CreateTextFile(strDirectory & strFile)
msgbox("Just created " & strDirectory & strFile)
End If
set objFile = nothing
set objFolder = nothing
' OpenTextFile Method needs a Const value
' ForAppending = 8 ForReading = 1, ForWriting = 2
Const ForAppending = 8
Set objTextFile = objFSO.OpenTextFile (strDirectory & strFile, ForAppending, True)
DTSDestination("Col001") = DTSSource("Col009")
DTSDestination("Col002") = DTSSource("Col015")
Main = DTSTransformStat_OK
When I tested and ran the transformations separately, they were working fine. However, when I ran the transformations together, I got 2 error messages:
1. The Data Pump Task requires Transformations to be specified.
2. The number of failing rows exceeds the maximum specified.
Error Code: 0
Error Source = Microsoft VBScript runtime error.
Error Description: Permission denied.
Error on Line 36
Can anyone help? Thanks!!
May 9, 2006 at 11:37 am
sounds like you don't have permissions to write to the file under the credentials specified for the job.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy