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 |
|
shebert
Yak Posting Veteran
85 Posts |
 Posted - 2009-09-08 : 14:36:09
|
| was thinking something like this but it gets errorPublic Sub Main()'Dim fileName As String = CStr(Dts.Variables("WaferFiles").Value)' Returns "World!".Dim subString As String = Microsoft.VisualBasic.Right(fileName, 17)Dim subString2 As String = Microsoft.VisualBasic.Left(subString, 13)Dim sheetName As String = subString2 + "$"Dts.Variables("WorksheetName").Value = sheetNameDts.TaskResult = Dts.Results.SuccessEnd Subedit: moved to proper forum |
|
|
|
|
|
any one see what I'm doing wrong in this vb script