There is no such thing as "sysadmin rights to only one database" but I think I know what you mean. sysadmin is a Fixed Server Role and being a member...

Table Types are very similar to Table Variable in many ways. Their main use is as a parameter to a Stored Procedure, known as "Table-valued Parameters."

Use Table-Valued Parameters (Database Engine)...

When SSIS is kicked off from a server, like when running an Agent Job via SSMS, the package is actually running on the server not on the user's machine. What...

SQLRNNR (2/5/2013)

---

sqlfriends (2/5/2013)

---

Thanks ALL.

I read a tutorial and recommend this option should be enabled for all instances. Read and still a little confusing about when I should enable or disable...

Please do not cross-post. It just fragments replies and wastes people's time. Direct replies here:

http://www.sqlservercentral.com/Forums/Topic1415972-359-1.aspx

Who do you suppose might interact with a Message Box when it is presented during an unattended execution of an SSIS package :unsure:

Your best bet is not to use message...

FREDERICK (2/5/2013)

---

Hello

Another party set up the Server and Databases.

First the Server was set up

Windows Server 2008 SP1

Then the Databases were set up

SQL Server...

Another option is to have the job that starts the trace add an entry into a control table after the trace is started so you can later use that to...

In that case if you want to do everything in T-SQL then you will need to gain directory access. Some options are xp_cmdshell or a CLR object, there are others....

David is right about the format-file not matching the file's format.

For starters you'll have to change all instances of this in your format file:

to this:

<FIELD...

Borrowed from here and tweaked slightly:

DECLARE @trace_id INT = 1,

@path NVARCHAR(260);

SELECT @path = REVERSE(SUBSTRING(REVERSE([path]), CHARINDEX('\', REVERSE([path])), 260)) + N'log.trc'

FROM sys.traces

-- set this...

To test the A- tokens, in a test environment of course:

- Setup a job that has the PRINT statement from Example A from the article I posted earlier.

PRINT N'Current database...

CREATE TABLE statement for the target table?

OK, good. You posted in an SSIS forum but that's fine, now we know what you need.

I am happy to help but it's a little hard to determine from...

If you could clarify your original post about what you are trying to do...