November 2, 2011 at 5:02 am
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
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
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.
November 8, 2011 at 10:39 am
Note that I have just downloaded the Service Pack 1 in vain... problem persists!
November 9, 2011 at 2:23 am
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
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
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
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