Click here to Skip to main content
14,983,664 members
Home / Discussions / Database
   

Database

 
QuestionEntity Framework VS Linq To SQL Pin
Kevin Marois15-Nov-17 12:29
professionalKevin Marois15-Nov-17 12:29 
AnswerRe: Entity Framework VS Linq To SQL Pin
Richard Deeming28-Nov-17 7:17
mveRichard Deeming28-Nov-17 7:17 
AnswerRe: Entity Framework VS Linq To SQL Pin
Nathan Minier28-Nov-17 8:58
professionalNathan Minier28-Nov-17 8:58 
QuestionChange old store to new store Pin
Member 1333807514-Nov-17 18:13
MemberMember 1333807514-Nov-17 18:13 
AnswerRe: Change old store to new store Pin
Richard Deeming15-Nov-17 2:47
mveRichard Deeming15-Nov-17 2:47 
AnswerRe: Change old store to new store Pin
CHill6015-Nov-17 10:23
mveCHill6015-Nov-17 10:23 
QuestionSSIS throwing error as: Did not read byte array properly Pin
indian1438-Nov-17 8:14
Memberindian1438-Nov-17 8:14 
AnswerRe: SSIS throwing error as: Did not read byte array properly Pin
CHill6011-Nov-17 3:38
mveCHill6011-Nov-17 3:38 
Abdul asked:
1.is it because of the multiple sheets
Try replacing "the file" (I'm guessing this is a workbook) with one with only a single sheet and see if the problem still happens
Abdul asked:
3.The file path is too long (I saw its 150 characters as it shows, the variable datatype that holds the File name is String)
4.or if the File full Path combined with connection string value, does it become too long to be hold by the Connection string of the Source Connection?
Try shortening the path - e.g. put it into a temp folder straight off the root, or map a drive to the location.

Given that it "works" when you have the file open though, it is unlikely to be any of those. The suggestions are just to indicate that you could have easily discounted them for yourself by experimentation.

You are using very old Jet Drivers and you have not mentioned which version of Office or SQL. Try installing at least ACE 12.0 and see if that fixes it.

Beyond that, without knowing what the package is trying to do we're fumbling about in the dark
GeneralRe: SSIS throwing error as: Did not read byte array properly Pin
indian14312-Nov-17 20:24
Memberindian14312-Nov-17 20:24 
AnswerRe: SSIS throwing error as: Did not read byte array properly Pin
jschell15-Nov-17 7:52
Memberjschell15-Nov-17 7:52 
QuestionManaging Database Changes Pin
Kevin Marois8-Nov-17 5:04
professionalKevin Marois8-Nov-17 5:04 
AnswerRe: Managing Database Changes Pin
David Mujica8-Nov-17 5:53
MemberDavid Mujica8-Nov-17 5:53 
AnswerRe: Managing Database Changes Pin
jschell8-Nov-17 7:33
Memberjschell8-Nov-17 7:33 
AnswerRe: Managing Database Changes Pin
Mycroft Holmes8-Nov-17 14:10
professionalMycroft Holmes8-Nov-17 14:10 
AnswerRe: Managing Database Changes Pin
kmoorevs11-Nov-17 9:58
Memberkmoorevs11-Nov-17 9:58 
GeneralRe: Managing Database Changes Pin
Richard Deeming13-Nov-17 1:49
mveRichard Deeming13-Nov-17 1:49 
GeneralRe: Managing Database Changes Pin
kmoorevs13-Nov-17 8:29
Memberkmoorevs13-Nov-17 8:29 
QuestionGet specific records from DB Pin
_Flaviu28-Oct-17 23:08
Member_Flaviu28-Oct-17 23:08 
AnswerRe: Get specific records from DB Pin
A_Griffin28-Oct-17 23:48
MemberA_Griffin28-Oct-17 23:48 
AnswerRe: Get specific records from DB Pin
Mycroft Holmes28-Oct-17 23:54
professionalMycroft Holmes28-Oct-17 23:54 
QuestionA question about the behavior of Jet and Ace drivers Pin
indian14324-Oct-17 7:58
Memberindian14324-Oct-17 7:58 
GeneralRe: A question about the behavior of Jet and Ace drivers Pin
PIEBALDconsult24-Oct-17 8:32
professionalPIEBALDconsult24-Oct-17 8:32 
GeneralRe: A question about the behavior of Jet and Ace drivers Pin
indian14325-Oct-17 7:15
Memberindian14325-Oct-17 7:15 
GeneralRe: A question about the behavior of Jet and Ace drivers Pin
jschell27-Oct-17 7:43
Memberjschell27-Oct-17 7:43 
QuestionMath expression as Column value as string in the Dynamic Sql Pin
indian14319-Oct-17 7:19
Memberindian14319-Oct-17 7:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.