IF Exist Delete file and copy a Template File VB.NET Script Task

Question

IF Exist Delete file and copy a Template File VB.NET Script Task

Welsh Corgi

SSC Guru

Points: 116520
More actions
December 20, 2016 at 7:43 am

#316168

I'm trying to remember how I would check for the existence of a file and Delete it in a VB.NET Script Task.
If it exist I want to Delete the file and copy the template file to the directory where I deleted the file.
I also want to archive the existing file in another folder.
I'm search for good articles on how to do this in VB.
Does anyone have a good example?
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247180 More actions · Answer 1

Welsh Corgi (12/20/2016)
I'm trying to remember how I would check for the existence of a file and Delete it in a VB.NET Script Task.
If it exist I want to Delete the file and copy the template file to the directory where I deleted the file.
I also want to archive the existing file in another folder.
I'm search for good articles on how to do this in VB.
Does anyone have a good example?
Thanks.

This advanced search finds any number of articles which do the job.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Actually I'm going to move the file but that is the same principle as a copy.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

This line is not right:

File.Copy(sSource, sTarget, True)

What am I missing?

Public Sub Main()

Dim sSource As String

Dim sTarget As String

Dim File As String

sSource = "U:\ZZZ_ImportCreditDataNew\ImportCreditDataNew\Templates\SSISErrorLog.xlsx"

sTarget = "U:\ZZZ_ImportCreditDataNew\ImportCreditDataNew\SSISErrorLog.xlsx"

File.Copy(sSource, sTarget, True)

Dts.TaskResult = ScriptResults.Success

End Sub

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Phil Parkin SSC Guru Points: 247180 More actions · Answer 4

What am I missing?

A detailed explanation of the problem you are having and details of the error you are receiving.

Lowell SSC Guru Points: 323547 More actions · Answer 5

Welsh Corgi (12/20/2016)
What am I missing?

also a try catch to capture any errors raised you did not expect.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 6

I moved the post to http://www.sqlservercentral.com/Forums/Topic1844606-364-1.aspx

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Jeff Moden SSC Guru Points: 1004642 More actions · Answer 7

Welsh Corgi (12/20/2016)
I moved the post to http://www.sqlservercentral.com/Forums/Topic1844606-364-1.aspx

You really need to not do that anymore. This is the 3rd post on the same subject. Most of the heavy hitters that actually can help you monitor ALL the forums. You moving things around just serves to confuse, split resources, and generally make it more difficult to help you. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)