Click here to Skip to main content
15,867,308 members
Home / Discussions / Database
   

Database

 
AnswerRe: Import CSV Problems Pin
CHill604-Oct-21 21:04
mveCHill604-Oct-21 21:04 
GeneralRe: Import CSV Problems Pin
Jörgen Andersson4-Oct-21 21:13
professionalJörgen Andersson4-Oct-21 21:13 
GeneralRe: Import CSV Problems Pin
CHill604-Oct-21 21:34
mveCHill604-Oct-21 21:34 
GeneralRe: Import CSV Problems Pin
Jörgen Andersson4-Oct-21 21:43
professionalJörgen Andersson4-Oct-21 21:43 
GeneralRe: Import CSV Problems Pin
Jörgen Andersson4-Oct-21 22:04
professionalJörgen Andersson4-Oct-21 22:04 
AnswerRe: Import CSV Problems Pin
Richard Deeming4-Oct-21 22:04
mveRichard Deeming4-Oct-21 22:04 
GeneralRe: Import CSV Problems Pin
Jörgen Andersson4-Oct-21 22:11
professionalJörgen Andersson4-Oct-21 22:11 
GeneralRe: Import CSV Problems Pin
Richard Deeming4-Oct-21 23:12
mveRichard Deeming4-Oct-21 23:12 
Jörgen Andersson wrote:
what is the best way to change the file encoding that can be run from inside an SSIS package?
You can add an "execute process" task to execute an external program to change the file encoding.

For example, you could use C# to change the encoding:
Converting a text file from one encoding to another - Buck Hodges[^]



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

GeneralRe: Import CSV Problems Pin
Jörgen Andersson5-Oct-21 1:17
professionalJörgen Andersson5-Oct-21 1:17 
AnswerRe: Import CSV Problems Pin
RedDk5-Oct-21 8:11
RedDk5-Oct-21 8:11 
GeneralRe: Import CSV Problems Pin
Jörgen Andersson5-Oct-21 23:33
professionalJörgen Andersson5-Oct-21 23:33 
QuestionWHERE NOT EXIST QUERRY Pin
remiki13-Sep-21 5:00
remiki13-Sep-21 5:00 
AnswerRe: WHERE NOT EXIST QUERRY Pin
Richard Deeming13-Sep-21 5:58
mveRichard Deeming13-Sep-21 5:58 
AnswerRe: WHERE NOT EXIST QUERRY Pin
remiki13-Sep-21 6:02
remiki13-Sep-21 6:02 
AnswerRe: WHERE NOT EXIST QUERRY Pin
0x01AA6-Jan-22 9:39
mve0x01AA6-Jan-22 9:39 
QuestionDatabase programming Pin
Member 153534049-Sep-21 23:54
Member 153534049-Sep-21 23:54 
AnswerRe: Database programming Pin
Richard MacCutchan10-Sep-21 0:27
mveRichard MacCutchan10-Sep-21 0:27 
QuestionHow to design sql db for storing Name/Value objects with unknown value type (EF Core 5 as ORM)? Pin
Member 146377867-Sep-21 0:43
Member 146377867-Sep-21 0:43 
Rant[REPOST] How to design sql db for storing Name/Value objects with unknown value type (EF Core 5 as ORM)? Pin
Richard Deeming7-Sep-21 1:00
mveRichard Deeming7-Sep-21 1:00 
QuestionWhy not to use NoSQL instead of RMDBS? (not Mongo) Pin
Hopeless Idealist14-Aug-21 1:21
Hopeless Idealist14-Aug-21 1:21 
AnswerRe: Why not to use NoSQL instead of RMDBS? (not Mongo) Pin
Mycroft Holmes14-Aug-21 12:36
professionalMycroft Holmes14-Aug-21 12:36 
AnswerRe: Why not to use NoSQL instead of RMDBS? (not Mongo) Pin
jschell5-Sep-21 9:07
jschell5-Sep-21 9:07 
QuestionSql query , comparing a table field to a list of values , condition (MS SQL) Pin
zira178929-Jul-21 15:32
zira178929-Jul-21 15:32 
AnswerRe: Sql query , comparing a table field to a list of values , condition (MS SQL) Pin
Richard MacCutchan29-Jul-21 21:15
mveRichard MacCutchan29-Jul-21 21:15 
AnswerRe: Sql query , comparing a table field to a list of values , condition (MS SQL) Pin
Anand RB 20218-Aug-21 18:16
Anand RB 20218-Aug-21 18:16 

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.