I only meant to show the two characters that would be escaped when casting to the XML data type.

Thanks for the code samples Solomon. I ran a few tests and...

It sounds to me like the server is too busy to service the request from the SSIS Package at various times of the day, likely during peak usage or during...

Sad that after talking with a recommended reseller and Microsoft directly that you landed on a public forum asking for advice. I hope someone from Microsoft sees this thread. Unfortunately...

As with most solutions to a given...

How do you know it "succeeded" if you're not capturing the return code from xp_cmdshell? xp_cmdshell won't throw an error just because dtexec returned a 1. Try capturing the return...

SQL Server is an Enterprise class data platform and focus is heavily placed on data-tier operations therefore it has no front-end development tooling.

Access is sometimes thought of as SQL Server's...

Start here: http://sqlblog.com/blogs/adam_machanic/archive/2011/04/01/a-month-of-monitoring-part-1-of-30-a-brief-history-of-monitoring.aspx

Download sp_WhoIsActive and follow the 30-day series and not only may you never use sp_who2 again but you'll learn a ton about DMOs in the process.

TRY...CATCH is not a function, it's a control-flow construct used for exception handling.

Here is some pseudo code:

BEGIN TRY

-- insert first select result into new temporary table using SELECT...INTO

END TRY

BEGIN CATCH

--...

Hopefully your more recent post asking about calling sqlcmd from PHP means you are not going to be using xp_cmdshell...which is a very wise choice.

Oracle765 (6/27/2013)

---

Hi All

I have a php exec command which runs SQLCMD as follows the sqlcmd command works by itself but when i run it in php it hangs, any ideas

exec('c:\WINDOWS\system32\cmd.exe...

It could be a lot of things. Post your Excel file, attach it to this thread.

An alternative is to export your Excel file as a csv file and import that...

A third option (just learned) is to write to the same file three times but do not overwrite the file when you write the data and footer rows:

http://www.sqlservercentral.com/Forums/FindPost1468463.aspx

You can skip straight to the section abot 1/3rd of the way down titled Setting Up Your XML Configuration File: XML Configuration files in SQL Server Integration Services[/url]

For your situation,...

If the goal is only to see the data in the variable for purposes of debugging then here is an alternate method which I find works quite well. I prefer...

lisdey (6/27/2013)

---

We need to buy MSQL Server 2008 Standard or 2012 for a very light application.

I have quote:

228-09884 Microsoft SQL Server 2012 Standard - License - $1863.58

server - MOLP: Open...