Click here to Skip to main content
16,021,125 members
Home / Discussions / Database
   

Database

 
GeneralRe: Mysql database problem Pin
jschell31-Mar-18 7:29
jschell31-Mar-18 7:29 
GeneralRe: Mysql database problem Pin
Victor Nijegorodov31-Mar-18 20:56
Victor Nijegorodov31-Mar-18 20:56 
AnswerRe: Mysql database problem Pin
jschell31-Mar-18 7:34
jschell31-Mar-18 7:34 
QuestionSSIS package and package in a SQL server agent Job Pin
VK1927-Mar-18 8:27
VK1927-Mar-18 8:27 
GeneralRe: SSIS package and package in a SQL server agent Job Pin
CHill6027-Mar-18 22:09
mveCHill6027-Mar-18 22:09 
GeneralRe: SSIS package and package in a SQL server agent Job Pin
VK1928-Mar-18 2:06
VK1928-Mar-18 2:06 
GeneralRe: SSIS package and package in a SQL server agent Job Pin
CHill6029-Mar-18 12:27
mveCHill6029-Mar-18 12:27 
AnswerRe: SSIS package and package in a SQL server agent Job Pin
#realJSOP29-Mar-18 8:54
professional#realJSOP29-Mar-18 8:54 
You should specify UNC paths when you're loading files in your packages. That way, it will work no matter where you put the file (as long as you're using the correct UNC path of course).

BTW, you can write a script task in a package that will import that data (as opposed to running an external application).

I wrote an article not to long ago that includes code to import excel and CSV files - SQLXAgent - Jobs for SQL Express - Part 3 of 6[^]

I think you might find it useful. I'm currently extracting that code into it's own assembly for easier inclusion into projects like yours. It even goes to some length to determine the data type represented in each column.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

QuestionApplication stopped working after backup and restoring the Database with another name Pin
indian14326-Mar-18 8:55
indian14326-Mar-18 8:55 
AnswerRe: Application stopped working after backup and restoring the Database with another name Pin
Richard Deeming26-Mar-18 10:00
mveRichard Deeming26-Mar-18 10:00 
GeneralRe: Application stopped working after backup and restoring the Database with another name Pin
indian14327-Mar-18 6:10
indian14327-Mar-18 6:10 
QuestionSQL server job execution time Pin
VK1922-Mar-18 7:47
VK1922-Mar-18 7:47 
AnswerRe: SQL server job execution time Pin
Victor Nijegorodov22-Mar-18 8:40
Victor Nijegorodov22-Mar-18 8:40 
GeneralRe: SQL server job execution time Pin
VK1922-Mar-18 9:11
VK1922-Mar-18 9:11 
GeneralRe: SQL server job execution time Pin
Victor Nijegorodov22-Mar-18 9:45
Victor Nijegorodov22-Mar-18 9:45 
AnswerRe: SQL server job execution time Pin
David Mujica26-Mar-18 5:55
David Mujica26-Mar-18 5:55 
QuestionReplace ids with value Pin
Member 1266749416-Mar-18 8:32
Member 1266749416-Mar-18 8:32 
AnswerRe: Replace ids with value Pin
Eddy Vluggen16-Mar-18 8:54
professionalEddy Vluggen16-Mar-18 8:54 
Rant[REPOST] Replace ids with value Pin
Richard Deeming16-Mar-18 11:42
mveRichard Deeming16-Mar-18 11:42 
QuestionReplace Ids With value Pin
Member 1266749416-Mar-18 8:29
Member 1266749416-Mar-18 8:29 
AnswerRe: Replace Ids With value Pin
Victor Nijegorodov16-Mar-18 9:21
Victor Nijegorodov16-Mar-18 9:21 
QuestionDB2 to SQL conversion Pin
Member 1028121715-Mar-18 4:06
Member 1028121715-Mar-18 4:06 
AnswerRe: DB2 to SQL conversion Pin
Victor Nijegorodov15-Mar-18 5:09
Victor Nijegorodov15-Mar-18 5:09 
AnswerRe: DB2 to SQL conversion Pin
Richard Deeming15-Mar-18 6:41
mveRichard Deeming15-Mar-18 6:41 
QuestionBillion rows Pin
jschell10-Mar-18 10:39
jschell10-Mar-18 10:39 

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.