Lowell (12/21/2016)

---

Dts.Events.FireError is what you want.

is your account used by a team of users, and not an individual?

Trivially adapted from part of an answer I posted for you yesterday...

Lowell (12/21/2016)

---

Dts.Events.FireError is what you want.

is your account used by a team of users, and not an individual?

Trivially adapted from part of an answer I posted for you yesterday...

I agree.

Command Task?

Jeff,

I only got the delete part complete:

Public Sub Main()

Dim FileToDelete As String

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

...

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...

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.

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

This line is not right:

File.Copy(sSource, sTarget, True)

What am I missing?

Public Sub Main()

Dim sSource As String

...

David Data (6/25/2010)

---

Just to add to what Raunak said - you can ONLY select the script language when you create a new Script Task; once you've clicked on Edit Script...

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

Please disregard this post.

I need to output the Query results to a file and send as an attachment.

I guess that I need create a Script task to delete the existing if it exist?

The following will output to a CSV but I do not want a CSV Format.

What are my options?

bcp "SELECT Col1,Col2,Col3 FROM MyDatabase.dbo.MyTable" queryout "D:\MyTable.csv" -c -t , -S

Lowell (12/6/2016)

---

just read and work through your errors; you seem to be changing stuff pretty quick to try and get it to work.

your latest error is just because you checked...