Post reply

FTP TASK

  • August 9, 2011 at 4:21 am

    #241441

    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.

  • August 9, 2011 at 4:26 am

    #1365732

    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.

  • August 9, 2011 at 4:31 am

    #1365734

    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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply