How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.
migrating SSIS from 2005 to 2008
I have script task in a package. It works fine on SQL2005. It doesn't work on SQL 2008. It does not give error message, just can not find the file.This is the code:
Imports System
Imports System.Data
Imports Microsoft.SqlServer.Dts.Ru
Public Class ScriptMain
Public Sub Main()
If System.IO.File.Exists(Dts.
Dts.Variables("FileExists"
Else
Dts.Variables("FileExists"
End If
Dts.TaskResult = Dts.Results.Success
End Sub
End Class
Any ideas what could be the problem ?
Thank you
Imports System
Imports System.Data
Imports Microsoft.SqlServer.Dts.Ru
Public Class ScriptMain
Public Sub Main()
If System.IO.File.Exists(Dts.
Dts.Variables("FileExists"
Else
Dts.Variables("FileExists"
End If
Dts.TaskResult = Dts.Results.Success
End Sub
End Class
Any ideas what could be the problem ?
Thank you
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I think you might need to download DTS Run time librabries from microsoft for backward compatibility as sql 2008 doesnt support it anymore.
http://msdn.microsoft.com/en-us/library/ms143755(v=sql.105).aspx
http://msdn.microsoft.com/en-us/library/ms143755(v=sql.105).aspx
Premium Content
You need an Expert Office subscription to comment.Start Free Trial