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.

Jeff Moden (9/20/2012)

---

I guess there's a whole lot of people that just don't know how to do it right. I agree......

Unfortunately BULK INSERT does not play nice sometimes so we have to apply a workaround. We cannot CATCH errors from BULK INSERT related to gaining exclusive access to the file...