Post reply

Saving SSIS Export package

  • November 2, 2011 at 5:02 am

    #259435

    Hi,

    The final step of a process consists of exporting data from tables to a flat file, which I used to do manually through the SQL export wizard. I am trying to save the actual dtsx created by the engine so I could automate the process however whenever choosing to save the SSIS package to either SQL Server or File system the saving process fails with an 'unspecified Error'. Please advise.

    Regards,

    Sam

  • November 2, 2011 at 5:57 am

    #1402084

    Just tried to manually design the SSIS package, consists of OLEDB Source and a flat file destination... however the package won't save either generating the following error: An invalid character was found in text content.

    feedback anyone!

  • November 8, 2011 at 9:49 am

    #1404676

    seems that this issue was a bug and has been resolved by a hotfix. However it is better recommended to download the SQL 2008 R2 SP1 for that purpose.

    http://support.microsoft.com/kb/977889

  • November 8, 2011 at 10:39 am

    #1404715

    Note that I have just downloaded the Service Pack 1 in vain... problem persists!

  • November 9, 2011 at 2:23 am

    #1405034

    smecharrafie (11/8/2011)

    Note that I have just downloaded the Service Pack 1 in vain... problem persists!

    I guess you need the cumulative update package 6 for SP1. So sp1 alone is not enough.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • November 9, 2011 at 2:45 am

    #1405045

    well I almost downloaded it until I read the following:

    WARNING This hotfix has not undergone full testing.

    If you decide to install this hotfix, please note the following items:

    Do not deploy a hotfix in a production environment without first testing the hotfix.

    Back up the system or the computer that will receive the hotfix before you install the hotfix.

    Can someone guarantee this fix actually works and has no negative impact whatsoever?

  • November 9, 2011 at 2:54 am

    #1405050

    smecharrafie (11/9/2011)

    Can someone guarantee this fix actually works and has no negative impact whatsoever?

    You need to ask Microsoft that question, not some unknown forum members.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • November 9, 2011 at 3:04 am

    #1405052

    alright, thanks for the feedback.

    Regards,

    Sam

Viewing 8 posts - 1 through 7 (of 7 total)

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