Brandie Tarvin (6/7/2012)

---

opc.three (6/7/2012)

---

If you want to do complex file management can you not do it all in PowerShell? Why involve SSIS in that task at all? SSIS for ETL,...

jitendra.padhiyar (6/7/2012)

---

opc.three (6/6/2012)

---

It provides a way for the the replication engine to identify a row unambiguously. Unlike unique keys, primary keys do not allow NULLs. Why do you have tables...

Brandie Tarvin (6/7/2012)

---

I would like to be able to use Powershell from within SSIS to do things like file management (without having to have xp_cmdshell enabled). The sort of things...

roy.tollison (5/3/2012)

---

my original post explained it

in mssql 2008 or lower that command worked without having to setup sysmessages for it. in 2012 it no longer works. i originally had written...

In PowerShell you can invoke cmd.exe directly with a /c and you can use Test-Path to check for the existence of a file.

Koen Verbeeck (6/7/2012)

---

I don't think you can create a...

Suresh B. (6/6/2012)

---

jitendra.padhiyar (6/6/2012)

---

Hello Guys,

I setup transactional replication and come to konw that the table with primary key is only accepted for Transactional replication.

I dont konw why.. Can anyone...

Jeff Moden (6/6/2012)

---

As always, you're a gentleman and a scholar, Orlando. Thanks for talking about this. There will always be some disagreement between thee and me on these...

gravitysucks (6/6/2012)

---

I have...

inHouseDBA (6/6/2012)

---

Thank you,

I guess my stopping point is the following:

When you rebuild the index - you rebuild it with 100% sample size, but when you run sp_updatestats a default...

Jeff Moden (6/6/2012)

---

Funny... you left out an important part of that. The sentence immediately before what you referenced says...

A custom in-process OLE server that is created by using Microsoft...

The marketing material says you can, but I have not tried it so could not say how accurate the claims are.

Is SSIS an option? It is built to make tasks like this relatively simple.

This thread runs down the issue for someone else in your situation fairly well.

Creating Header AND...

opc.three (6/6/2012)

---

What do you use to check the results of the call to wmic you posted, and to send...

What do you use to check the results of the call to wmic you posted, and to send an...