Thank you for your replies.  For clarification, sometimes patients get entered twice.  After a decision is made as to which patient record should be the final one, the MRN is...

Looks like there is an update out now for this. The change log specifically mentions a fix for the issue when modifying a stored procedure.

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

If you are getting this error, try to modify the proc in a different version of Management Studio.

I have been dealing with this problem all afternoon. I...

I'm doing a data quality project now to look for oddities. So this is useful for me.

I modified the script so it includes schema, table, and column...

Here's another list for healthcare data. This download contains info for healthcare providers. It includes name, business address, certification (MD, RN, LPN, etc.). The primary key is...

I had this error. In my case, I had the wrong selection in the For Each Loop container. Under collection there are three options:

name and extension

fully qualified

name only

I...

Thanks for the replies. It's a minor inconvenience. It would be nice if the package would run without waiting two minutes for it to build.

The project is on...

I have been searching for an answer to this also. I have a package that takes a few seconds to run. It outputs about a dozen rows to...

I tried this, and got an error saying I had to enable xp_cmdshell. So I Googled, and found this code to enable it:

EXEC sp_configure 'show advanced options', 1

GO

-- To...

It looks like a useful script after a little debugging. It's not returning a valid format for date fields. Here is an example that was created using the...

kramaswamy (11/8/2011)

---

Don't set the connection string property. Set the ExcelFilePath property. I find that it causes fewer headaches than trying to build a string for the connectionstring, since unlike the...

I'm glad someone found it useful.

Were you looking for this script because yesterday was a bank holiday, and something went wrong? 😉

Solved it! (Actually, one of my co-workers pointed out the problem). When I imported the SSIS package to my new computer, somehow the use passive box in the...