Have you tried surrounding the parameter values with double-quotes?

Dave23 (5/4/2011)

---

I needed similar functionality, to remove files older than 14 days old. I wound up using the following, based on the DOS ForFiles command:

Forfiles -p E:\backups\test /m *.bak...

I finally got to a place where I felt comfortable enough to publish the project...but it's still in Beta 😀

If you have the time and inclination to review the site...

Here is a very similar conversation happening on the topic right now:

http://www.sqlservercentral.com/Forums/Topic1100808-149-1.aspx

There is a code sample for a Script Task being worked through at the moment that may be a...

Please don't double post.

Direct replies here:

http://www.sqlservercentral.com/Forums/Topic1100732-147-1.aspx

QQ-485619 (4/29/2011)

---

I have a folder in d drive called Archive (d:\archive) which stores all data load files. The name of these files various, and I need to create...

I think you're running into issues because of the double-quotes. If you escape those by doubling them up I think you'll have better results...like this:

select 1,'""wet season is here','=38489'

union all

select...

BCP is a good option. Note that xp_CmdShell is disabled by default in new SQL Server installations due to it increasing the attackable surface area of an instance when enabled....

You're welcome 🙂

See if something along these lines works for you:

DECLARE @doc NVARCHAR(MAX)

SET @doc = N'

<UNODocument

docID="DispHNRP"

xmlns="http://www.theUNO.com/schema"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://www.theUNO.com/schema http://reports.theCASO.com/docrefs/schema/DispHNRP_r1.xsd">

<UNODocHeader>

<DocTitle>Commodity Price (HNRP) Report</DocTitle>

...

Ukon (4/28/2011)

---

Hello, I agree. I will evaluate my needs. Unfortunately I inherited this "thing" and am finally getting to review the non existent security on it and replace it with...

You can right-click the grid and choose Pane > SQL and edit the query manually as needed. There is also a button to open the SQL Pane on the "Query...

jared-709193 (4/28/2011)

---

The problem right now with using BCP right now is that the Perl script validates data by what errors occur during insertion. These defunct rows are written to...

Perl has its place...but not for the use-case you described...unless it's calling bcp or dtexec 🙂

Can you use Perl to strip off the header and footer and then use BULK...

IMHO using OPENQUERY to join the resultsets of two procs is a hack. I have not looked into it, nor do I intend to, but I would venture a guess...