Some questions about your requirements...

- Are you needing to completely replace the local sales data (i.e. delete all local rows then populate all rows from hosted database) or do historical...

Here is a PowerShell example:

#env settings

$srv = "orlando-surface\sql2012"

$db = "tempdb"

$dir = "C:\@\"

#########################################################################

#nothing below here changes

#build connection string

$connStr = "Server=$srv;Database=$db;Trusted_Connection=True;"

#connect to the database

$conn = New-Object System.Data.SqlClient.SqlConnection($connStr)

$conn.Open()

#get list of files from directory

foreach($file...

kevaburg (3/16/2015)

---

Grant Fritchey (3/16/2015)

---

I'd probably reverse build on this. If you need to manipulate files and do t-sql, I'd write it in PowerShell and call the T-SQL from there rather...

bobjbain 6094 (3/16/2015)

---

Sorry to come to this thread late but it might help someone else in the future.

You can tie a spid back to a host process and host name...

Kelvin Lush (3/19/2015)

---

Does anyone have any idea how to do this when the remote query contains an unknown (i.e. a variable) for the "to_date" instead of "07/11/2011" (which I presume...

Sangeeth878787 (3/17/2015)

---

Hi Orlando,

If I need to give access more than 300 users only on two views, these views going to be used in SSRS and Tabular Model. So I need...

Exploring the orphanage:

Loginless In Seattle[/url]

Rich Parsons (2/18/2015)

---

Thanks for the great article. I'm using SQL Server 2012 and all work well, until I add a Send Mail task at the end. The object...

About a year after this thread I wrote an article on the topic. It targeted 2005 and 2008 but the technique works on 2012 as well. If you read the...

I know this is a very old thread but I am being confronted with a similar proposal, albeit nowhere near the volumes initially, where QNs and Service Broker would be...

Check out the SQL Server Database Project offered within SQL Server Data Tools. The Database Project supports managing the properties of a database (e.g. things like the recovery mode and...

Check out the Windows 1252 map, number 253.

http://en.m.wikipedia.org/wiki/Windows-1252

If you can represent a character with a single byte (253<255, max number storable in a byte) then you do not need Unicode...

Just for the record, CHAR(253) is not Unicode.

mitesh.temre (12/17/2014)

---

lvbntapasvi (9/6/2014)

---

Hello All,

I am new to SSIS, and have started using it from the past 3 weeks. I have a task where in I am supposed to access the...

That should do it. I roll a job to all my instances that does just that, as a matter of standard operating procedure. Sometimes I will need to add steps...