Hey Craig,

For doing audit trails asynchronousally we need to use service broker right?

regards,

aman

i thought about this option of inserting but my application is not doing it. so instead of inserting 3 lines what if i insert INSERT into RELATION VALUES ( 2,'QA...

Sorry for being a pain so what entry do i need to put to get this resolved?

Here if you see fund1 has fund 2 3 4 within it so you see this QA SPONSOR->QA FUND1 (2)->QA FUND2 (3)->QA FUND3 (4)->QA FUND4 (5)

but now under fund 5...

Thanks for your reply.

Yes Fund 1 is twice as it is under QA sponsor and Fund 5. However Fund 1 has Fund 2 which has fund 3 and 4...

Hello

Below are the DDL script and the data.

CREATE TABLE RELATION (IDINT,

NAMEVARCHAR(20),

PARENT_IDINT,

LEVELINT)

-- Insert scripts for the table

INSERT into...

The structure is as follows/

QA Sponsor

-- Fund 1

...

yes we have option of ssis.

hi, i am using a sql query i.e. select * from tablename

For now I am viewing directly from the data base table.

Hey thanks for the reply.

In order to achieve this requirment we need to change all char,varchar, text to nchar,nvarchar and ntext in all SP,Function, triggers and the table. These changes...

I may be wrong but I have used the below logic

set @PackageString = 'dtexec /f ' + @Package + 'SELECT * FROM ENTITYHD WHERE ENTITYID = '+' /Set \package.variables[ID].Value;' +...

but can we pass the value in the variable dynamically?

Hi I have follwed from the first link provided by you.

The third step is to add this variable to the package configuration so you can easily change the value in...

hey do u have an example for the same how to do it I am new to ssis pls