With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.
Course Of The Month
7 days, 10 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
migrating SSIS from 2005 to 2008
Posted on 2012-12-28
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
2
- +1
7 Comments
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
asperkins,
Im sorry . I missed that .
crcsupport,
Please try using
namespace System.IO
and see if it works.
Im sorry . I missed that .
crcsupport,
Please try using
namespace System.IO
and see if it works.
Active 1 day ago
For that Just Open script task and Script editor and close it. It will resolve your issue.
Featured Post
Make Your Microsoft Dynamics Investment Count & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Hi all,
It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:
ht…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have.
In this…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
…
Suggested Courses
Course of the Month7 days, 10 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
729 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.