Wrox Programmer Forums
|
BOOK: Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services
This is the forum to discuss the Wrox book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services by Brian Knight, Devin Knight, Mike Davis ISBN: 978-0-470-49692-3
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 26th, 2012, 09:53 AM
Registered User
 
Join Date: Mar 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Lesson 9 File.Exists returns false everytime

I was trying to implement the lesson 9 video example and can't get file.exists function to work. I added import system.IO and set "strFileName" to C:\SSISProjects\Data\Lesson9.txt and change permissions to allow SSIS service acct to access this directory and file but function always returns false.

Public Sub Main()
'
' Add your code here
' MsgBox(Dts.Variables("strFileName").Value)
If File.Exists(Dts.Variables("strFileName").Value) Then
Dts.Variables("bolFileExists").Value = True
Else
Dts.Variables("bolFileExists").Value = False
End If
MsgBox(Dts.Variables("bolFileExists").Value)
'
Dts.TaskResult = ScriptResults.Success
End Sub
 
Old January 26th, 2014, 10:10 AM
Registered User
 
Join Date: Jan 2014
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Drop to a command prompt on your system and post the results of

dir C:\SSISProjects\Data\





Similar Threads
Thread Thread Starter Forum Replies Last Post
Lesson 16 File I-O MRGLENN BOOK: Java Programming 24-Hour Trainer by Yakov Fain 2 February 24th, 2012 03:55 AM
File Already exists Error srsandhu Classic ASP Basics 7 February 23rd, 2007 04:21 PM
File already exists srsandhu ASP.NET 1.0 and 1.1 Basics 1 February 14th, 2007 08:43 PM
rs.eof returns false hastikeyvan Dreamweaver (all versions) 3 February 4th, 2006 11:08 AM
SQL result returns nothing, but empty == false? barddzen Pro JSP 1 August 9th, 2004 12:52 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.