I am trying to finish a project that requires SQL Server 2008 SSIS package to 
send files to another server.   The server is not in our domain and we need 
to make this happen with SSIS FTP.  The job runs great in test as I am signed 
into the server running it manually.   Running the job from the Agent bombs - 
it's sending the Logon ID OK but the password is not coming so the job fails. 
  I am new to SSIS FTP and I know this must be a variable and passing along 
the code in a file.   I simply don't know how to make it happen code wise and 
were to put the variables in the SSIS FTP Connection package.   Please help.  

    
-- 
NC Beach Bum

On Mon, 16 Aug 2010 15:16:03 -0700, NC Beach Bum
<NCBeachBum@discussions.microsoft.com> wrote:

>I am trying to finish a project that requires SQL Server 2008 SSIS package to 
>send files to another server.   The server is not in our domain and we need 
>to make this happen with SSIS FTP.  The job runs great in test as I am signed 
>into the server running it manually.   Running the job from the Agent bombs - 
>it's sending the Logon ID OK but the password is not coming so the job fails. 
>  I am new to SSIS FTP and I know this must be a variable and passing along 
>the code in a file.   I simply don't know how to make it happen code wise and 
>were to put the variables in the SSIS FTP Connection package.   Please help.  
>
>    
Hi

If you have configured the password as a task property then it may be
dropped when the package is exported/imported. You could use a
configuration file to define the values or if the property is set to
take it's value from a packaged variable you can set the variable when
the package is executed.

Look at http://msdn.microsoft.com/en-us/library/ms141105.aspx and
http://msdn.microsoft.com/en-us/library/ms140216.aspx

John

John - This is music to my ears!  Thank you for your quick reply and the 
affirmation that I have not lost my mind.    Thank You!
-- 
NC Beach Bum


"John Bell" wrote:

> On Mon, 16 Aug 2010 15:16:03 -0700, NC Beach Bum
> <NCBeachBum@discussions.microsoft.com> wrote:
> 
> >I am trying to finish a project that requires SQL Server 2008 SSIS package to 
> >send files to another server.   The server is not in our domain and we need 
> >to make this happen with SSIS FTP.  The job runs great in test as I am signed 
> >into the server running it manually.   Running the job from the Agent bombs - 
> >it's sending the Logon ID OK but the password is not coming so the job fails. 
> >  I am new to SSIS FTP and I know this must be a variable and passing along 
> >the code in a file.   I simply don't know how to make it happen code wise and 
> >were to put the variables in the SSIS FTP Connection package.   Please help.  
> >
> >    
> Hi
> 
> If you have configured the password as a task property then it may be
> dropped when the package is exported/imported. You could use a
> configuration file to define the values or if the property is set to
> take it's value from a packaged variable you can set the variable when
> the package is executed.
> 
> Look at http://msdn.microsoft.com/en-us/library/ms141105.aspx and
> http://msdn.microsoft.com/en-us/library/ms140216.aspx
> 
> John
> .
>