Try thinking of it this way:

An Excel Workbook is a database and a Worksheet is a table. An .xls/.xlsx file is not the same as a flat file and SSIS...

It sounds like the process you have thought up will work...are you not happy with some aspect of it?

Need more info. Please post DDL for tables, DML for test data, queries you have tried so far and expected results.

Reference: http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

Gary Noter (6/1/2011)

---

Howdy all,

I have a Windows environment wherein there is no domain.

We're all in the same 'Workgroup'.

Server A has IIS and uses SQL Login (username/password) to connect to Server...

You'll be better off writing your own SELECT statements against the DMVs to get only the information you really want. Here is a good place to start:

USE master

GO

EXEC sys.sp_helptext

...

Just a thought...if your main pkg is too noisy to kick off straight away then you could create a parent pkg to contain a File Watcher and an Execute Package...

I agree with Laerte, PowerShell's Get-Service will give you more control and IMHO is the right tool for the job.

http://technet.microsoft.com/en-us/library/dd347591.aspx

However, if you must do this through T-SQL, you can use...

I was originally thinking you were asking about TDE, but now I suspect you're asking about column-level encryption, correct?

If so then Gail is spot-on (as usual).

PS If you are using...

IMHO it seems odd to call into a database to check if a file exists when you're in a .NET environment (SSIS) that is much better suited for doing file...

27M is not a lot IMO, not enough to create pressure in and of itself. What else is running on your server besides SQL Server? Do you use a lot...

Something like this inside your trigger should work:

IF ( APP_NAME() LIKE 'Microsoft SQL Server Management Studio%' )

BEGIN

--...

And did you catch the CLR processes in the act? SQL Server dynamically allocates and deallocates that memory as needed so it can fluctuate wildly. It may be a good...

You would have something to say about that...does xp_cmdshell know about your love affair with sp_makewebtask? I bet she'd be jealous 😛

mister.magoo (6/1/2011)

---

CREATE TRIGGER SampleTrigger ON SampleTranTest AFTER INSERT

AS

SET NOCOUNT ON;

DECLARE @opentran INT;

SELECT @opentran = @@TRANCOUNT;

IF 1=1 -- some real error condition

BEGIN

-- an error is to be raised...

In my opinion you're asking for trouble using rollback in a trigger for this very reason. If you want to go there then you'll have to use SAVE TRANSACTION which...