You need to choose fields in Sort task that act as a key - you said that you have row 001 potentially multiple times. This has to be the sorting...

Not sure what you want to say - is it working or not? if you join your tables on all three fields and use outer join AND you will check...

Hi Sandy,

Outer joins will give you what you need probably:

create table table1(a int, b int, c int)

create table table2(a int, b int, c int)

go

insert table1(a, b, c)

values (1, 1, 1)

insert...

I noticed the indefinite yellow state when destination table was locked. maybe you could run table operations in sequence?

Do you use fast load destination for inserts?

Piotr

Maybe you should remove duplicates from the source using Sort task?

Piotr

What do these jobs do? Maybe they are locking themselves mutually?

Piotr

It depends on the severity of the error I suppose, but for errors like key violations or check constraint violations, or data errors, constraints are restored during rollback.

create table testtable(a...

How do you check if a table is partitioned?

Try this query:

select schema_name(c.schema_id) [schema name],

object_name(a.object_id)

,

a.name [index name], a.type_desc [index type]

from (sys.indexes a inner join sys.tables c

on...

Look at output parameters. You can pass the variable as an output parameter to your dynamic sql and assign it there

Regards

Piotr

You have to wrap Default in select part of the query in [] brackets as it is reserved word

Piotr

Hi Sandy,

If you enable identity_insert on a table, you can insert the values from the other databases. Since they maintain referential integrity there, they will on SQL side as well....

So, if you have empty tables on SQL side, there is no problem.

You have to

drop FK constraint on Users_Groups

set identity_insert Users on

--populate your data from the other db

set identity_insert...

Can't think about something other than cursor, but instead of executing the code within the cursor, you could use it to generate code into text output. Then you copy the...

What does this query return? does it contain the user you have created in the database you wanted?

select DB_NAME(), name from sys.sysusers

Piotr

Did you run CREATE USER ... FOR LOGIN command and then GRANT CONNECT ?

Alternatively, you can add new user using GUI, it won't be shown by in list of users...