Copy File in SSIS using VB.NET

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  December 20, 2016 at 12:09 pm

  #332908

  I'm trying to copy a Template File to another folder.

  There is an issue with the last line of code.Any ideas?

  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/

• Lowell

  SSC Guru

  Points: 323522

  More actions

  December 20, 2016 at 12:11 pm

  #1919001

  Welsh Corgi (12/20/2016)

  ---

  There is an issue with the last line of code.Any ideas?

  what is the issue? you've been around long enough to know exact errors and a description of the problem are needed.

  do you get an error? what error? did you google the error?

  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!

• Chris Harshman

  SSC-Forever

  Points: 42192

  More actions

  December 20, 2016 at 12:48 pm

  #1919009

  For a simple file copy, since you're using Integration Services, would it make more sense to use the File System Task rather than trying to build your own in script?

  https://msdn.microsoft.com/en-us/library/ms140185.aspx

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  December 20, 2016 at 1:36 pm

  #1919017

  Error at:

  File.Copy(sSource, sTarget, True)

  Access of Shared Member, Contact, enum, member or NestedType through an instance,qualifying expression will not be evaluated.

  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

  December 20, 2016 at 1:40 pm

  #1919019

  Chris Harshman (12/20/2016)

  ---

  For a simple file copy, since you're using Integration Services, would it make more sense to use the File System Task rather than trying to build your own in script?

  https://msdn.microsoft.com/en-us/library/ms140185.aspx

  Thank you.

  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/