I worked in technology for four years and find it completely ridiculous that a company would try to do this to their employees. Supporting over 1000 pc/laptops/servers; you'll be...

No, if you are looking for not in insert table. Left join where null shows all data in main table and not in join table.

shahab (1/22/2009)

---

I having following insert statement and its taking FOREVER to run.. probably because the sql is looking up the table its writing to..

insert into T_D

...

I don't agree with this; "Efficient in their eyes, not yours"

This is probably one of the hardest things to do but; both you and the customer must think it's efficient....

What kind of authentication are you using to connect to the file? Sounds like user running job does not have access to file.

I would compare the not exists query with a left join query. Exists should be used to start a process not compare data; imo.

You can't have duplicate PKs. I think you want something like this.

INSERT INTO [SAP_PERF_HIST].[dbo].[DB_PARAM_HIST]

...

I would import into a staging table. Your SP will reference the staging table and final distination table. This will also help if the package fails; although the...

I would say welcome to SSIS. Read up and use a data...

Place tsql in a stored procedure; makes it easy for updating. Would also use a left join over and if exists approach.

select id from toTable t

left join...

Like mentioned above it's how you read "Databases with simple recovery model will be exluded". This is just excluding the DBs from the selection list. The problem I...

I'm using the all users database option. So I can see why the database would be backed up. But microsoft makes it look like they will be excluded...