sql server - Import multiple tables into SQL from CSV if existing in folder -


in extension question: import multiple csv files sql server folder

as question states, want import multiple tables csv sql server folder. thing in case, can have 17 different tables, have different layouts. have 2 columns, while others have 10 instance.

is possible create script takes account different tables setup based on name of csv file, , import correct if table exist in folder?

the thing csv files never change names/layout. not 17 tables used in every project.

i want rough code along proper comments understand it.

someone please me out on one. lot in advance :)

this perfect situation using sql server integration services (ssis), provided have available in working environment. (i assume do, or can installed.)

ssis huge platform in own right cannot explain how use here. places start learning are:

there plenty of books , other websites available too.

broadly speaking, first need create ssis "package", file of .dtsx extension. create on local pc using microsoft visual studio or microsoft sql server data tools. has reasonably user-friendly graphical interface.

within package need configure data source each of 17 possible files, "map" them corresponding tables in target sql database.

provided set appropriately, package work gracefully if of files don't exist - load whichever present. this crux of why ssis option in use-case.

after creating package, there multiple ways use/deploy it. based on comments , question, think best way might be:

  1. upload ssis package store on sql server (using ssms object explorer, connecting ssis instance rather sql server instance). you'll need ssis components installed on sql server platform this.
  2. create sql job via sql agent, step triggers ssis package. might want steps before or after step, run t-sql code prepares sql tables load data into, or things data after loading (such cleaning , validating it).
  3. rather running sql script set whole process off, instead trigger job run, either manually (via sql agent again) or using built-in scheduling facilities (e.g. run every night @ 6pm).

packages can saved kind of standalone executable, in folder location, , run within windows double-click (without needing open visual studio/ssdt again).


Comments

Post a Comment

Popular posts from this blog

java - WARN : org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/board/] in DispatcherServlet with name 'appServlet' -

this question has answer here: why spring mvc respond 404 , report “no mapping found http request uri […] in dispatcherservlet”? 3 answers i trying making simple bbs i'm encountering following error, warn : org.springframework.web.servlet.pagenotfound - no mapping found http request uri [/board/] in dispatcherservlet name 'appservlet' i have tried solve error many times, have failed. how can solve error? here web.xml, controllerand , servlet-context. my web.xml <?xml version="1.0" encoding="utf-8"?> <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xsi:schemalocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"> <filter> <filter-nam...
Read more

html - Outlook 2010 Anchor (url/address/link) -

i'm trying link specific pdf page msoutlook'10 or msword'10, #page=... anchor particularly useful , works fine elsewhere. unfortunately when click [ctr-k] in outlook or winword, links re-formatted assuming unc path. pdf file located on shared drive. using "file:" prefix links open pdf in adobe reader (outside of browser), , "http:" open inside browser. issue seem need open in browser "file:" prefix in order anchor work. know anchors work inside browser. outlook uses windows/explorer default program (based on file extension) seems open in adobe reader neglecting anchor. is aware of solution, link specific page or bookmark of shared-pdf ms outlook and/or winword link? common references: mailermailer.com/...anchor-tags-html-emails campaignmonitor.com/...anchor-links-in-email-newsletters/ stackoverflow.com/...anchor-in-pdf-document
Read more

android - How to create dynamically Fragment pager adapter -

i unable create dynamic layout each tabs, able create tabs dynamically constructor(public mypageradapter(fragmentmanager fm , int nooftabs)), coudn't inflate view each tabs creating each fragment should dyanmic. public class mypageradapter extends fragmentpageradapter { private final string[] titles = { "categories", "home", "top paid", "top free", "top grossing", "top new paid", "top new free", "trending" }; int nooftabs; **public mypageradapter(fragmentmanager fm , int nooftabs) { super(fm); this.nooftabs = nooftabs; }** /*public mypageradapter(fragmentmanager fm) { super(fm); }*/ @override public charsequence getpagetitle(int position) { return titles[position]; } @override public int getcount() { ...
Read more