SSIS flat file to ftp server -
I have an SSIS package (using R2 2008) which I would like to send to my FTP server flat under the connection string In the File Connection Manager, I have kept the address \ stp-ftp \ RMB as the place that I would like to keep the file, but every time I close the connection manager, it comes back to my original location. Is there any way right? The share drive I am trying to send the file to is not mapped to the SQL Server, where I am working, is that what should be?
Thanks -
I have an expression to add a date at the end of the file Was using! It seems that the expression was overwriting my connection string
Comments
Post a Comment