Hi Ed,

When i open the Run dialog and, type services.msc and click OK, it takes me to the SQL Server Configuration Manager , where it has the same..start,stop,pause,resume.... ...

"That's one way, the other is Services > Unwanted > Disable"

That's what I want to do, when I go to   SQL Server Configuration Manager > SQL Server Services...

Thanks Eirikur

How do I permanently disable the unwanted...

Thanks..hmm when i go to add/remove programs i see microsoft sql server ....along with rest of programs on pc, don't see anywhere to uninstall an instance of server for db...

how to uninstall the unwanted one?

Thanks.. Exclude folders didn't work either. Now that I have SSMS up and running again will now reinstall antivirus program.

i uninstalled an antivirus program and it then worked.

ok success, apparently the window was so small i couldn't see the other file names, i removed those, resaved with *.bak, and it worked

Thanks guys. Appreciate you're help!

Ok when i give the filename a extension like, myfilename.bak, i get the error message below:

System.Data.SqlClient.SqlError: The media loaded on "C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\MyFilename.bak" is formatted to support...

Thank You Michael & all.  

So I tried the Not In, but it returned null values, this is because the original data had hardcoded 'null'.  so the workaround...

Thanks guys. Both of you're queries was very helpful as well as the explanation...really appreciate it!

You're right Jeff modifying the registry is the best solution since you don't have data integrity issue then.

On a side note, I'm still not understanding why even if column in...

Jacob Wilkins (1/23/2016)

---

Ah, you're using an Excel source, not a flat file source.

That's a documented "feature" of using an Excel source (under "Usage Considerations", see "Truncated Text" and "Data Types"...

Thanks Jacob, J Livingston, & Ed - I am using nvarchar(max) all the time for the column the error report mentions. - still errors during import..

@JLivingston - The sample workbook...