SQL Server Performance

FILE SCRIPT CHECKING

Discussion in 'SQL Server 2005 Integration Services' started by chavakoti, Aug 20, 2007.

  1. chavakoti New Member

    hi frineds i was checked the file exist in a dir or not it's working file
    if file not exist i want to create a file and directory with the bellow condition
    i was placed the file system object for dir and file it working fine indepenedent but now
    we have to club with file check condition and if not exist we have to create how please tell meIf System.IO.File.Exists((CStr(Dts.Variables("ProductBuyListFileLocation").Value) + (CStr(Dts.Variables("ProductBuyListFileName").Value)))) Then Dts.Variables("FileFound").Value = 1
    'MsgBox("FILE FOUND")Else Dts.Variables("FileFound").Value = 0
    'MsgBox("FILE NOT FOUND")
    End If
  2. FrankKalis Moderator

Share This Page