Brandie Tarvin (3/4/2011)

---

Plagiarism is when you're pretending the work is your own and not giving proper...

Brandie Tarvin (3/4/2011)

---

Koen Verbeeck (3/3/2011)

---

So when you copy paste a task with a connection manager, it will not recognize the connection manager anymore, even if you have the exact same...

Tom Carnahan (3/4/2011)

---

Koen Verbeeck (3/4/2011)

---

Instead of fumbling with the deployment wizard and manifesto, you can install BIDS Helper (it is free). It allows you to deploy packages and projects with...

Is one topic to post your faulty explanation and shameless advertising for your blog/site not enough?

http://www.sqlservercentral.com/Forums/Topic1073089-391-1.aspx

You could create a .bat script on ServerB that contains a DTEXEC command with parameters.

On ServerA, you execute the .bat script on serverB, passing along the name of the package...

Do you have precedence constraints in your package?

wagner crivelini (3/4/2011)

---

Men, I didn't know how common those "reprints" were!!

I checked Google and found 3 of my articles shown in some "serious" blogs out there. And 1 one...

Instead of fumbling with the deployment wizard and manifesto, you can install BIDS Helper (it is free). It allows you to deploy packages and projects with a simple right-click.

Much easier!

You can use a for each loop to loop over the table and store the tablename in a variable.

Then you can construct a dynamic SQL statement in an Execute SQL...

There will be a performance gain if you disable them. However, the check constraints will be marked as non-trusted when you enable them. So it might be a better idea...

Great, glad to help.

It would surprise me if you can add BIDS 2005 into Visual Studio 2008.

Packages developed in 2008 are not compatible with 2005.

rocky_498 (3/3/2011)

---

Thanks for your prompt reply, I know my 95% data is good and 5% is bad, and i am sure i can use expressions to get what i want...

I would run a SQL Server Agent job every 15 minutes. This job will execute a stored procedure.

The stored procedure runs the openquery and checks the result. If it is...

There are practice questions in the self-paced training kit book, which costs...