June 6, 2017 at 9:10 pm
Is there a really easy way to import data into SQL?
June 6, 2017 at 11:27 pm
How long is a piece of string?
Is this a one-off or do you need to import different files with the same structure?
If it’s a one-off you can use BCP. If you need to repeat it, you can use SSIS and create a job that runs on a schedule….
June 10, 2017 at 9:05 pm
There are 9 items in the table. I can export from the website and import into SQL as a .cvs or html file. There is also a section on the website for MySQL mapping. There will be a different file each day with similar or varied data. I love the idea of creating a job that runs on a schedule!
June 10, 2017 at 10:47 pm
SSIS package to get the file (download), then import the text file. Then schedule it using a job?
June 13, 2017 at 8:32 pm
How do i get SSIS?
June 14, 2017 at 3:56 am
wishchicky - Tuesday, June 13, 2017 8:32 PMHow do i get SSIS?
If you’re asking that question then SSIS would not be a quick solution.
Would the Import Data Wizard be more suitable? In SSMS, right-click on the database name, then ‘Tasks/Import Data…’.
Have a look at that and see if it would be good enough for your needs.
Steve Hall Linkedin
Blog Site[/url]
June 14, 2017 at 4:11 am
If it’s a simple data load then SSIS is probably overkill anyway. The Import/Export Wizard is good for one-off loads (and you can save it as well, but then we’re back to SSIS). BULK INSERT and bcp should also work well, and you can easily schedule them.
John
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply