August 9, 2011 at 8:25 am
Hello,
I have this task to accomplish
Please take last night’s full backup and convert it to a standard Microsoft SQL backup file, compress the file and then FTP it to CPA (root directory).
I have converted it to .bak file using red gate backup. Can you give me a list of step to take to use the ftp in business intelligence development studio?
Thanks.
Regards.
This task involves moving the backup file using the ftp task. Do I need to first restore the backup first? How can I compress a backup without restoring it first using SQL Server 2008R2?
Thanks.
Like when creating packages, do I need to create a connection manager, define data sources and all those tasks? This is my first time of doing this and your help will be much apreciated. Thanks in advance.
August 9, 2011 at 9:15 am
sahoong (8/9/2011)
Hello,I have this task to accomplish
Please take last night’s full backup and convert it to a standard Microsoft SQL backup file, compress the file and then FTP it to CPA (root directory).
I have converted it to .bak file using red gate backup. Can you give me a list of step to take to use the ftp in business intelligence development studio?
Thanks.
Regards.
This task involves moving the backup file using the ftp task. Do I need to first restore the backup first? How can I compress a backup without restoring it first using SQL Server 2008R2?
Thanks.
Like when creating packages, do I need to create a connection manager, define data sources and all those tasks? This is my first time of doing this and your help will be much apreciated. Thanks in advance.
Do you have SQL 2008? That can create the backup for you and compress it, meaning you'll have only the FTP task to automate in SSIS.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 9, 2011 at 9:22 am
I have done the compression. I just need help with how to use the ftp task for the automation that you just talked about. Please, tell me how to use the ftp task? I have tried it but I keep getting the error message below.
501 Server cannot accept argument.
.
Error: 0xC002918B at FTP Task, FTP Task: Unable to send files using "FTP Connection Manager".
Task failed: FTP Task
Warning: 0x80019002 at FTP: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "FTP.dtsx" finished: Failure.
The program '[2708] http://FTP.dtsx: DTS' has exited with code 0 (0x0).
August 9, 2011 at 9:27 am
I don't think that this is a problem with SSIS. That error is an FTP error. Have you tried FTPing the file manually, by some other mechanism, just to check that all is well?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 9, 2011 at 9:30 am
Could you please, tell me how I can try it manually? I am a newbie with ftp task and I have been on this task since 9 in the morning. Thanks.
August 9, 2011 at 9:32 am
If i want to ftp a file, do I need any other task apart from the FTP task? Do I need to create a file system task? Thanks.
August 9, 2011 at 9:36 am
sahoong (8/9/2011)
Could you please, tell me how I can try it manually? I am a newbie with ftp task and I have been on this task since 9 in the morning. Thanks.
You could download FileZilla - it will help you configure your remote site (address/user/password etc) & then do the transfer. You might need to read the help, but you need to learn about this stuff if you're writing a package to do it.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 9, 2011 at 9:37 am
Is this normal FTP or SFTP?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 9, 2011 at 9:46 am
normal ftp
August 9, 2011 at 9:49 am
I was just asked to pick a backup file and ftp it.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply