Where are those analysis pages coming from? Is it a feature in SQL activity monitor? If so, please advice the proper steps to do what you show. ...

It is good to know we can do this. Thanks. Can this technqiue use in the reverse? The data source is SQL table and output...

Replaceing (local0 with the server name doesn't work either.

Did u get this resolved? I currently am having the same issue.

w

No, the high selectivity fields (like primary key in a table) are in the joins and low slectivity field such as status is in the where clause.

I agree...

Great series.. They bring back some forgotten concepts. Thanks

I do have a question on the 'Include' feature in nonclustered indexes. You touch on...

Lets say we can't use sp_addremotelogin, how do you do this in SQL 2008 using both SQL command and SQL management tool? I like to see both method.

Yep, double \\ works. The files are saved in the right path with the correct name.

Many thanks.....

od

Your command got the same error....... but guess what..... your new command again showed me something different... For the last argument, you remove the last '\' from the file...

ok, I will try that. Can you tell me what wrong with the following command?

dtexec /F "C:\DTSPackage\MySolution.dtsx" /SET "\Package.Variables[EmployeeID].Value";162 /SET "\Package.Variables[OfficeCode].Value";"10" /SET "\Package.Variables[sFilePath].Value";"N:\exportfile\"

When I ran...

thank for the reply. The thread that you pointed me to actually help me to solve it although it is not pretty. The thread mentioned about opening the...

Thanks for the reply. Actually I did try that before I posted my question, it returned an syntax error. Your command is almost exactly like mine except that...

I need to clarify my 'it is working' statement in my reply. If I directly typed in the custom row delimiter, it would work. But if I define...

The bypass thng doesn't work. You mention about building a variable for the sql statement, do you mean doing somethig like this?

Declare @sqlcmd varchar (max)

select @sqlcmd ='select xxxxxxxx'

exec...

thank for the reply.

Is there some special attention needed for setting up parameter if the Select statement involves an Union. For example,

select LastName, First name from tblemployer...