May 29, 2012 at 6:39 am
Hi,
I have a req to send the table data into csv file through SSIS package.for that i have created package which gets data from source to destination that worked fine for me
2. next scenario i have taken execute sql task and written a query which gets the filename as SDF_5_8_2012.csv
SELECT DISTINCT
'SDF_' + rtrim(CONVERT(char(2), MONTH([Load Date]),112)) + '_' + rtrim(CONVERT(char(2), DAY([Load Date]), 112)) + '_' + CONVERT(char(4), YEAR([Load Date]), 112)
+ '.csv' AS Filename
FROM tablename
I have two variables
1.file name - SDF_5_8_2012.csv
2.fulll path -
3.In the third scenario using script task for full path variable
Public Sub Main()
'
' Add your code here
'
Dim Pathstring As String
Dim Filenamestring As String
Filenamestring = Dts.Variables("User::Filename").Value.ToString
Pathstring = "X:\ExportCSV\CDE_REPORTS\"
DateString = Pathstring & Filenamestring
Dts.Variables("User::FullPath").Value = DateString
'MsgBox(DateString).ToString()
Dts.TaskResult = ScriptResults.Success
End Sub
End Class
4.In tha last scenario file system task i am copying SDF to full path
all the tasks are executed fine but in the script task i am getting error as conversion of string Pathstring = "X:\ExportCSV\CDE_REPORTS\"
as date.
Can anyone please help me..
May 29, 2012 at 8:46 am
Please post the exact text of the error message.
May 29, 2012 at 9:04 am
I am getting problem in the script task -- full path failed
I have two variables
1.filename - SDE_5_7_2012.csv
2.fullpath - X:\ExportCSV\CDE_REPORTS
Public Sub Main()
'
' Add your code here
'
Dim Pathstring As String
Dim Filenamestring As String
Dim DateString As String
Filenamestring = Dts.Variables("User::Filename").Value.ToString
Pathstring = "X:\ExportCSV\CDE_REPORTS\"
DateString = Pathstring & Filenamestring
Dts.Variables("User::FullPath").Value = DateString
MsgBox(DateString).ToString()
Dts.TaskResult = ScriptResults.Success
End Sub
End Class
can you please help me what is the issue in the code?
May 29, 2012 at 9:10 am
Apart from the fact that
MsgBox(DateString).ToString()
looks weird (use MsgBox(DateString) instead), I can't see a problem. But if you post the full text of the error message (just copy & paste), it may throw more light on the problem.
Viewing 4 posts - 1 through 4 (of 4 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