Brandie Tarvin (4/25/2014)

---

Trying Cadavre's script I get the following error:

A WebException has been caught.System.UriFormatException: Invalid URI: The URI scheme is not valid.

at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind...

Ouch. You should be leery of ever using the "allow data loss" switch with...

Jeff Moden (4/25/2014)

---

"Sure you are? Dark Side...

RazorbackDBA (4/25/2014)

---

After thinking about your question, I would need to caputure both new records and any updated records. There is a lastmodified column in the tables I need to copy,...

Depends on what WHERE clause filters you use. I've done it before where I join on...

Troubleshooting I/O issues depends on the DBA. Everyone does the same set of checks, but different people do it in different orders. Me, I prefer to verify SQL Server first....

Trying Cadavre's script I get the following error:

A WebException has been caught.System.UriFormatException: Invalid URI: The URI scheme is not valid.

at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind)

...

Ville-Pekka Vahteala (4/25/2014)

---

Brandie Tarvin (4/25/2014)

---

The misconception would be mine, then. This is sample code supplied to me by the vendor receiving the file. It seems pretty generic and the person...

Cadavre (4/25/2014)

---

I didn't refresh the page before I posted, so didn't spot that David Burrows had already answered. The majority of the changes I've made are formatting so that I...

If you throw a DISTINCT into the code I provided, it solves your problem.

But as Lynn said, we can't provide you with a definite answer without some DDL, sample data,...

The misconception would be mine, then. This is sample code supplied to me by the vendor receiving the file. It seems pretty generic and the person who gave it to...

Then what are you averaging by?

As far as I can tell, it's reading in chunks because that's how it transmits. It's part of the multiform / data-part thing. But again, I got this code from...

I just posted an issue with a VB Script Task (SSIS) and would appreciate the thoughts of anyone with experience.

My in-house Dev is telling me I can't do this...

Nevermind. I finally got my google-fu working (needed to look for "orphaned file", not "phantom file"). The solution is here: http://connect.microsoft.com/SQLServer/feedback/details/482820/orphaned-log-file-can-not-delete-log-file-sysfiles1-duplicate-namesnd%20259164%20(Denali)