Is your DNS running AD integrated? If so it should create an A record in DNS for the virtual server name upon installation. If not you can ask them to...

Try something like (assuming the remote path on the FTP server is /)

"/" + DTS.Variables("strEmpFile").Value.ToString

You could use a script task or build an FTP command file with dynamic SQL and use an execute process task. Refer to some of the examples in this post:...

Take a look at the topic "Influencing buffer sizing" in the article mentioned above.

Shouldn't really matter as long as it isn't express edition - it isn't correct?

Couple of questions - what version of management studio are they using (i.e. express, developer, standard, enterprise)? What build of management studio are they running (i.e. SP1, SP2a)?

An alternative approach would be to use an execute SQL task to build an FTP command file using xp_cmdshell - i.e.

DECLARE @FileName varchar(100)

DECLARE @Cmd1 varchar(1000)

DECLARE @Cmd2 varchar(1000)

SET @FileName = 'mget...

You could use a script task in SSIS as a replacement for the generic FTP task which will give you more flexibility. i.e. use mget with a wildcard ("_12-00-*.txt") and...

The limitations of SSIS standard edition exist regardless of wether or not the packages are stored on the file system vs. msdb. Refer to http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Steve beat me to it 🙂

http://www.sqlteam.com/article/what-query-plans-are-in-sql-server-memory

I'm assuming your reffering to an object variable for a recordset? This is a data type set on the variables property page in VS. For more information/tutorials on ForEach Loop...

Use sp_dropserver to remove a linked server.

IF EXISTS (SELECT name FROM sys.servers WHERE (server_id != 0) AND [name] = 'SOMELINKEDSERVER')

BEGIN

PRINT 'sp_dropserver @server=''SOMELINKEDSERVERNAME'''

END

ELSE

BEGIN

PRINT 'DO SOMETHING ELSE'

END

This link might help - scroll down the page approx 1/3 to the section titled "WMI (Windows Management Interface) Management".

http://book.itzero.com/read/microsoft/Prentice.Hall.PTR.Windows.Server.2003.on.HP.ProLiant.Servers.Oct.2004.eBook-DDU_html/0131467581/ch13lev1sec3.html

Use DROP DATABASE in a query window