glad I could help 🙂

Do you need to sort? you are loading data into the a table - it should not need sorting - sorting would be done when retrieving data from that target...

Just as an FYI, the DTEXEC command line can run SSIS Package that are stored in SQL Server.

The syntax is along the lines of:

DTEXEC /SQL .....

Just to check/confirm - the step in the job that is (should be) running the package - is the TYPE a SSIS Package, or are you using the CommandLine and...

Can you use this in the lookup to change the value you lookup against:

select dateadd(dd,datediff(dd,0,getdate()),0)

obviously, you'll need to change the getdate() to your datetime column

As I expected. He is using an ActiveX script to generate a CMD file. The ActiveX is pulling in the variables defined in the Package to get userid, password, IP...

I'll try and get a peak at my colleagues code. The good news is he is doing exactly what you are doing:

He FTP's a file from a remote locations, and...

sorry - can't give any more advice. Good luck.

Hmm - you've deployed final package to FileSystem, but want to use ServerStorage for excryption? I don't think you can do that. ServerStorage is, I think, SQL - hence you...

Unfortunately, you need to have the original user open it, and change the protectionlevel. That default protection level is causing all kinds of problems, from what I've read and experienced,...

Let us know which way you go, and why, if possible. That way I can learn a bit as well 🙂

have fun and good luck

Well, it appears to me that you have this problem, regardless of SSIS, because the SP needs to address DB's on 2 different server's.

Have a look at setting up 2...

*grin*...

although, perhaps it should really be *groan*

It has been a "challenging opportunity, providing excessive personal growth and an impressive learning curve" in "management-speak" (or a "bleedin' nightmare" in normal speak...

a couple of ideas for the stored procedure:

1: Create an agent job that runs the task. Then have an SP that invokes sp_start_job to run the job

2: (ugly!) use xp_cmdshell...