Like Kevin suggested... use ADODB to either execute a stored proc (preferred) or update the table directly (not preferred).

Here's a good Microsoft article to get you going:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdconcommandstoredproc.asp

And unless...

You can also check out this link:

http://geekswithblogs.net/danwoolston/archive/2005/08/31/51784.aspx

This allows you to modify the FTP task without having to install a custom task.

In my experience, if the stored proc is functioning correctly with no errors, then the problem has turned out to be a problem with the SMTP server. Usually ends up...

Another alternative that I am currently using is CDO for Windows (CDOSYS.dll). I found this to be the best solution since CDONTS does not work for Windows Server 2003 (Important...

In order to create the input parameter for an Execute SQL Task in DTS, you will need to update the Task with a Disconnected Edit:

• Through EM (For SQL2K), open the...

Your problem sounds interesting. The number of records in the CSV should have no bearing on the unzip process, unless there is a file size issue. But I can't imagine...

Quick question... do you have local access to the server you are remotely executing the package on? Does the DTS package execute locally on that server?

Since you are instantiating your variable to a recordset object, you will need to use "Set" as you originally posted.

As for why you are unable to access the ADO COM,...

What is the data type for your GV?

I assume you are using an ActiveX Task to parse the recordset (since to reference the RecordSet object). Try using "RecordCount" property of the recordset.

See the following Microsoft article for...

What tasks do you have in your package?

You may want to check out this article:

http://www.sqldts.com/default.aspx?298

You will need to use ActiveX scripting to get through the rowset global variable.

Wow. I can't believe I took so long to realize my error. I am now able to send an email with HIGH priority through our SMTP server. Here's the scoop:

First,...

I have also been unable to find an answer to this question. Can anyone answer this?

OK... I think I follow now. So you want to be able to check their laptop (upon connecting to the server) to see if they have attempted to log in...