Rewrite the whole script, it will be less trouble moving forward.

There are far too many differences for it be worth fixing in 99% of the cases.

CEWII

How about you go to the Notifications tab in the Job, check the box next to email, chose the operator and then select When the job completes.

Easy.

CEWII

Easiest way would be to build an SSIS package that walks through a list of servers using a for-each loop and using expressions replaces the server name in the connection.

I...

Unfortunately I agree with everything. Re-write is your only option. You might be able to cut and paste some raw code between but not objects.

CEWII

Then some group that the user is a part of has like been DENY'd access to the table. Look for any DENY permissions on it.

DENY permissions override all GRANTs.

CEWII

anil702 (7/15/2010)

---

when we run ssis package on local server time span is 50 min

and the same package if he run on production time span is more than 2 hours

package is...

I don't think so, the Integration Services service is little more than a method of accessing the list of known packages and a method to execute them. In the...

Vernon Jimmerson-306463 (7/14/2010)

---

SSIS is a maintenance nightmare! Avoid SSIS like the plague. It's for people who shouldn't be coding at all! About the only exception I can think of is...

anand_vanam (7/10/2010)

---

1. I am running the SSIS package using SQL agent job. (but I want to run many jobs at the same time which calls the same SSIS package, but...

I'm with Phil, thats all you need, and it is EASY to setup.

CEWII

Once you have some connectivity to notes then you can use the ODBC connection in SSIS, but you need to get that in place first.

You might look and see what...

You might just use the Import/Export wizard and save the package for a single table..

DTS 2000 experience is good, but it only helps a little in SSIS which does almost...

You need to be sure what user the SQL agent is using, you can us the control panel Services application to figure that out. Then you need to check...

There should be a max error count propert on the container, you can turn that up and it should continue.

CEWII

You basically have to rewrite it. Scripts are one of the things that the upgrade wizard doesn't really do anything with.

Sorry.

Also, did you get an...