Although your code works fine, it wouldn't be my first choice as if the OP could change the schema, normalizing the data...

Looking at the expected results prompts few questions:

😎

1. Is this dataset for...

Just a quick thought on the problem, why not use the ROWLOCK hint?

To try it out, run the create script first and then the Update and the Select code...

Unfortunately I do not have BIDS 2K8 at hand so I'm going by my gay cell...

No option to do dynamic file config from within the package then, either dynamically modified/created package or database configuration are your best bets. If you...

Quick thought, what are the security properties of the package? Have you tried initiating the download from the application server using the package runtime credentials?

😎

Using a trigger is probably the most straight forward approach, if you add a table holding the primary key value and a date, then you can use the output clause...

windows_mss (8/1/2014)

---

Hi,

I have done with the SSIS Package and it's working as expected in my local machine, I have one problem is that how I can give my XML configuration...

As Lynn said, give us something to work with! My guess is that Grant is dead on, just in case, check free space on all relative volumes, auto growth limits/settings,...

This adds an incremental number to the output, by stating (SELECT NULL), one indicates that...

The code below demonstrates how to use output parameters in a stored procedure

😎

CREATE PROCEDURE dbo.WasInsertSuccessfulQuestionMark

(

@ValueToInsert INT

,@ThisTellsMeIfSuccessful INT OUTPUT

)

AS

/*

usage

...

Quick question, do you need assistance providing the necessary information.

😎

ScottPletcher (8/1/2014)

---

If the table may or may not exist, you'll have to make references to that table only in dynamic SQL. Otherwise, if the code runs and the table...

Just throwing in my 2 cents, my preferred way is to use SSIS to import the XML into a staging table and shred it with XQuery into the destination tables....

Out of curiosity, why 11g, that's quite an old horse? BTW, don't know of any automatic tools for the job, normally is scripting rebuilding, rewriting and transferring kind of a...