MZ@ !L!This program cannot be run in DOS mode. $ 5ۯA[A[A[A[A[hG]A[RichA[PEL L6!  p  <@18 .text `.rdata  @@.data$00@.rsrc1@@@@@.reloct@BD$Vu 0~1I 0  0uSh 0u3^ 0h0h000@0^ u@ 0t650;rtЋ 0;sQ 0^ SUVt$Wu 0u 3_^][ |$\$tu( 0tWVSхt WVSu 3_^][ WVSZu uWPStu"WVSu3t 0tWVSЋ_^][ % ̃|$u 0u D$P  t | `  X t | Yfree _inittermmalloc_adjust_fdivMSVCRT.dllQDisableThreadLibraryCallsKERNEL32.dllp!Ppx0@ X(ipuvwxy~0H`x 8Ph ( @ X p  )0 H ` x      8 P h        ( @ X p        !0 "H #` $x % & ' ( ) *gm t8uPzh|(@Xp0H`x 8Ph(@Xp     0H`xoqr s8Ph(@Xp0H`x            0 @ P ` p             0 @ P ` p             0 @ P ` p             0 @ P ` p             0 @ P ` p             0 @ P ` p             0 @ P ` p             0 @ P ` p             0 @ P ` p               0  @  P  `  p                  ! !  ! 0! @! P! `!xP@X".9'()*h+P,8- ./p1345h8hx:h<hH?hABH~4C|:дpX@(ȾhP8 (pX((((P8(p(((000(hP(((  (H0(h((fhh8kXmXo4ppyp}~p^Ђp6l r؍tPx(~rسhV`(Pf (:hHP@00F0*`P  J LX$@* H7 h> GHORnhV"\Bf. c eo6H"`""""(" ""@""x""" "X"" "a T(!/X!AVI4VS_VERSION_INFO  ?DVarFileInfo$Translation StringFileInfo040904E4(PlatformWindowsLCompanyNameMicrosoft CorporationXFileDescriptionDTSWIZ70 - Resource DLL6 FileVersion1998.11.138 InternalNameDTSWIZ70ENUp&LegalCopyrightCopyright Microsoft Corp. 1988-1998sLegalTrademarksMicrosoft is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of Microsoft CorporationHOriginalFilenameDTSWIZ70ENU.EXEJProductNameMicrosoft SQL Server6 ProductVersion7.00.623(CommentsWindows@@=MS Sans Serif Ps7The Data Transformation Services makes it easy to import, export and transform heterogeneous data using OLE DB and ODBC. This import wizard will walk you through the process of loading, validating and enhancing your distributed data. Ps+g+Welcome to the Data Transformation Services Wizard@@=MS Sans SerifPs g+Completing the DTS WizardPs+ You have successfully specified then information necessary to copy, transform, or transfer the data. Review the selections below and click on FINISH to execute PsNs I&Summary:PsX_BDimensionEdit@@ =MS Sans SerifPu&Source tables:P {qSysTreeView32Tree1P1$>PB$<PS$<<P~S&elected columns:P {qDimensionDataCtrlP/Move &UpP/Move &Down@@ =MS Sans SerifPx&Selected columns:P {rDimensionDataCtrlP"$>P3$>>PD$<PU$<<PnS&orting order:P {rDimensionDataCtrlP/Move &UpP/Move &Down@@=MS Sans SerifP&Tables:P s2DimensionDataCtrlP5C&Select AllPO5D&Deselect AllP-~&Preview...3Advanced PropertiesMS Sans SerifP%DimensionDataCtrlP2OKP2CancelP%The OLE DB driver supports the advanced options listed below. Enter any custom settings you require in the value column.HColumn Mappings and TransformationsMS Sans SerifP2OKP2CancelP*:SysTabControl32Tab1P(-Source:PXc:\excel\test.xlsP(-Destination:PXPubs.dba.authorsPP#:P2 &Help P= C&reate destination table PK vD&elete rows in destination table PY w&Append rows to destination tableP<8 Edit &SQL... PK &Drop and recreate destination table.PX +Enable &identity insertPe8&Mappings:Pn%EbDimensionDataCtrlP9cSource column:PPfname char(50) not null P;e&Copy the source columns directly to the destination columns PO'3&Transform information as it is copied to the destinationP\)VYP =2<&Advanced...C!P7p/gP#h&Language:P2&Browse...@@=MS Sans SerifP PDz&Delimited. The columns are separated by any character(s). PD {&Fixed field. Information is aligned into columns of equal width.P:P!*7File &type:!PZ(S*}P!97&Row delimiter:!PZ7S*|P!G7Text &qualifier:!PZFS*P*'&Skip rows: P( P' msctls_updown32Spin1P9d F&irst row has column namesPY4Preview of file:PKYtestfile.txtPb.~@@=MS Sans SerifPIRow width:P vRulerCtlP&Value: P% P) msctls_updown32Spin1@@=MS Sans SerifPGHRulerCtlP=zPreview:P;InstructionsP$  The vertical lines indicate the starting and ending positions of a column.P$ To create a column, click at the desired positionP$$ To delete a column break, double click on the lineP$/ To move a column break, click and drag the line@@=MS Sans Serif P@ Co&mma PX; &Tab PF &Semicolon P( &Other:P! PbPreview:PyDimensionDataCtrl@@=MS Sans SerifPbPreview:P DimensionDataCtrl@@=MS Sans SerifPQuery &statement:P rDimensionEditP~: &Query BuilderPU~.&ParseP~.B&rowse...@@=MS Sans SerifPZ&Source Table:B!PwEP[D&estination File Name:PwP) PB' z&Delimited. The columns are separated by any character(s). PA5 {&Fixed field. Information is aligned into columns of equal width.PDKP!R5File &type:!PYOH*}P!`5&Row delimiter:!PY^H*|P!o5&Column delimiter:!PYmH*~P!~5Text &qualifier:!PY|H*PQg F&irst row has column namesP{2<Tr&ansform...PwQuery / File Name@@=MS Sans Serif P84 &Copy table(s) from the source database P8K &Use a query to specify the data to transfer P8b &Transfer objects and data between SQL Server 7.0 databasesPCPCPCPCPCPCPCPCPCPCPPPPPPPPPPPsSQL ServerPsSQL ServerPC1PPC2PP2/ HDefine Column Mapping and TransformationMS Sans SerifP5: P= C&reate destination table PK vD&elete rows in destination table PY w&Append rows to destination tableP<8 Edit &SQL... PK &Drop and recreate destination table.PX +Enable &identity insertPed&Mappings:Pn%EbDimensionDataCtrlP9cSource column:PPfname char(50) not nullHDefine Column Mapping and TransformationMS Sans SerifP5: P;e&Copy the source columns directly to the destination columns PO'3&Transform information as it is copied to the destinationP\)VYP =2<&Advanced...C!P7p/gP#h&Language:P2&Browse... 2Advanced Transformation PropertiesMS Sans SerifP)Transformation flags define how data is converted between the source and destination. Select the transformation flags to apply. P). &Default transformation flags. All possible conversions are allowed P)=&Require exact match between source and destination (data type, size, precision, scale, nullability) P)W&Custom transformation flagsP5e iAllow data type &promotion (16 bit integer to 32 bit integer).P5r jAllow data type de&motion (32 bit integer to 16 bit integer - loss possible).P5 k&Allow NULL conversion (NOT NULL to NULL data type).P2OKP2CancelPP$(@@9=MS Sans SerifP6Des&tination:S!POhPP!P?Before you can export information to Microsoft SQL Server, you must specify the server, user name and password.P P P P P P P P P!P!1P!2P?38&Server:B!Px19 P?B Use &Windows NT authentication P?P Use S&QL Server authenticationPK_'&Username:Px] PKn(&Password:Pxl P?3&Database:!Px}IVP}&&RefreshP}2<&Advanced...P>48&File name:Pw2 P2 ...P>C8&Username:PwA P>R8&Password:PwP  P>4K User/System &DSN:!P2p:P2" N&ew... P>C- &File DSNPB PB ...P?UP>_8&Username:P] P>o8&Password:Pm P>38&Server:Pw1 P>B8&Username:Pw@ P>Q8&Password:PwO P>48&File name:Pw2 P2 ...P2F&Properties...PDF&Load UDL file...@@=MS Sans Serif Pn '&All rows P (&Only Rows meeting criteria!PH%VA!P%3!P%VAP% ...!P$6"3!PH6VA!P63!P6VA P6 ...!P$F"3!!PHFVA"!PF3#!PFVA$PF ...PH@Column:POper.:PHValue/Column:ȀSelect a ValueMS Sans SerifP(2OKP_2CancelPrPP- Select a distinct value for the column:P- <no column selected>@@"=MS Sans SerifP9N&ame:PQ P9&Description:PQ P!9&Owner password:PQI P!>Us&er password:PI P/9&Location:PQ/StaticP6XP@ P8B, &Server name:B!Pr@J P6Q Use &Windows NT authentication P6_ Use S&QL Server authenticationPBo#&Username:Prm PB}"&Password:Pr| P@ P8B,&Server name:!Pr@JP@. LS&canning ... P6Q Use &Windows NT authentication P6_ Use S&QL Server authenticationPBo#&Username:Prm PB~" &Password:Pr| P@P8B!&File name:Pr@ P@ ...@@=MS Sans SerifP P;o Preview Excel &worksheet P;p Preview Excel named &rangePx*P5ZDimensionDataCtrlP,Preview:!-Transferring DataMS Sans SerifP2< &BackP2&DoneP? msctls_progress32Progress1P4Progress:PO&Transfer status:P, P+ P+ P+ P+ P+ P+ P+ P+ P, P P P P P P P P P P PXgDimensionDataCtrlP&]SQL ServerP&]SQL ServerPQMSysAnimate32Animate1P, 1P P, 2P Ȁ Create Table SQL StatementMS Sans SerifP2OKP2CancelPYou may modify the default create table SQL statement that is generated by the DTS Wizard. Further modifications to the column mappings will not change the below SQL statement.P$SQL statement:P-[DimensionEditPB&Auto Generate@@=MS Sans SerifPP?38&Server:B!Px19 P?B Use &Windows NT authentication P?P Use S&QL Server authenticationPK_'&Username:Px] PKn(&Password:Pxl P?3&Database:!Px}IVP}&&RefreshP}2<&Advanced...P?You have selected "Microsoft SQL Server". Before you can export information to Microsoft SQL Server, you must specify the server, user name and password.P@@ =MS Sans SerifPP>48&File name:Pw2 P2 ...P>C8&Username:PwA P>R8&Password:PwP P>You have selected "Microsoft SQL Server". Before you can export information to Microsoft SQL Server, you must specify the server, user name and password.P@@=MS Sans SerifPPP>You have selected "Microsoft SQL Server". Before you can export information to Microsoft SQL Server, you must specify the server, user name and password. P>4K User/System &DSN:!P2p:P2" N&ew... P>C- &File DSNPB PB ...P?UP>_8&Username:P] P>o8&Password:Pm @@ =MS Sans SerifP PP>You have selected "Microsoft SQL Server". Before you can export information to Microsoft SQL Server, you must specify the server, user name and password.P>38&Server:Pw1 P>B8&Username:Pw@ P>Q8&Password:PwO @@=MS Sans SerifPPP>You have selected "Microsoft SQL Server". Before you can export information to Microsoft SQL Server, you must specify the server, user name and password.P>48&File name:Pw2 P2 ...@@9=MS Sans SerifP6Sour&ce:S!POhPP!P?Before you can export information to Microsoft SQL Server, you must specify the server, user name and password.P P P P P P P P P!P!1P!2P?38&Server:B!Px19 P?B Use &Windows NT authentication P?P Use S&QL Server authenticationPK_'&Username:Px] PKn(&Password:Pxl P?3&Database:!Px}IVP}&&RefreshP}2<&Advanced...P>48&File name:Pw2 P2 ...P>C8&Username:PwA P>R8&Password:PwP  P>4K User/System &DSN:!P2p:P2" N&ew... P>C- &File DSNPB PB ...P?UP>_8&Username:P] P>o8&Password:Pm P>38&Server:Pw1 P>B8&Username:Pw@ P>Q8&Password:PwO P>48&File name:Pw2 P2 ...P2F&Properties...PDF&Load UDL file...ȀrCreate DatabaseMS Sans SerifPP"Specify the name and properties of the SQL Server database.P P).&Name:P8'{P9.Data file &size: P87-P}7 Bmsctls_updown32Spin1Pi;MBPH.&Log file size: P8G-P~I msctls_updown32Spin1PiJMBP)]2OKP^]2Cancel@@ =MS Sans SerifP@ P8B, &Server name:B!Pr@J P6Q Use &Windows NT authentication P6_ Use S&QL Server authenticationPBo#&Username:Prm PB}"&Password:Pr| P6X@@ =MS Sans SerifP@ P8B,&Server name:!Pr@JP@. LS&canning ... P6Q Use &Windows NT authentication P6_ Use S&QL Server authenticationPBo#&Username:Prm PB~" &Password:Pr| P6X@@=MS Sans SerifP@P8B7&File name:Pr@ P@ ...P6XȀ Scanning OptionsMS Sans SerifPP(Specify how objects referenced by the DTS package should be related to catalog metadata scanned into the Repository.P!P( H&Resolve package references to scanned catalog metadataP(8Which catalogs should be scanned? P(C M&Use scanned catalogs if already present in repository P(P N&Scan all referenced catalogs into repositoryP(`Specify a scanning option. P(k OScan &catalog if not already present in Repository P(x PScan catalog &always P@2OKPu2Cancel@@ =MS Sans SerifP&Create destination objects (tables, views, stored procedures, constraints, etc.)P4 &Drop destination objects firstP4# &Include all dependent objectsP2 C&opy data P4@ &Replace existing data P4O &Append dataP_ m&Transfer all objectsP^I*S&elect Objects...Po l&Use default optionsPoI=O&ptions...PB&Script file directory:PYP...@@ObjectsMS Sans SerifP P z !Show all &tablesP Pz "Show all &viewsP( P'z #Show all stored &proceduresP P t $Show all &defaultsP Pt %Show all r&ulesP( P't &Show user-defined data t&ypesP8&Objects:PBg'DimensionDataCtrlP2C&Select AllP=2D&CheckPs2EU&ncheck@@OptionsMS Sans SerifP3Security optionsPA PP7 )Transfer database &users and database rolesP7% *Transfer SQL Server &logins (Windows NT and SQL Server logins)P74 +Transfer &object-level permissionsPD,Table optionsPAIPRrP7R ,Transfer &indexesP7a -Transfer t&riggersP7p .Transfer &full text indexesP7 /Transfer PRIMARY and FOREIGN &keysP7 1&Generate Scripts in UnicodeP8Quoted identifiersPAPP7 0Use &quoted identifiers when transferring objectsȀDataMS Sans SerifP Source:P,-StaticPDimensionDataCtrlP2OK@@ =MS Sans SerifPGWhenP! h &Run immediatelyP &Create DTS package for replicationP! HSc&hedule DTS package for later executionP ...P-(PK7SaveP!Wj &Save DTS Package PW .S&QL Server Pe /Re&pository Pt 0&File@@=MS Sans SerifPPP>You have selected "Microsoft SQL Server". Before you can export information to Microsoft SQL Server, you must specify the server, user name and password.P2F&Properties...PDF&Load UDL file...(h9wwwxHHddddFvffdHhh``wwwww|wwthhHfhFFHHd`gww~wwwwww|wwwdhHhdFdhHlwwwwwwwwwwwwwwlhƆFdhhdhFhwwwwwwwwwwwvlhhldhFHdd`G|vdwwwwwwwwwvȇfhfffhHfHhB$txhȄHwwwwhfhhhhfƈ(( $xl@@wvHhl(*6:((( (xGHfhhhv688$ȄHHȆƈ:6`(thHEvHhllhƆb`d@xxhEhhHhHdhdžDHdzx*h2FBHBhHGtfh&fhh((8(hF`dHx`HHHhȆ(hFFdwwwwhhhlhl(26FFh`hBGH@Ewwwwhlfdh((hlF$(Dwwwwdbhhhh2((c(hdFBHBxwwwF8l(lh((8(8#((((((FhhdB@x@wwp((hhh,hhfffc(#Fd$Hx@wh("bhlhhfƌd2&FddH(( hllhhFhdd$$􂂈(((hfhxfd:hlhFhB`vȌ||l,hfldfHt((,~gffl((llhfFF&FB#b&fxxxx~gggglhhhhllHhhF$h((wxwxxvhllhlhƆFhBH B8wwx~ww~wwww|vxvllƆFBDxw~wwwww~w~wwww~hhlhhƆFHhBwwwwwwwww~www~wwww~hghhhlllhFfBFwww~wxwwxwwwwww~ww~wwwx|vl|hƆhhlhFHhwww~wwww~www~w~wwwwwwwww|~xlhfvhlhhlFHwwwxw~ww~wwwwwwwww~wwwwwx|l|hƆƌddh$`x~wzwwwwwwwwwwwwwww~w~w|whƌhfvgllfHwwwwwwwwwwwwwwww~wwww~~w|xΆvlhfhFF`wwwww~wwwwwww~wwwwwwwwwwwhƆlhƆlƆHwwwwwwwwwwwwwwwwww~wwwwwwwƆhnhlhhlhFF wwwwwwwvwwwwwwwwwww~~wwwwwwglhf|wwwwwwwwwwwwwwwwwwwwwwwwwvghnfvfFHBwwwwwwwwwgw~wwww~wwwwwwvv|Ɔhhfwww~wwwwwx~wwwwwwwwwwwwwwww|hlƆΆlhFwwww~wwwww~wwwwwwww~wwww~w~xhƆhlhFHwwwwwwwwwwwwwwwwwwww~ww~ww~xh診hlhƆhfƂ~wwwwwwwwwxwwww~wwww~v~vzzgghlvƆ#(dhwwwwwwwwwwwwwwwww~wwwwwww~gh8Ǝhllhh((wwwww~wwwwwwwwww~xwwwwwgvhkjz::gghhv hGw~wwwwwwwwwwwwwwwg~wwfhf|fvc'wwwwwwxwwwwwwwwww~vzvxfvf((((dwwwwwwwwwwwwwwxw~wwvjzvfȪFwww~wwwwwwwwwwwww~hjjzzxf2((dwwwwwwwwwwwx wwwwhxȇjhx3hHwwwwwwwwwwwwhwwwwwwwxghjzzzx(((((ww~wwwwwxwwwwwwvvxhjjzzxz8$hGxwwwzwww~wwwwwwwwwwwx~gȈhhzz2($wwwwwwwwwwwwwwwwt wwwxwwvxȈhjvzzzzz(2(ldwxzwwzwwwwwwwwwwx@wwwwwwwxvzzxw:8(2h(wwwwwwwww~w~wwwww7wwwwwhzzjzzzx(,GxwwxwwwwwwwwwwwwwwwwwwwVhxwzxhz(((H$wwwwwwwwwwwwwwwwww{wBhHȈgjhzxz((&`fxwwwwwww~ww~wwwwwwwwwx$hȈg8zzzzvzzzrHwwwwwwwwwwwwwwwwwwwwwxFjhzzzzh#F,qwwwwwwwwwww{wwwwxy99y0 HzzzzgjzlhhFq?wwwwww~wwwwwwwwwwwFHjvzgxzzzzfH'Qwwwwwwwwwwwwwww~w{w dhjzzzzzvjhdwwwwwwwwww~wwww{wwwwwwx97fzghzghw1wwwwwwwwwtw$7wwwwwwww{w7(jꇧjzzzzvzjzxFwwwwwwwww~wwwwxwwwwwwwhhjzhgvhw?wwwtwxgwwwwwwwwx(hzzzxvzxhwywwwww|7{wwwwwwwwwzjjghzxvzzzzjjqwwwwwwtwwww{www9jjhjzzxzzzxhhxwY1wwtv7wwwwww~jzggjzzzjxwwwv'wwwwww9jhhzzzzzxzzxwqwww{wwwsy9?jhgg~z!?wp7wwwww99;hgjzxg 觇ww7{{wy7hfjjzzzzzzvzxww97?jgꆧzgb(zxxwy99919x|vzhzzzzv`vzzww9wwwwx9993xjjjzvzxjwzxwwwwwwwwwwv99LJjvjv`(wzxwwwwwwwww{wxʊ9999ȇʆj訨 xww!swwwyww{www茇c9991xvjzv (xw{wy{wwwwʊ99?xjjzz`czxwvzxwwwwww{wvz999x誆fzhz~(xx777wwwwy^|v9997wxʆz(xzx 8zx7{wwwwu93|p7zx7777ww98u誈xhxxjzhj`7s8x!(8zzwLjNJz99993|xv觧b(訧覊y9xy8vs?HȌ訨j`hh j99<|טȈLJvjz(z˓3k9Ȉ|觨( &zggj`gy9999831|xȈȌ|xvzzxzhf6zxs998x|vjzh觮js99;93;wxȌxx~j`(h(zu3;sswwxȈȈhzbzh('vjjy99{9993wHȇx|vzz&zvzv9991;s99wwLjȧgꆨj`&vh(jvY9399879w|gcꊊjb (觨w9999393;wxȌxxxxwz jh (ꊊzw9997wwȌ|x|xx`(j` bjjx93wȈx|xghjzx9999998w{ȈȈxNJzzzhjjb(y98331xxLj||vw&zvgz998ww|xNJvzv"j6zb(zhjj99j99898wȇxLJgzxh73j9891wxxgxjvz覦hjh;9:jW983ww|x|Ljxx|~ &h7Ǩhz999wwwvx|xLJxggh`(h999DžcVzw|tw|zx('79v|zc3ww||x|vzxj799|899999ww|xwwjzzzczx99997wwnjnj|xzcy997^NJs88wȇȈ|xxxwv9xzWǨj9391||x|ȈȈwxw~{ȧ798|xhx|LJww999xw9ٶ3~xnj|xȈnjwww˓93j999?w|||gxLJgwwwy997939;999913txx|xgvX9389;wwȌ|x||x|xxxLJy997933993wwwȇLjx||xLj9383wxȈȈxLJxx|w9383s7wwwȈxȇxxxLJwO999993897wwȌx||xx|wLj93s87wwwxȇLjx|x|xy999993wwzHLjLJLJǎwLJ;wwwȈx||wv|w993wwwwȌȌ|LJLJwtyww~&&wȈȇLJx|wxwȏwwwv8 'wȈxLJxwwGwwb hb`'HȌȈLj||x|wLjwCHb(ȀHxgvx|w|wv& 'xȈȈȌx|||x|x|wr(&`ȈxxLJw`$ $ $ ȇx~njwx& h hxȌȈ|xȏv C` (hȇ|xvxrb("$ $$tȈȇLJx((bBȈȌFHx "b*b( $ $xFx@hh&bb(LJȀ @Hxxr"b&&"BȈHp@ȀGDrh"&**" bB|Ȉrz'" xxLj@xȌ&jfcf&(" !xhȄȈ&*(&"`bxxȈHw*bb$ /x|wȄbhb(&(wj6(&"xwbbb$'z*j&(&rjbf!f&#{7(;3;;33;;33;;33;;33?((OLDDDDDDDDDD@(((xwpxwpxwpxwpxpP P(wpwwpwxDDpyxpwxpwxwxLLLww($@3333330;;0;;0;;0;;0;;;08;;0;0;;0;;0;;0;;0;;0L($@;8;0L($@3333330;;0;;0;;0;;0;;0;;0;;0;;0;;0;;0;;0($@(wwwwwpppppppppppp( wwwwwxwwwwwwwwwwppwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwxwwwwwww( wwwwwwwwwwwwwwwwwwwwwpwwwwwwwwww wwwwwww;??;;30wwwwwx330wwwwwx;;??;;330wwwwwx330wwwwwx;;??;;330wwwwwx330wwwwwx;;??;;330wwwwwx330wwwwwx;;??;;330wwwwwx330wwwwwx;;??;;330wwwwwx330wwwwwx;;??;;330wwwwwx330wwwwwx;;??;;330wwwwwx330wwwwwx;;??;;330wwwwwx330wwwwwx;;??;;330wwwwwx330wwwwwx;;??;;330wwwwwx30wwwwwx?0wwwwwxwwwwwxwwwwwwwwwwwwxwwwwwwwwwwwwwwwwwwwwwwwwwwwwww( wwwwwwwwwwwwwwwwpwwwwpwwwwpwwwwpwwwwpwwwwpwwwwpwwwwpwwwwpwwwwpwwwwpwwwwpwwwwpwwww pwwwwDL@ pwwww@pwwwwbDDpwwwwh"d pwwwwf,pwwwwof pwwwwowlFFpwwwwLf pwwwwv""&pwwwwftbopwwwwfowwwwxwwwwwwwwwxwwwwwwwwwwwwwwwwwwwwww( wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwpwwwwwwwwwwwwpwwwpwpp wpw wpp wppwwpp wppwpw wp wppwppp p  p𻻰p p p𻻻pppw|ww|wwww|wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww( wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwpffpwwwwwwff`nwpf`ww`nwwwwwwwpwwpnwwhwwwwwwwpnfwhpwwwxpwwwwxwwwwwwwwwwwwxwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww(tDDDDDDDD(DDDDDDDDDDDD(;:  wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww(94                                       y     p        p x x    y   y      y    y   p    x y p y p  y p    (0fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff`fffffffffffffffffffffffffffffffffffffffffffffffffffff`fffffffffwffffffffwfffffffwwfffffffhwwwwwwwwwwwwwffffffffwwwwwwwwwwwwwxffffffffhwwwxfffffffffffffffffffwxffffffffffffffffffffhxffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff(𻰻 𻻻𻻻 𻻰   (𪪠𪪠(𙙙  𙙙("/""/"/""((DDDDDDDDDD(   (wwwwwwxwwwwwwwwwwwwwwwwww(333333     (pp(~p~p(wwwwwwwwwwwwwwxwwwwwwwwwwwwwwwwwwwwwwwwww(wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww333333     wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww(wwwwwwwwwwwwwwwwppppppppppDDDDDDDpDDDpwwwwwwwwwwwwwwww(wwwwwwwwwwwwwwwwwwpwwwwwwpwwwwpwwwwwwwwwwwwwwwwpwwwwpwwwwwwwwwwwwwwwwww(wwwwwwwwwwwwwwwwwwwwwwwwpwwwwp~pww~pwwppwwpwwpwwpwwwwpwpwwwwpwpwwwppwwwwwwwpwwwwwwwwwwwwwwwwwwwww(wwwwwwwwx   w( @0;300;3030;3;3303303003 ; 3300333 33; f`0  008; 0xffhfwwwf``` ff` ff`ff` f`   ßAU U!C O뢠U O /9 (x?D0 @@C?( 03 3;00; 0h`; `f`` f !P ! r7# (( @wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwppwwwwppwwwwDDDDDDDD@wwDDDDDDDDOwwDDDDDDDD@wwwwwwwwwwwwwwwwwwwwwwwwDDDDDDDDDGwwwwwwDDDDDDDDDGwwwwwwDDDDDDDDDGwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww( OLDDDDDDDDDD@ (( @       (  (( @   DHH( ( (`l( ( ` "" " D  " ( 6c " 8c0"L` 33?L$ 0"""B? ?"$@c"$;?"H; (;?0?0333?cqx||97?@???8?@ ?)( OLDDDDDDDDDD@ (( @  w30s3w30s3w3033sp0 0 000  3 0;0330px|>>ǁ`??  ( @  bx wjx w bwxwxw x bw x bww xpwpxpwxwwxwwwpppA04~?8 @  ( @DDD@DDD@Dppppwpppppppppp `  ( @pwwwwppwpwpwpp pp pp xpp3; wp;px; ;;  ;;0????( 7 p p3; ;p; ;;  ;;0?  ( ( @00;03000;;3333000;;3333000;;3333000;;3333000;;3333000;;3333000;;3333000;;3333000;;3333000;;333303   @?}@}@}@}@}@}@}@}@}@}@UUUU_UU? ( ;3;;33;;33;;33;;33?? (( @pwpwwpwwwpwwwwpwwwwwpwwwwwwpwwwwwwwwwwwwwwpxwwwww{wwwwwpwwww{{{{wwwpw{{{{{{wpwp w{{{{p8 wx{{ppwxp {{ xpw{wp {{ wp{{xp{??>~`Pa0 !`?0 37( xxxxxpxp {{ppp?? (( @pDwDD̙p̉w|ɘww|ϙwxwwppxwwwwff`nwpffw`nfwwnwwwwnfwwfhwwnpfwwpwwwwwww????( f`nfff`nnnhnf !_{ (( @wwwwwwwwwwwwwwww̏x?( wwwwpppppppppp (( @ ???????? ( @fff`fffff`vvfff"f`gggfb"&f~~vvv""&f`gg""&f`~~~~~v""&ff"""ff~~~~r22""ff`##""&f`~~~~s22"3ff`">##".6f`~~~".222f`b2."23"f`~~~~"">""&&`"""""f`~~~br""""""""""&~~v""""" "."""" ~~~"""""""""" ~~r"" `xDDDDDDDDDDDODDDDDDDDDDD@??? ( @  ?( xwpxwpxwpxwpxpP P  3C_ (( @330;;33330 3333 ;;33333 3333 ;;333333 3333833 ;;33333330 33338330 ;;33333330 33338330 ;;33333330 33338330 ;;33333330 33338330 ;;33333330 33338330 ;;33333330 38330 333333303303333308330 333330 3383300303033303333333030 3 33( 3;;33;;33;;33;;333w? (( @00;03000;;3333000;;3333000;;3333000;;3333000;;3333000;;3333000;;3333000;;3333000;;3333000;;333303   @?}@}@}@}@}@}@}@}@}@}@UUUU_UU? ( ;3;;33;;33;;33;;33?? (( @wwwwwwwwwwywwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwxwwwwwwpwwwwwwwwwwwwwwwwwwxwwwwwwpwwwwwwwwwwwwwwwwwwwwwwwxwwwwww( wwwwwwwwwwwwwwwwwwwwwwx (( @xtwwwwwwxLLLL@Htwwwwwxwwwwww(   (!( @pw;?DDD@ ?LL$DC ?bL0;L", ?l""L?,"" ?l""l;;|""& wpglȆb""# wvr"""";wwg"""#x"""#pw"""#pwvr"F#wx$rd,"; ",0p""F$$334p("""" 4,""""""""("&(h?`   ??(  "(#( @wwwwwwwwwwwwwwwwwwwywwwwwwwywwwwwwwwwpwwyppwwyxwwpwywywxpwywwwxpwywwwx̏pwwwwxpwwwwwx̏ppp̏pw"wwxpwww̏pwwwwp̏pxpwppwwwwxwwwwDDHwwwȈwwwOxwwwwwwwOxwwwwwwwOxwwwwwwwOxwwwwwwwOxwwwwwwwxwwwwwwwwwwwwwxwwwwwwwxwwwwwwwwwwwwwwwwwwwwwxwwwwww(  $(%(/&`?>>?/&( @rwwwwwwzwwxxwwwwwwwwwww̏̏̏̏̏wwwwwxwwwwwwwwwwwDDDDDDDDDDDDDDDDDDDDDDDDDDD '( @DDDDDDDDDD@@@@@@@@www@LGw@www@www@www@www@www"""""""""(@www"""""""""(@wwwwwwwwwwwww@wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwppwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww( @@Gx@wxwx((((@wwwwwwpwppwwpww (()}Ansi}Unicode}DOS/OS2|{Carriage Return}{Line Feed}}Ansi}Unicode}DOS/OS2=><>=<=<>likeANDOR=><>=<=<>!AND!OR#=#>#<#>=#<=#<>RIFF.AVI LISThdrlavih8G\AN<H3ȅXLISTstrlstrh8vidsRLE @B('strfh(<?vedtJUNKLISTv$movi00dc(                                                                                                                                                                                                                                                                                                                                              !                               "                             !                                                                                                                                                                   00dc$## % %$#        00dc$$$$$$%%"&      00dcR$$ $ $ #))(""           &&&00dc' & # # # # " "  # $  $  $  % % % & & & 00dc\. , * ( ' ' ) *  *  + +  +  ,  ,  ,  -  -  - 77700dc$6 4 2 1 1 3 4 4 5 5 5 6 6  6  7  7 7  CC00dc&= < > ? @ @ A A A B B B C  C   C  RRR00dc$L K M N O O P P P Q Q Q R R  R  ```00dc Z  Y [ \ ] ] ] ^ ^ _ _ _ `  ` `  nn00dc$h" g i j j j k k k m m  m  n n  n ~00dcv# v v v v v w w x x y  }  ~  ~ ~ 00dc{# { { { | | | } } } ~      00dc $                00dc<#                00dcX"                  00dc                        00dc                         00dcz                          00dcr                           00dcb                      00dc8                              00dc                                  00dc                00dc00dcidx100dc(00dc400dcR00dc` R00dc 00dcB \00dc $00dc&00dc$00dc, 00dcT$00dc00dc00dc 00dc<00dcX00dcn00dc00dcz00dcr00dcb00dc 800dc8" 00dcL#00dcb$00dcl$RIFF8AVI LISThdrlavih8k< (?^?llLISTstrlstrh8vidsMRLEk@B<4!strfh((AvedtJUNKLISTȍmoviLISTrec 00dc m c l  [ l  Z l Y g  Y f Y f  Z f  W g V h U h U g  V f  W _  Y ^  X Y   W X    V W V W  V X   W Y  \ Y   \ V  \ U  ] U  e U  e V e W f Y  i X  i W h W g X g Y   h Z   i _ n ` o LISTrec 00dcLISTrec 00dcm j  i  i g  f f  g d a  _  q ]  V   R   T  T  U  W  X  V U  U  U   U   U  V   X V V V X Y  Y  Z  ] ^ LISTrec 00dcLIST2rec 00dc&o j  j  h  gg d  _   [   X US S K   I    J      L    L MV W   U    U     V   jV U  U  W  V  V  W X  Y Z  [  ^ LISTrec 00dcLIST\rec 00dcPm l i  h h  f  Y  V  T  P L  J    J   B     B     A    B     D D  V   V   W     V U U UU  U  V   W   W W XZ  \  [  ` LISTrec 00dcLISTxrec 00dclm j  i  i g  f   P   N  I   F    D    V   B    ;     7     9   9   :   <  X  V U  U  U   U   U  V   X V V V X Y  Y  Z  ] ^ LISTrec 00dcLISTrec 00dc|o j  j  h  gg I   D    @    =   :  8   8  0    .      /      1    1  2V W   U    U     V   jV U  U  W  V  V  W X  Y Z  [  ^ LISTrec 00dcLISTrec 00dcm l i  h h  f  >   ;  9   5   1   /     /    '      '      &   ! '    " )# )  V   V   W     V U U UU  U  V   W   W W XZ  \  [  ` LISTrec 00dcLISTrec 00dcm j  i  i g  f % 5  $ 3 $ .   +    )    ;   '                 *   +   , !  X  V U  U  U   U   U  V   X V V V X Y  Y  Z  ] ^ LIST8rec 00dc, r ^ j  ] i  \ i \ i  X j W . 9  V - 2  V - . V  + W  ) X  (  X  )  W  #  V     U   U 3   V 4 ! Z 5 $ Z Z   Y V  Y U  Y U    Z V  b W  h X  g X f W e V e V  f V j W j X  i \ i \  i ]  j ^ r LISTrec 00dco j  j  h  gg. .  - )   - %     "                         3    4  5 V W   U    U     V   jV U  U  W  V  V  W X  Y Z  [  ^ LISTrec 00dcLISTrec 00dcm l i  h h  f 7 #  6   6  '   &   &     &    '       (       )      <     = >   V   V   W     V U U UU  U  V   W   W W XZ  \  [  ` LISTrec 00dcLISTrec 00dcm j  i  i g  f @   ?  ?  0    /    /    /     0     1     2     E   F   G   X  V U  U  U   U   U  V   X V V V X Y  Y  Z  ] ^ LISTrec 00dcLISTnrec 00dcbo j  j  h  ggI   H    H     9   8  8    8   9   :    ;      N   O P V W   U    U     V   jV U  U  W  V  V  W X  Y Z  [  ^ LISTrec 00dcLISTNrec 00dcBm l i  h h  f R   Q  Q   B   A   A    A   B   C    D   W   XV  V   V   W     V U U UU  U  V   W   W W XZ  \  [  ` LISTrec 00dcLISTrec 00dcm j  i  i g  f [   Z  Z  K     J    J   J   K   L   M   X  W  W  X  V U  U  U   U   U  V   X V V V X Y  Y  Z  ] ^ LISTrec 00dcLISTrec 00dco j  j  h  ggh  f   e   T  S S   S T  U   V   Y  W VV W U   U   V  j V  U  U  W  V  V  W X  Y Z  [  ^ LISTrec 00dcLISTrec 00dc m c l  [ l  Z l Y g  Y f Y f  Z f  W g V h U h U g  V f  W _  Y ^  X Y   W X   V W V W   V X  S Y   P Y  N V  N U   N U   O U   Q V   S W  U Y   W X  i W h W g X g Y   h Z   i _ n ` o LISTrec 00dcLISTNrec 00dcBm j  i  i g  f f  g e e  f  z f  _   Z   Z  X W   W  X V U UU    U    U   V     X   V   V V X Y  Y  Z  ] ^ LISTrec 00dcLISTlrec 00dc`o j  j  h  ggh  f   e   e ee e]  Z    Y     Y   W  V V  W  U    U    V    j  V   U    U   W   V  V  W X  Y Z  [  ^ LISTrec 00dcLISTrec 00dc|m l i  h h  f f  f g f e e   e  ]    \    Y   X      X V   V    V    W     V   U   U   U  U     U   V   ! W   W W XZ  \  [  ` LISTrec 00dcLISTrec 00dcvm j  i  i g  f f  g e e  f  z f  _   Z   Z  X   W   W   X    V   U   U    U     U     U    V   & X ' V ( V V X Y  Y  Z  ] ^ LISTrec 00dcLISTrec 00dco j  j  h  ggh  f   e   e ee e]  Z    Y     Y    W  V V   W     U     U       V     j  V   U  0 U  0 W  1 V  V  W X  Y Z  [  ^ LISTrec 00dcLISTrec 00dcm l i  h h  f f  f g f e e   e  ]    \    Y   X    $ X# V  # V     V     W      V   U   U $  U%  U  8 U  : V   < W   W W XZ  \  [  ` LISTrec 00dcLISTrec 00dc|m j  i  i g  f f  g e e  f  z f  _   Z   Z  X  / W  , W  , X    V   U   U    U   $  U   -  U  .  V   A X B V C V V X Y  Y  Z  ] ^ LIST"rec 00dc r ^ j  ] i  \ i \ i  X j W j  V f  V e V e W f X g  X h  W b  V Z   U Y  U Y  6  Y 9  Z 9  Z   )  V  (  U  (  U    )  V  2  W  9  X  9  X K  W K  V L  V  f V j W j X  i \ i \  i ]  j ^ r LISTrec 00dco j  j  h  ggh  f   e   e ee e]  Z    Y     Y   6 W 7 V6 V '  W   '  U    ) U     )  V   /  j7  V :  U  K U  K W  L V  V  W X  Y Z  [  ^ LISTrec 00dcLISTrec 00dcm l i  h h  f f  f g f e e   e  ]    \    Y   X    ? X> V  > V   1   V   0  W     1 V 4  U 6  U ? U@  U  S  U  U V   W W   W W XZ  \  [  ` LISTrec 00dcLISTPrec 00dcDm j  i  i g  f f  g e e  f  z f  _   Z   Z  X  J  W  G W  G X  9  V :  U  : U  ;  U   ? U   H U  I V   \ X ] V ^ V V X Y  Y  Z  ] ^ LISTrec 00dcLISTrec 00dco j  j  h  ggh  f   e   e ee e]  Z    Y     Y   Q W R VQ V B W   B  U    D U     D  V   J jR V U U  U  W  V  V  W X  Y Z  [  ^ LISTrec 00dcLIST rec 00dcm l i  h h  f f  f g f e e   e  ]    \    Y   X    XV  V   L V   K W     L V O U Q U Z U[ U  U  V   W   W W XZ  \  [  ` LISTrec 00dcLISTrec 00dcm j  i  i g  f f  g e e  f  z f  _   Z   Z  X  W  W  X  T V U U  U U  V U   Z U   c U  d V   X V V V X Y  Y  Z  ] ^ LISTrec 00dcLISTrec 00dco j  j  h  ggh  f   e   e ee e]  Z    Y     Y   W VV W   U    U     V   jV U  U  W  V  V  W X  Y Z  [  ^ LISTrec 00dcidx1rec 00dcrec 00dcrec 00dcrec 00dcrec  200dc&rec F 00dcR rec \ \00dch Prec 00dcrec x00dclrec V00dcbrec l00dcx|rec 00dcrec 00dcrec 00dcrec 00dcrec p#800dc|#,rec '00dc'rec T,00dc`,rec j,00dcv,rec 100dc"1rec ,100dc81rec 500dc5rec 5n00dc5brec N:00dcZ:rec d:N00dcp:Brec >00dc>rec >00dc>rec B00dcBrec C00dcCrec G00dc&Grec 0G00dcInitialize COM>Could not Create DTS Wizard Document. Check available memory.DTS Wizard Error3Session not created. Cannot get Schema informationProvider not initialized!Flat File Provider not RegisteredInvalid Row Delimiter4Must define row delimiter for delimited file format.HYou have provided an invalid file name. Type or browse for a valid file.(You have provided and invalid File Type.,You have provided an invalid Text Qualifier.bCould not open file for reading. Please close any other application that may be locking the file.Could not read file size@You must specify a delimiter that is at least one character longFormat error detected in rows: FOut of Memory. Could not create thread to do the data transformation.:An error occurred when performing the data transformation.3Successfully transferred %d table(s) from %s to %s.(GetNextRows failed to retrieve Providers$Unable to allocate memory for buffer<can't convert value><unknown status>&File: S&erver Name:aIn order to connect to Microsoft SQL Server, you must specify the server, user name and password.tIn order to connect, you must first choose the %s Database. You may need to provide a valid user name and password. DTS WizardIn order to connect to Microsoft Excel, you must first choose an Excel file. You may need to provide a valid user name and password.mIn order to connect to Oracle (Microsoft Driver), you must specify the server and the user name and password.WText files can be delimited or fixed field. In order to connect you must select a file.GSelect or create a Data Source Name (DSN) for the selected ODBC driver.ZBefore you can connect to %s, you must specify the server, the user name and the password.DTS Import WizardDTS Export WizardYou have modified the column mappings, and the create table statement may not match with the column mappings. Do you want to edit the create table statement?#Data Transformation Services Wizard*Data Transformation Services Import Wizard*Data Transformation Services Export WizardThe Data Transformation Services Wizard makes it easy to export and transform heterogeneous data. This wizard guides you through the steps to export data between many popular data formats including databases, spreadsheets, and text files.The Data Transformation Services Wizard makes it easy to import and transform heterogeneous data. This wizard guides you through the steps to import data between many popular data formats including databases, spreadsheets, and text files.The Data Transformation Services Wizard makes it easy to import, export, and transform heterogeneous data. This wizard guides you through the steps to import or export data between many popular data formats including databases, spreadsheets, and text files.Where would you like to import data from? You can import data from any of the sources listed below. Choose one of the following sources.Where would you like to import data from? You can import data from any of the sources listed below. Choose one of the following sources.Where would you like to export data from? You can export data from any of the sources listed below. Choose one of the following sources.Where would you like to export the data? You can export data to any of the destinations listed below. Choose one of the following destinations.Where would you like to import the data? You can import data to any of the destinations listed below. Choose one of the following destinations.Where would you like to export the data? You can export data to any of the destinations listed below. Choose one of the following destinations.You can %s the data now or schedule it for later execution. The %s can be scheduled on a daily, weekly or monthly basis using the SQL Agent.importexportSelect one or more tables to %s. You can copy the schema and data as is in the source table or click (...) to transform the data using an ActiveX script.You can choose the destination table to %s into. You can copy the schema and data as it is in the source or transform it using an ActiveX scripts. TransformSource DestinationColumn MappingsTransformations &Location:Results"Error saving package to the serverThe SQL statement is valid.Q2-byte signed int;4-byte signed int;4-byte real;8-byte real;Binary String;Boolean5'********************************************************************** ' Visual Basic Transformation Script ' Copy each source column to the ' destination column '************************************************************************ Function Main() %s Main = DTSTransformStat_OK End Function ,//********************************************************************** // Java Transformation Script // Copy each source column to the // destination column //************************************************************************ function Main() { %s return(DTSTransformStat_OK); } You have modified the transformation script. Do you want DTS Wizard to auto generate a default script for the selected language?You have modified the column mappings, and the script may not be valid. Do you want DTS Wizard to auto generate a default script?nCould not open the specified file for reading. Make sure that the file exists, and you have read access to it.Oracle ODBC DriverMicrosoft Text Driver Microsoft ODBC Driver for OracleMicrosoft Access DriverMicrosoft dBase DriverMicrosoft Excel DriverMicrosoft FoxPro DriverMicrosoft ODBC for Oracle SQL ServerSThe file you have selected has a size of 0. Select another file with a valid size.Visigenic 32-bit Oracle DriverSQL Server Demo 3.0 Driver8You must specify a valid file name in order to continue.You have chosen to %s from a file. You can copy the source file data as is or click (...) to transform the data using an ActiveX script.You have chosen to %s the results of a query. You can copy the query results as is or click (...) to transform the data using an ActiveX script.tThe spreadsheet may contain multiple worksheets or ranges. Select the worksheet or range that you would like to %s.Preview of: %s#Error Scheduling package on server.&Server:Scheduled package on Server.Microsoft Paradox Driver Text FileUdtswiz [/f<filename>] [/i] [/x] [/r] [/s] [/u] [/p] [/d] [/y] n = use NT authentication f = file name to output the package to i = run import wizard x = run export wizard r = provider name s = server name u = user name p = password d = database name y = hide system databases NT authentication takes precedence over user name and password. Step NameStatus 23;300;200WaitingRunningCompleteError occurredNot runStartedSuccessfully transferred %d table(s) from %s to %s. Failed to transfer %d table(s). Double Click on the error row to get a detailed description of the error.&Cancel&Done Completing the DTS Import Wizard Completing the DTS Export WizardCompleting the DTS WizardUnable to logon to server %s with the specified user id and password. Specify your user id and password and try again. If you unsure of your login id or password, see your database administrator.9A serious error occurred when connecting to the provider..An error occurred when creating a data source._Unexpected error occurred. The provider has returned an error result without an error message. <default> <refresh>^It is recommended that you use a the Microsoft SQL OLEDB Provider to connect to SQL Server 7.0DatabaseServerTablesUsing(uses transform)In order to connect to "%s", you must first choose a Database. You may need to provide a valid user name and password. The database password can be specified in the Advanced options. Create Table Drop tableCopy Data from %s to %sStepTaskDelete from Table Package Error(local)Microsoft OLE DB Provider for SQL Server;Microsoft ODBC Driver for SQL Server;Microsoft Access;Microsoft ODBC Driver for Oracle;Text File;Other (ODBC Data Source);dBase III;dBase IV;dBase 5;Paradox 3.X;Paradox 4.X;Paradox 5.X;Microsoft Excel 3.0;Microsoft Excel 4.0;Microsoft Excel 5.0;Microsoft Excel 8.0;Microsoft FoxPro 2.0;Microsoft FoxPro 2.5;Microsoft FoxPro 2.6;Microsoft FoxPro 3.0;Microsoft FoxPro DBC;Microsoft Data Link;Microsoft OLE DB Provider for DB2w;MSDASQL;Microsoft SQL Replication Distribution Provider;SQL65Prv;DTSPackageDSO;DTSRowQueue;MSQLImpProv;MSDataShape;MSSQLServer Bulk Import Provider;MSPersist;DTSPackageDSO.0;DTSRowQueue.0;MSSEARCHSQL;SampProv;Microsoft Search Collator data source;Microsoft Search Context Index DSO;Microsoft Search Indexer DSO;MSDAOSP;Microsoft.Jet.OLEDB.3.51;MS Remote;ADsDSOObject;MSIDXS;:;Oracle ODBC Driver;Microsoft Text Driver (*.txt; *.csv);Microsoft ODBC Driver for Oracle;Microsoft Access Driver (*.mdb);Microsoft dBase Driver (*.dbf);Microsoft Excel Driver (*.xls);Microsoft FoxPro Driver (*.dbf);Visigenic 32-bit Oracle Driver;SQL Server Demo 3.0 Driver;Microsoft Paradox Driver (*.db );Oracle;2SQLOLEDB=Microsoft OLE DB Provider for SQL Server;kMicrosoft ODBC for Oracle=Microsoft ODBC Driver for Oracle;SQL Server=Microsoft ODBC Driver for SQL Server;All Files (*.*)@*@@%Microsoft Access Files (*.mdb)@*.mdb@dBase Files (*.dbf)@*.dbf@Paradox Files (*.DB)@*.DB@$Microsoft Excel Files (*.xls)@*.xls@%Text Files (*.txt,*.csv)@*.txt;*.csv@ Select FileSpecify Table Copy or QueryZSpecify whether to copy one or more tables or the results of a query from the data source.Select Columns<Select the columns that you want to copy to the destination.Select Source TablesYou can choose one or more tables to copy. You can copy the schema and data as it is in the source or click (...) to transform the data using ActiveX scripts.DSN Files (*.dsn)@*.dsn@"#********************************************************************** # Perl Transformation Script # Copy each source column to the # destination column #************************************************************************ sub Main() { %s return $DTSTransformStat_OK; } Choose a DestinationWhere would you like to copy data to? You can copy data to any of the destinations listed below. Choose one of the following destinations.Choose a Data SourceWhere would you like to copy data from? You can copy data from any of the sources listed below. Choose one of the following sources.Specify Column Delimiter|Now you must specify the source file's column delimiter type. You can choose comma, tab, semicolon, or any other character.Select Destination File Format`You must specify the file's format. Please select whether the file is delimited or fixed-field.Column PropertiesUPlease select the columns that you want transferred from the file to the destination.Select File FormatIn order to import the data, you must first confirm the source file's format. Please confirm that the file properties are correctly detected before proceeding.Completing the DTS WizardYou have successfully specified the information necessary to copy and transform the data. Review the selections below and click FINISH to start the transformation.Fixed Field Column Positions@Please specify the starting and ending positions of each column.Define Row WidthSince the data does not have row delimiters, you must specify the row width. Please move the red line below and position it appropriately.$Save, Schedule and Replicate PackageSpecify if you want to save this DTS package. You may also replicate the data or schedule the package to be executed at a later time.Save DTS PackagepYou can save the DTS package for re-use. You must save the package in order to schedule it for later execution.Specify Sort Order3Select the order in which you want the data sorted.Preview Spreadsheet DataThe spreadsheet may contain multiple Excel worksheets or named ranges. Select the Excel worksheet or named range that you would like to previewType SQL StatementZPlease type in the SQL query statement that will generate data from the selected database.Specify Query CriteriabSpecify the criteria that will be used to select rows. Click (...) to select a value from a list.NULL:{CR}{LF};{CR};{LF};Semicolon;Comma;Tab;Vertical Bar;<none>ANSI;Unicode;OEM(Double Quote {"};Single Quote {'};<none> Comma;Semicolon;Tab;Vertical Bar*Error occurred scheduling the DTS Package.JCould not allocate required memory to continue. DTS Wizard will now exit.DTS Wizard ErrorCYou must either run the DTS Package now or save it to a SQL Server. Connection &Table(s):1&Table(s) / Worksheets(s) / Excel Named Range(s):Script Files (*.txt)@*.txt@ Save PackageSchedule Package SQL ServerSQL Server RepositoryFileDTS Files (*.dts)@*.dts@Invalid server name.Invalid user name.Invalid file name.GFile '%s' already exists. Do you want to add this package to the file?Select Objects to TransferYou can transfer tables, data, stored procedures, referential integrity constraints, security, and indexes. Choose the object(s) to transfer.Advanced Transfer Options Object Name30;30;270;100;TableViewStored ProcedureDefaultRuleInvalid database nameInvalid database sizeInvalid database log size<new> USE masterIif exists (select * from sysdatabases where name = '%s') drop database %s2declare @dbpath nvarchar(512) select @dbpath = substring(filename,1,len(filename)-10) from sysdatabases where name = 'master' exec('CREATE DATABASE %s ON ( NAME=N''%s_dat'', FILENAME=N''' + @dbpath + '%s.mdf'', SIZE=%dKB) LOG ON ( NAME=N''%s_log'', FILENAME=N'''+ @dbpath + '%s.ldf'', SIZE=%dKB)'),sp_dboption %s, 'trunc. log on chkpt.', TRUE,sp_dboption %s, 'select into/bulkcopy', TRUEUser-Defined DTUnknownSelect ObjectsTransfer SQL Server ObjectsTransfer SQL Server ObjectsSYou cannot transfer objects when the source and destination databases are the same.LocationPreview Source Data>Could not load "semcros.dll". Unable to display the schedule.&Select FolderBYou cannot replicate a DTS Package without immediately running it.4You cannot schedule a DTS Package without saving it.DTS package descriptioniFailed to transfer %d table(s). Double Click on the error row to get a detailed description of the error./Successfully transferred objects from %s to %s.#VBScript (*.bas,*.vbs)@*.bas;*.vbs@Java Script (*.java)@*.java@Perl Script (*.pls)@*.pls@)Failed to transfer objects from %s to %s.In order to connect to %s, you must first choose the folder for the database. You may need to provide a valid user name and password.(up to first %d lines)&Could not get a string from a ClassID.XIncomplete where clause. You must provide a complete where clause in order to continue.EUnable to determine the SQLServerAgent's state on target server '%s'.}The SQLServerAgent on target server '%s' is stopped. Make sure it is running during the scheduled execution of this package.QIn order to connect to Microsoft Data Link, you must first define the properties.LA serious error occurred during defining the Microsoft Data Link properties.Unable to create a data link.!Unable to create IDataInitialize.Prompt data source failed.SIn order to connect to SNA Server, you must first define the connection properties.{The SQLServerAgent on target server '%s' is paused. Make sure it is running during the scheduled execution of this package.The SQLServerAgent on target server '%s' is in an indeterminate state. Make sure it is running during the scheduled execution of this package.3Could not create an instance of the Run DTS object./Could not create an instance of SQL DMO server.(Could not create an instance of the Job.-Could not create an instance of the job step.u%d step(s) succeeded and %d step(s) failed. Double click on the steps that failed to see detailed error information.The license for the installation of Microsoft SQL Server on your source and destination connections does not permit the use DTS to transform data. Refer to your license agreement for more information.GNo table selected. You must select a valid table in order to continue.MNo provider selected. You must select a valid provider in order to continue.CourierError Description: Error Source: IYou cannot specify an user password without specifying an owner password.Unable to get licensing information. Please make sure that licensing is correctly installed in the source and destination servers.The maximum width for all columns, supported by the operating system, has been exceeded. Not all of the columns will be accessible/visible.8 000'040<0Q0V0[0`0j0s00000001e1111