Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nickuk2001
Starting Member
2 Posts |
 Posted - 2009-05-19 : 19:32:26
|
| Hi all,I'm trying to export all data from a MSSQL 2008 database to an Access database using the Export Wizard within Management Studio 2008 however I keep getting the following error:TITLE: SQL Server Import and Export Wizard------------------------------Could not connect destination component.Error 0xc0204016: SSIS.Pipeline: The "output column "ExtraInfo" (61)" has a length that is not valid. The length must be between 0 and 4000.------------------------------ADDITIONAL INFORMATION:Exception from HRESULT: 0xC0204016 (Microsoft.SqlServer.DTSPipelineWrap)--------------------------------------------------Is the 4000 characters a limit of an MS Access database? Also, is there any way around this?I want to take a complete backup of the database as my host doesn't back this up. Obviously I don't want to be paying for SQL Server just to put on my PC to backup data.I'm sure I've had this before and it was just a setting in Management Studio 2008 but I can't remember which exactly.Any help would be greatly appreciated.Thanks,Nick |
|
|
jmill130
Starting Member
26 Posts |
Posted - 2009-05-20 : 10:52:34
|
| what datatype is "ExtraInfo". I believe ms access has a 2gb file size limit. How many records will be exported from SQL08 database? |
 |
|
|
nickuk2001
Starting Member
2 Posts |
Posted - 2009-05-20 : 19:30:54
|
| ExtraInfo is of datatype Varchar(Max) although hardly any columns even go over 4000 characters, any ideas?Thanks,Nick |
|
|
|
jmill130
Starting Member
26 Posts |
Posted - 2009-05-21 : 08:48:33
|
| It sounds like its a data conversion problem. What if you save the package that the wizard creates and open it in BIDS (visual studio) and modify the data conversion step it puts between the 2 data connections (SQL and access). I am thinking access does not like that field. I am not sure on the max on a memo field in access.. Maybe make another smaller table of just a few records with a few different lengths of text in the ExtraInfo field and see if it can handle just a few records.. |
|
|
|
|
|
|
Export to Access via Export Wizard