Quote from this MSDN page: Package Configurations.

1. The dtexec utility loads the package.

2. The utility applies the configurations that were specified in the package at design time and in the...

Brandie Tarvin (8/6/2013)

---

jasona.work (8/6/2013)

---

On a completely unrelated note, I was perusing the "suggested contacts" on LinkedIn last night, and saw a familiar name pop up:

Brandie Tarvin...

...

Gotta wonder just where LI...

I'll continue in English for people who accidentilly stumble upon this thread.

You entered the expression in the text field itself, so it is just text, not an expression.

Right click on...

Why would you think option B is not correct?

The only tasks not supported by checkpoints are for loops and for each loops.

The first thing that comes to mind is the query

(SELECT GS.CodeDescription

FROM dbo.vwSGReferrals As REF2

LEFT OUTER JOIN SchemaSG.GenServiceTeam AS GST ON GST.CodeDescription=REF2.ServiceTeam

LEFT OUTER JOIN SchemaSG.AmsSpecialtyTeams AS AST ON GST.Code=AST.Team

LEFT OUTER...

It does store the password in the connection manager.

However, if you open up the editor for the connection manager, it will not show you the password (that would be insecure).

But,...

The difference between the two rows in group 2 is 39 seconds.

You'll need to establish clear rules on how to divide the groups.

Around 20 seconds doesn't work for a computer,...

Images in SSRS:

Images (Report Builder and SSRS)

Some tutorials:

Reporting Services Tutorials (SSRS)

Reporing Services is supported to some extent in SQL Server 2005 Express with Advanced Services:

Features Supported by the Editions of...

Sure. You can schedule SSRS reports. And if a user needs the Excel report, he can always run the report itself.

Does this work?

DECLARE @Databasename NVARCHAR(50);

DECLARE @Subdir NVARCHAR(150);

SELECT @Databasename = (SELECT DB_NAME());

--SELECT @Databasename;

SELECT @Subdir = N'C:\Test\' + @Databasename;

--SELECT @Subdir;

EXECUTE master.dbo.xp_create_subdir @Subdir;

I would create a report in SSRS and then export the report to Excel.

So you want to use this formula as a SSRS formula?

In that case, it would be something like this:

iif(Fields!event_type == "c","R" + Format(Fields!event_type,"####0"),iif(Fields!event_type == "i",Format(Fields!event_type,"####0"),"P" + Format(Fields!event_type,"####0"))

Not 100% sure about...

This is not SQL, it is some sort of Visual Basic.

rahulsahay123 (8/6/2013)

---

so you mean to say that I should store the package path in a sqlserver table. then I should use foreach container and declare a variable say v_package of...

Try this:

SELECT

c1.Table_name

,STUFF(

(

SELECT ',' + c2.COLUMN_NAME

FROM INFORMATION_SCHEMA.COLUMNS c2

WHERE c1.TABLE_NAME = c2.TABLE_NAME

FOR XML PATH ( '' ), TYPE

).value('.', 'varchar(max)')

, 1, 1,'' ) AS "Column_names"

FROM INFORMATION_SCHEMA.COLUMNS c1

GROUP BY Table_name;

You made a...