Compare to each other, on one server compare to one on another server... Maybe something there. Look at the example at the bottom of this article:

http://social.technet.microsoft.com/Forums/sqlserver/en-US/7e6e7320-1122-41b4-af47-5059936814c4/default-path-for-save-a-query

.ssmssqlproj files can...

Then compare <projectname>.ssmssqlproj files. You can open them in Notepad. Each file is located where you created your project, you can check that in the project properties. Also check SSMSEmptySqlProject.ssmssqlproj...

Hi,

You can still follow the link, istall wget and test it interactively, without SSIS to download a file from the web. Then you can use a simple batch file .bat...

You are typically connected in a new project with the connection selected in server connection. You say, you connect to the server. Is this connection still selected in Object Explorer...

Hi,

That may be a security breach unless you are a domain administrator.

First, by mail services, do you mean, "Database Mail"

If you do, what do you want to do: find out...

Shamshad,

I am leaving it to you how to run an executable in SSIS package. What you need to run is WGET for Windows. I used that in the past, works...

I found the articles:

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

WorksheetFunction Object (Excel)

The example they give is to use

Application.WorksheetFunction.Min(myRange)

to use say, Min function. You can try your function.

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

WorksheetFunction Members (Excel)

Hi Jon,

You have 2 ways of calculating the value.

1. You can use sp_OACreate to create an instance of Excel in SQL Server and refer to Excel function.

Please review an article...

Exactly. Yes, the above link illustrates my second approach in good details.

The thing is, this alias is created on one computer and needs to be scripted and rolled out to...

Hi,

You can do it in a number of ways.

- Create a help desk ticket towards your Network team and ask "please create a DNS alias named SQL2012 for a server...

You can also browse Microsoft script center for the VB script, PowerShell etc scripts.

http://gallery.technet.microsoft.com/scriptcenter

Click on Storage in the left column and then Files

One word of caution: if you...

Well, you were asking How... You did not ask Why this is better.... 🙂

The result could be written to a variable per the link in my previous post. Then you can output the variable to a text file with the streamwriter using dts.variables...

Hi,

I can for example use Execute SQL task that queries a Stored Procedure or function that returns @@Rowcount and assign the result to a package variable as decribed in

Hi,

You can use package variables.

Use @@Rowcount to get the number of rows returned by the query

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

Assign this @@Rowcount value to a package variable

Generate the file name with GetDate()...