Are you asking about a scenario when moving data between two tables on different instances?

I'll assume yes.

BULK INSERT will not do this but OPENROWSET or OPENQUERY using a Linked Server...

My first thought was to use the SSIS object model in C# to execute the package and then attach to events that would allow you to end a process early...

What is the value of the package property "ProtectionLevel"? You can find this by right clicking some open area on the Control Flow design area and choosing properties.

Chances are you're trying to read a Unicode file as ANSI or the end of line character in your file connection in SSIS (e.g. {CR}{LF} ) is different from the...

Kevin Dahl (2/22/2011)

---

I have actually tried doing the pivot and building the IN clause dynamically (using this approach http://www.simple-talk.com/community/blogs/andras/archive/2007/09/14/37265.aspx), but it turns out that the column names actually end up...

Lutz has a point...dynamically generating a crosstab query would require approximately the same level of effort from you and would almost certainly perform better than a PIVOT. My code example...

As with most things...it depends. Performance absolutely CAN be affected by sharing a SAN across multiple SQL instances. There are many different types of SANs...some allow you to isolate your...

Building a PIVOT query dynamically is a viable option. Using your DDL I created a simple PIVOT query:

SELECT pvt.RecordID,

pvt.Variable1,

...

Nope...the [Server Name] column appears to be appended by the IDE, not on the server-side.

You said are going to put all the proc executions into SQL Server Agent Jobs so I would recommend looking into the logging functionality available within SQL Server Agent. Within...

There are ways to "tune" Linked Server queries by deciding between accessing remote data using either 4-part naming or OPENROWSET OPENQUERY. As Craig mentioned depending on how your query is...

If SQL 2005 or above you should look at using EXECUTE AS. You can create a stored proc that can create logins as needed as if a sysadmin was doing...

What does your requirement say if the day passed is between the third Saturday of the month and the last day of the month?

Ooops, misread your comment "current day passed...

See the section on Permissions in the BOL article for BULK INSERT:

http://msdn.microsoft.com/en-us/library/ms188365.aspx

Disclaimer: this is a workaround for a limitation in SSIS

When you output XML to an OLE DB Source component it shows as a byte array which is difficult (maybe impossible,...