This tutorial should confirm you're on the right track...and may get you closer to finishing that last 20%.

http://www.sqlshare.com/looping-through-and-loading-files-with-ssis_34.aspx

If you need more assistance go ahead and zip your SSIS package and...

You probably inadvertently hit the Shift+Ctrl+F keyboard shortcut. Happens to me all the time and it drove me crazy until I figured out why that would happen.

Cool. On my system the Linked Server "rpc out" property option had to be True for it to work:

EXEC master.dbo.sp_serveroption

@server=N'linked_server_name',

@optname=N'rpc...

You're welcome 😀

Re: Item 2:

The idea is to move your ROOT tag out a level and add the username element before the rest of the stuff. I don't have your tables so...

Re: item 1

Is that your actual XML? If so I see two issues:

1. You have dashes prefixing some of your lines:

2. You have unescaped quotes in some attributes:

<name first_name=""?""...

Yikes :crazy: MS = Microsoft? Which version of CRM?

giles.clapham (3/25/2011)

---

The simpler suggestion you mention...

What will be consuming your results? Doing this kind of work else outside the DB is also a viable option. Most reporting tools have built-in functionality well-suited for solving running...

My bad...I misread the question. SAVE TRANSACTION will let you save the inner work you've done provided you issue a COMMIT after you issue a ROLLBACK to a named savepoint...but...

Access how? Read or Write? To which event log?

You can write errors to the Application Event Log using RAISERROR:

RAISERROR('Hello World!',16,1) WITH LOG ;

You can read or write to any Event...

Yes, you can use a cursor. This is one of my few universally acceptable uses of a cursor on SQL Server. You could also take a look at the undocumented...

SAVE TRANSACTION will do what you need:

http://msdn.microsoft.com/en-us/library/ms188378.aspx

I just noticed that your proc is not calling itself...I took that for granted initially based on previous posts.

That said...you're welcome for the quick demo on the recursion limit...

Lowell is referring the maximum recursion level, not the max transaction level. Since your proc calls itself you need to be aware of it. Try this out in your test...

I would like to help...can you provide the DDL for both tables attached as a .sql file and maybe some DML to create a few rows. This way I can...