Please share any hint/ideas to approach this xml

Hi arthurolcot,

Giving a sample xml and the table structure. Need to insert into the respective tables below. Please suggest

DECLARE @xml xml

= '<Master>

<MasterNo>abc</MasterNo>

...

Thanks arthurolcot!.

There is a small change in the table structure in which the data needs to get inserted.

CREATE TABLE ID(

NO_PK INT IDENTITY(1,1) PRIMARY KEY,

Id INT

)

CREATE...

Hi,

I have changed to (@LoopRecordCountPrimary>0) || (@LoopRecordCountSecondary>0), but in this case ForLoop is always showing success. It is not entering into the ExecuteSql Task. Is, the approach correct to pull...

Sorry forgot to mention the source. It is oracle database. I think File watcher will not work for oracle.

Jim

Hi John,

The package execution should be stopped automatically. Looking for a solution which could be implemented inside the package or the package is schedule in SQLServer agent by the DBA....

Hi,

The problem is fixed. I have used @RowCount==(DT_STR,50,1252)"0" in the EvalExpression in Forloop and it is working.

I have a request. Is it possible to kill the SSIS package at runtime....

I tried select Cast(count(*) as int) from crc.crc_ds1_td. It works in oracle by ExecuteSql task is throwing the same error 🙁

Thanks John,

I'm facing a issue. The package is throwing an error

[Execute SQL Task] Error: An error occurred while assigning a value to variable "Rowcount": "The type of the value...

Hi Samita,

I'm facing the similar issue. I have a user variable @Rowcount of type Int32. In ExecuteSQL task my query is Select count(*) from table1 which is pointing to oracle...

Hi,

Thanks. Could you please let me know little bit more about the polling in SSIS? Considering Oracle, webservice and Dataservcie, which task should be used to do the polling.

The...

Hi,

As promised, I'm updating the post after implementing :). I have handled the requirement at the Precedent contrainst level. I created a variable to store the count of rows and...

Thanks a lot. I will update after implementing the same. Thanks again.

Also, need to log only those rows which are getting truncated.

For e.g. if the source table is having...

We are checking based on count(*) >0 i.e. if table1 has atleast 1 row, pull that data. If table1 has no rows then pull data from table2. If table2 also...