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 |
|
bhuvnesh.dogra
Starting Member
22 Posts |
 Posted - 2008-12-18 : 01:16:52
|
| hi i m having SQL server 2005 Any weird error occured while transferring SQl table into Access file some times data got 100% transferred but sometimes partial i m attaching error file which i got when i execite that SSIS package |
|
|
bhuvnesh.dogra
Starting Member
22 Posts |
Posted - 2008-12-18 : 01:28:48
|
| sorry i forget to add ERROR :Error: the file ExistsError: te buffer manager could not get temporary file name.the call to GetTempFileName failed.Error: the buffer manager cannot create a file to spool a long object on the direction named in the BLOBTempStoragePath Porperty.Either an incorrect file name provided or there are no permissionError: Long data was retrieved for a column but cannot be added to the data flow task buffer. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-18 : 01:42:41
|
| which task is this happening? are you having any BLOB datatypes invloved in transfer like varchar(max)? |
|
|
|
bhuvnesh.dogra
Starting Member
22 Posts |
Posted - 2008-12-18 : 06:38:35
|
| yes actually a table with below schema creating problem whenvever this table comtains heavy data'CREATE TABLE [dbo].[DMP_SURVEY_ANSWER_SUMMARY]( respondent_id int NOT NULL, survey_id int NOT NULL, survey_type nvarchar(50) NULL, cv_survey_type_id ut_short_description NULL, answer_1 nvarchar(max) NULL, answer_2 nvarchar(max) NULL, answer_3 nvarchar(max) NULL, answer_4 nvarchar(max) NULL, answer_5 nvarchar(max) NULL, answer_6 nvarchar(max) NULL, answer_7 nvarchar(max) NULL, answer_8 nvarchar(max) NULL, answer_9 nvarchar(max) NULL, answer_10 nvarchar(max) NULL, answer_11 nvarchar(max) NULL, answer_12 nvarchar(max) NULL, answer_13 nvarchar(max) NULL, answer_14 nvarchar(max) NULL, answer_15 nvarchar(max) NULL, answer_16 nvarchar(max) NULL, answer_17 nvarchar(max) NULL, answer_18 nvarchar(max) NULL, answer_19 nvarchar(max) NULL, answer_20 nvarchar(max) NULL)but the strange thing is that it doesn't happen on every run .like only in 1 run out of 4 run . |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-12-18 : 07:30:30
|
| Check the actual size used in the MAX columns - they may be too large for MSAccess.SELECT DATALENGTH([answer_20]) as Data_len, len([answer_20]) Char_lenFROM [dbo].[DMP_SURVEY_ANSWER_SUMMARY]where [answer_20] is not null |
|
|
|
|
|
|
|
|
Weird error occured in SSIS