sql server - Move database tables, doing some transformations - SSIS -

-

i need move data 1 ms sql database another. however, destination database bit different. example, table has same rows, different data types , on. read, looks ssis tool, however, how process , components toolbox use example above? concern might have create 1 data flow source each table or that. anyway, less time consuming option?

thank you!

given it's disposable task , data volume low, i'd use import/export wizard generate basics of moving tables. can either right-click on database in ssms, tasks, export... or run dtswizard.exe commandline/start->run

either way, you'll have wizard walking through variety of screens. of them self-explanatory never stops me commenting.

first 2 screens define source , destination. default of both of of "sql server native client 10.0" correct, define source , destination server names , database/catalogs.

3rd screen accept default of copoy data 1 or more tables or views.

4th screen allows pick source tables , default destination same table , schema. if of tables have identity columns, want click on "edit mappings..." button , check "enable identity insert" option. needs done per table.

5th screen rather important. need manipulate data before can target tables, uncheck run (unless feel lucky) , check save ssis package. save file system, change package protection level "do not save sensitive data"

6th screen asks package should saved , should called. i'm naming so_araujo , saving c:\sandbox\ssishackandslash\ssishackandslash\so_araujo.dtsx , call not matter, merely make note of is.

click finish , review actions. if there errors of type "failure inserting read-only column" make note missed identity inserts.

open visual studio, create new project of type sql server integration services (under business intelligence section) , right click on project (mine's called ssishackandslash) , select add, new item... select package created on 6th screen , double click open it.

the import/export wizard ungood thing of putting lots of unrelated source & destinations in dataflow. since one-off, wouldn't care vs speed of letting gui add tables , wiring them up.

now comes fun of coercing data types right type , else need done. you'll looking @ combination of derived columns transformations , data conversion transformations , remapping column in destination table. if have particular issues, sing out. might have done bit of ssis ;)

an alternative solution use ezapi script out bulk of data movement , hand edit 20% needs massaged.


Comments

Post a Comment

Popular posts from this blog

delphi - How to convert bitmaps to video? -

-
Image
my application creates images fractals , love feeling of 'flying' around fractal. once saved 2000 bitmaps file , created avi using premiere. experience rather frustrating though succeeded in creating movie. spectacular. of course want create video application. don't care niftyness of codec, compression or whatever. want have video can replay on systems. in past have tried never succeeded. triggered question alas not ffmpeg running. update i decided adapt question , put bounty it. have seen several solutions attractive (because it's simple) seems me taviwrite. tried taviwriter did not succeed. in procedure taviwriter.write; function call around line 370 avierr := avisavev(s, // pchar(filename), nil, // file handler nil, // callback nstreams, // number of streams streams, compoptions); // compress options
Read more

jasper reports - Fixed header in Excel using JasperReports -

-
how can create excel report fixed header using japserreports? mean need header fixed when scroll excel file. this possible adding couple properties in jrxml file each report. take @ advanced excel features freeze panes. if wanted freeze after first column header (down left side basically) this: <statictext> <reportelement style="sans_bold" mode="opaque" x="0" y="60" width="104" height="20" forecolor="#ffffff" backcolor="#666666"> <property name="net.sf.jasperreports.export.xls.auto.filter" value="start"/> <property name="net.sf.jasperreports.export.xls.column.width" value="110"/> <property name="net.sf.jasperreports.export.xls.freeze.column.edge" value="left"/> </reportelement> &
Read more

python - ('The SQL contains 0 parameter markers, but 50 parameters were supplied', 'HY000') or TypeError: 'tuple' object is not callable -

-
import pyodbc,nltk,array cnxn = pyodbc.connect('driver={mysql odbc 5.1 driver};server=127.0.0.1;port=3306;database=information_schema;user=root; password=1234;option=3;') cursor = cnxn.cursor() cursor.execute("use collegedatabase ;") cursor.execute("select * sampledata ; ") cnxn.commit() s=[] j=[] x=[] words = [] w = [] sfq = [] pos=[] entry in cursor: s.append(entry.injury_type),j.append(entry.injury_desc) nltk.tokenize import punktwordtokenizer nltk.corpus import stopwords tokenizer = punktwordtokenizer() english_stops = set(stopwords.words('english')) in range(0,26): # filter stop words tokenizer.tokenize(j[i]) w.append([word word in tokenizer.tokenize(j[i]) if word not in english_stops]) in range(0 , 26):#converting tokenzied text ito string sfq.append(" ".join(w[a])) replacers import regexpreplacer replacer = regexpreplacer() in range (0,26):#pos tagging replacer.repl
Read more