moving-parts

Why let the package that checks for the record exit? Just let it run. This way you would only need on SSIS package.

There are lots of options but here are...

Jeff Moden (9/20/2012)

---

Ok, so how will having xp_CmdShell turned off prevent that internal threat? Answer is, it doesn't because anyone with SA privs can use xp_CmdShell even if it...

You could do this in a Script Component in a Data Flow setup as a Destination. Keep a counter in your code and issue a new CREATE TABLE at 0...

Once didn't work, so twice is better?

http://www.sqlservercentral.com/Forums/Topic1361171-364-1.aspx

akirajt (9/19/2012)

---

Goal:

Filtrate the different integration issues. My selection is:

Description - Customer Name - IBM

Encoding - Sex - M = Male and F=...

Variables in SSIS are case-sensitive, i.e. \Package.Variables[User::ReportID].Properties.Value is not the same as \package.variables[User::ReportId].Properties.Value, so first verify you're referencing the correct name.

Jeff Moden (9/20/2012)

---

opc.three (9/20/2012)

---

Can't wait. I'll definitely read it, hell I'll even volunteer to tech review it if you like. I'll do my best to provide feedback to head-off as...

Most of my 2005 servers are on 9.0.5057 (SP4 + MS11-049) except for a few that we cannot upgrade because a vendor app won't certify their software for SP4, sigh.

http://sqlserverbuilds.blogspot.com[/url%5D

Can't wait. I'll definitely read it, hell I'll even volunteer to tech review it if you like. I'll do my best to provide feedback to head-off as many detractor angles...

dwain.c (9/20/2012)

---

Eugene Elutin (9/20/2012)

---

There is nothing wrong...

In the Services manager you can have the OS run a program for you in case a service fails. This can be a PowerShell script that sends an email or...

Same file location?

This should probably be moved to the SQL 2012 - General Forum. You may get more page views that way. Some very qualified folks have stopped watching the 2005 Forums...

Cmdlet Out-File has a -Encoding option.