paul_ramster (10/6/2011)

---

I've created an XML document as per your sample above, and used copy and paste to extend it to 80,000 entries. On my machine, your function parses it...

Thank you.

The xml we have is like below format: Total 60000 records.

SET @EmpIDs='<ROOT>

<r id="5551189" />

<r id="5578554" />

<r id="5587894" />

<r id="5602958" />

<r id="5631882" />

<r id="5643028" ...

I got the error:

Must pass parameter number 6 and subsequent parameters as '@name = value'. After the form '@name = value'...

Do I have to use sp_executesql?

How can I fix my above sql?

Thanks

Thank you, it's very helpful

Thanks!!

so where does the output parameter goes to?

Should I use the select or print in the stored procedure or after the Exec mysproc...

statement

Thanks.

george sibbald (9/26/2011)

---

How much free space have you got on the drive that you can afford to be used by the log file?

Whats the size and space used in the...

george sibbald (9/26/2011)

---

there are a number of options, you may have to experiment to see what works best for you.

Just increase the log file to a size that can handle...

Thank you, that works, I got the return number 1.

Now further step of my project, I would like to use a bat file to call this stored procedure and if...

Now the database is already there. He just wants to deploy cube, and he got that message.

I did the exactly the same, I created a processor role and check the process database and read definition. and add this developer account as a member.

But when a developer...

Thanks, that's helpful

Thanks, the reason I do this is because:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/6cd5792a-7fef-4980-b555-95c02acaff96