Lun

hi, i'm trying speed ad hoc cube browsing in excel 2007. have periodic snapshot fact table with mainly last child measures. fact table has about 1.8 million rows. main dimension holds account information, and has 40,000 rows. capture change scd type 2 approach. to speed ad hoc cube browsing in excel, should separate fast changing attributes in dimension table, provided they're not queried, separate dimension table? have 6000 distinct accounts, , the 'status' attribute forcing new row. this is how a chopped down version of dimaccount table looks currently, showing 'loantype' attribute, doesn't change, , 'status' attribute, changes frequently: dimaccountkey      accountreference      status                               loantype ...

iam using ms sql server reporting service 2008. time below error when report previewed in sql server business intellegence ide. error: getting object '/xxx.rem' has been disconnected or doesn't exist @ server i using stored procedure in report , if executing the sp directly in sql server mgt studio same parameter, taking less 2sec in visual studio getting above mentioned error after 5-10 min. i dropped sp , created again , started working fine without modifiction report rdl file. same problem repeated again now.  what might problem ? hi, i think running issue has been reported @ our connect site: https://connect.microsoft.com/sqlserver/feedback/details/472833/report-designer-error-object-has-been-disconnected-or-does-not-exist-at-the-server?wa=wsignin1.0 the issue fixed in 2008 r2, according connect link. thanks, cathy miller microsoft online community support SQL Server ...

i continue have trouble getting subreport display within main report stored in sharepoint foundation 2010 document library.  report server configured in sharepoint integrated mode. a technet article, specifying paths external items (report builder 3.0 , ssrs) [http://technet.microsoft.com/en-us/library/dd220423.aspx], includes following instructions: when specify path external item in dialog box actions, subreports, or images, can browse directly report server , select item. browsing item , selecting directly recommended way specify drillthrough report or subreport. way correct parameter names available in drop-down list when specify report or subreport parameters. when change item path point different item, must manually update correct parameter names , values needed. on report server configured in sharepoint integrated mode, must include file extension .rdl. path can 1 of following: a full path item.  on sharepoint site: must specify report name in expres...

i trying sign out 1 user , sign in user on visual studio 2010 tfs cloud connection.  when click signout link, opens window, closes , still logged in. this in connect server window. sign out , exit vs. restart , try again. if not work, exit vs , use steps here clean cookies - should it: http://aka.ms/tfservicevsconnection trevor hancock (microsoft) please remember "mark answer" replies help. Archived Forums V  >  Visual Studio Team Services

i using "built in" ssis logging functionality using sql server log provider, , persisting log records sysssislog expected.  i have set package log on error, on information, on failed, , other events. however, message column never has more 72 characters.  message always truncated maximum length in sysssislog.message column, even through message text longer: executing query " exec mydb.dbo.blahblah_t_s...". above sanitized example.  how can full message ssis event stored in sysssislog??  thanks mcp-sql server 2k i not 100% sure, seems exists in ssis 2005 components logging, gets remedied sp. arthur my blog SQL Server  >  SQL Server Integration Services ...

hello - i'm working on dashboard several parts. 1 of these matrix. i've shrunk matrix down that, when renders, it's within page size. it's still causing blank page render after it, leaving me nice page 1, blank page 2, , nice page 3. it's driving me nuts...i think must have re-sizing matrix does, it's sucking real estate doesn't need end result. i've tried putting matrix in rectangle define area , setting page break-disabled true, shrinking matrix as possible ensure has plenty of room expand on existing page...i fresh out of ideas. i'd appreciate tricks try! thank -- donna well, happens, after posting question (two days of trying think of!), found answer - in report properties, set consumecontainerwhitespace true! , tadaaaa! page break gone. phew. hope helps else before go through own 2 days of trials. happy friday - donna SQL Server ...

hi all, i have multiple(say example 5 .xls files) @ particular location, , files having same number of columns same column_names too.... different records/data each of xls files. at same time have same number of column same column_name sql server table. so how can dump multiple xls files data single table @ single run? i thinking of using with:- one each loop container , 1 dft (having 1 excel source , sql server destination) can me approach? thanks regarsd, kumar what need steps     3- script task (scr) make connection string     4- copy sheet names of current excel file object variable     5 flc ( loop number2) loop through sheet object variables you can check http://dougbert.com/blogs/dougbert/archive/2008/06/18/excel-in-integration-services-part-2-of-3-tables-and-data-types.aspx to list of excel sheets can use scripts , prefer because have more control , can find more ways if google. in details have use .......      3-3333333333333333333333333333333333333333333333333333333333333...

hi all, long time ago, downloaded northwind , pubs databases microsoft website (i not remember the details of it)  and installed these 2 databases sql server management studio express of my pc (microsoft windows xp pro). tried learn an example of using "user instance" (source code was from book) on northwind database located in sql server management studio express.  find out that my northwind database has title , no tables @ all. if click on "+" in front of "northwind", got following error message:        microsoft sql server management studio express               failed retrieve data request.(microsoft sqlserver.express.smoenum)           additional information:          1 or more files not match primary file of database. if attempting attach database, retry operation correct files. if existing database, file may corrupted , should restored backup. (microsoft sql server, error: 5173)..   please , tell me how can repair northwind databas...

hello want know if there way send parameters in url operators. i have filter parameter:  config.addfilterparameterconfiguration("username", "user", "@username", typeof(string)); what want return data of 2 different users. can 1 user this: http://localhost/syncservicebroca/userscopesyncservice.svc/userscope/downloadchanges?username=luis i s possible use 'or' operator url can return data 2 users? thanks help... i think work fine: <synctable name="users" filterclause="[side].username = @username1 or [side].username = @username2"> but aware: there quite few things stumble upon when designing syncscope filters. important thing understand limitation of syncfx not support "partition realignment", when data changes in filtered columns (see here , here , here ). Microsoft Sync Framework ...

i have written application uses silverlight.js 2.0.31030.0 version.  i'm testing mac 10.5.6 on firefox , safari... same issue.  install graphic appears, doesn't seem hyperlink.  nothing happens when click on , no cursor change.  have ideas why link wouldn't work? when view rendered html source of web page containing silverlight plugin, see anchor tag wrapped around image?  if cursor isn't changing, leads me believe anchor tag missing.  should this: ... < param name= "minruntimeversion" value= "2.0.31005.0" /> < param name= "autoupgrade" value= "true" /> < a href= "http://go.microsoft.com/fwlink/?linkid=124807" style= "text-decoration: none;" > < img src= "http://go.microsoft.com/fwlink/?linkid=108181" alt= "get microsoft silverlight" style= "border-style: none" /> </ a > </ object > ...

hi guys, ok have line graph has 2 value lines each of value lines plot point every 5 minutes, want add event should show  at time value occured want label on graph( times event happened) value should match other 2 values regards curt  hi curt, from description, “adding event” mean adding series group or adding instance current series group? if former, afraid cannot achieved in line chart. example, current series group has 2 values: 2011 , 2012. if add series group has 2 values (europe , pacific), there 4 lines: 2011-europe, 2011-pacific, 2012-europe, , 2012-pacific. if newly added series group has 1 value, there 2 lines. in other words, there won’t 3 lines situation generated. if latter, means database changes , series group has 3 values now. in condition, can achieve goal setting line border width , marker type conditionally. example, want hide line newly added year 2010 , display corresponding data points. steps below reference: click series in ...

hello,   we implementing tfs and there methodology describing processes have follow during development of new features. initial work done on top of several word docs (vision document, use cases, test cases , on). create kind of workflow : 1. the requirements guy creates use cases doc; 2. the quality guy has review , approve use cases.     2a. if approved, architect starts turning use cases taks developers;     2b. if not, requirements guy receives "why not approved" doc , goes 1; 3. development guy picks 1 task , codes it; ... , etc.   since tfs has source code control feature, thought storing docs on tfs scc, not see how implement workflow control if docs on scc. perhaps i'm not using tfs right? better workflow on team project portal tfs creates? there drawbacks on storing docs on sharepoint instead of tfs scc? have guys experience on scenario this?   thanks lot,   gb the short answer tfs currently, whether use scc or wss, doesn't provid...

say have string looks guid: 'aa762c3a-1131-df11-a365-002219c5db51'. if start @ beginning of string, takes 9 ctl-rightarrow keystrokes end of string in ssms, because tab has stop before , after every '-' dash character. after while, feel i'm stabbing keys way many times around in ssms. in other editors, tab stop before each dash only, not before , after.  is there way change in ssms? or there key sequence tab more naturally through strings? thanks...   like in other editors: ctrl+end olaf helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * wenn ich denke, ist das ein fehler und das beweise ich täglich http://olafhelper.over-blog.de SQL Server  >  Getting started with SQL Server ...

i know workgroup edition not require having domain, after grow past workgroup size? various reasons we're not running domain , aren't soon, we'd move using tfs. possible? hi, the word "workgroup" has been overloaded has lead confusion. "workgroup edition" 5 user limited version of tfs, can run using active directory authentication or windows workgroup authentication. any version of tfs (workgroup, trial, or full) can use either active directory or windows workgroup authentication. see following msdn article running tfs against workgroup authentication:- http://msdn2.microsoft.com/en-us/library/ms252507.aspx so no - domain not required.  if purchase full version of tfs can carry on using workgroup authentication rid of 5-user limit on users comes "workgroup edition"... i know it's confusing - we've complained many times don't think marketing folks read newsgroups :-) m. ...

i got issue try execute ssis in aps.net , did not found answer on it. solve problem already? thank you hi tonychi2005, by default, can use dts object execute sql server integration services(ssis) package directly. however, in case, said tried run ssis job. little confused. mean have configured ssis job in sql server, , now, try execute job? if so, please connect sql server asp.net, , use stored procedure sp_start_job start specify job. anyway, following article details how execute ssis package asp.net: http://www.codeproject.com/kb/aspnet/ssis_dotnet.aspx if have more questions, please feel free ask. thanks, jin chen jin chen - msft SQL Server  >  SQL Server Integration Services

hi have 8 multi selects there default *all* is selected  in report, can i cerate 8 dataset or other best approach is there you need more clear requirement. 8 parameters have fixed set of values or dependent on data persisted in database? have parameters dependent on previous parameters selection? in general, preferred have 1 dataset of each parameter long discrete. if related, may use unionall , 1 data set , using filters, can manage. phani note: please mark post answered if answers question. SQL Server  >  SQL Server Reporting Services, Power View

i trying organise need websites , databases , using pricing calculator on windows azure website work out approximate costs.... virtual machines >  1 x sql server standard (xs)  £260.42 1 x sql server standard (s)  £260.42 1 x sql server standard (m)  £260.42 1 x sql server standard (l)  £260.42 only when @ xl price change - happens on several other items in calculator. £260.42 hi venturo, usually, can use full calculator work out pay cost , test, display different sql server costs based on vms @ http://azure.microsoft.com/en-us/pricing/calculator/?scenario=virtual-machines . if error still exist, you can contact support team creating support ticket at   http://www.windowsazure.com/en-us/support/contact/ . or can call 1-800-867-1389, monday through friday, 6:00 a.m. 6:00 p.m. (pacific time) speak directly consulting price sales staff. thanks, sofiya li sofiya li technet community support ...

this everything-on-one-machine type of install.  semi-unusual bit there sql server 2005 standard installed , it's supposed hosting database(s).  i've got prerequisites done satisfaction of "system health check", still fails following: "the required windows sharepoint services configuration database (sts_config_tfs) not located on team foundation server data-tier computer. proceed, must exit setup , uninstall windows sharepoint services. then, reinstall windows sharepoint services in accordance team foundation installation guide, , run setup again.". the install guide doesn't mention sts_config_tfs database, assumed it's expecting name of sharepoint configuration database, reinstalled sharepoint database name.  didn't work. so, um, do?  i've reached limits of documentation... -ryan / kardax ryan, you correct, tfs expects sharepoint configuration database called sts_config_tfs.  reason isn't mentioned in documentation tfs doesn...

i have combobox in silverlight application..                                                             <combobox fontweight="normal"                                                           grid.row="1"                                                           grid.column="4"                                                           x:name="ddlservice" ...

  i have separate distribution server - sql 2005.   my distribution cleanup job failing following error: executed user: <user>. not remove directory '\\<server>\repldata_bk\unc\lngokcsqlp003_bankruptcy_bk-smaller tables a-c\20071203122870\'. check security context of xp_cmdshell , close other processes may accessing directory. [sqlstate 42000] (error 20015).  step failed.   however error in agent log says this: replication-@rowcount_only parameter must value 0,1, or 2. 0=7.0 compatible checksum. 1=only check rowcou: agent distribution@rowcount_only parameter must value 0,1, or 2. 0=7.0 compatible checksum. 1=only  scheduled retry. not clean distribution transaction tables.   when log in agent service account (also account job running under) , exec following: exec xp_cmdshell 'dir d:\' there no problem.   i saw 1 other thread marked "answered" on here same issue, no answers.   can help?   thanks, deb try giv...

hi, we have case have $/project/trunk branched $/project/branches/mybranch/trunk. a new file got added $/project/trunk/file1.sql we noticed file1.sql not branched , not merge? is correct? seems should automatically have been part branch or picked part of merge. it seems did neither. what went wrong , how fix this? thanks. yes, calculating merge candidates entirely server side.  not sure if fix in 2008 rtm or sp1 yes.  2005 clients should not notice changes @ all. Archived Forums V  >  Team Foundation Server - Source and Version Control

i got report created vs2010, has group header set repeat on every new page, , group footer appears @ end of group. the report looks fine under browser, however, when report exported pdf, , once group footer has been shown on new page, group header not displayed on new page. eg ------------------------------------------------------------ page 1 group header title column 1 column 2 xx xx xx  xx xx xx group footer title page 2 group header title column 1 column 2 xx xx xx  xx xx xx group footer title page 3 group header title column 1 column 2 xx xx xx  xx xx xx xx xx  page 4 group footer title --------------------------------------------------- in above example, group header missing in page 4? anyway fix this? hi zancanelli_1, since have mentioned works fine under browser, means there nothing wrong original configuration. then, infer must caused pdf pagination.   as kno...

can me how checkin set of files (especially *.dll files) tfs local folder not mapped locally.actually having requirement set of projects once build created in build server have update output of build common assemblies folder in tfs.where assemblies used various applications.here using tfs 2010 build definition build automation. working developer in asp.net 2.0 i have figured out this  below code.by creating custom activity. tfsteamprojectcollection tfs = new tfsteamprojectcollection(new uri(tfsname)); // reference version control. versioncontrolserver versioncontrol = tfs.getservice<versioncontrolserver>(); workspace workspace = versioncontrol.createworkspace("tempworkspace1", versioncontrol.authorizeduser); // create mapping using team project supplied on command line. workspace.map(tfspath, path); context.writebuildmessage("sucessfully mapped folder " + path, buildmessageimportance.high); // files reposit...

some thread searches here conversion (downgrade) of sqlexpress database sql server 2000 trivial. haven't yet figured out efficient way of doing beyond using someone's database publishing wizard utility (http://www.codeplex.com/sqlhost) create sql 2000 compatible script, replete schema *and* data, running script against sql 2000 database (freshly created without structure). i've done smaller databases, larger ones tax , drain server resources , scripts have failed "out of memory" errors. we're putting more memory in sql 2000 server, may avert memory errors, there's still issue of server load. has since come or know of better method that's quicker, more efficent , less drain on server? tia, rick nevermind. able use 2000's dts in conjunction database publishing wizard. faster , easier on server than  insert scripts. SQL Server ...

hi, i've been trying set date format in sqlserver 2005 express setting language,  using sp_addlanguage article id 173907 have, seems refer sql 2003 , keep getting syntax error in query. the trick use set language british. unfortunately checking result select @@language, @@langid shows format still in default seems misleading. the news use of exec sp_configure 'default language' return correct result language format 23 british. john SQL Server  >  SQL Server Express

ok, know default blue background , border appears on treeviewitem when hover or click on it. i've been battling 2 days remove or change different, no avail. any experts out there?  my man justin did in c#: http://blogs.silverlight.net/blogs/justinangel/archive/2009/05/19/silverlight-treeview-advanced-scenarios-treeviewextended.aspx  but it's bogus can't done in xaml.   unless it's totally hardwired in code, guess visual states defined control's template(s). you should able provide custom template control visual states way want to. to started, there's sample templates in silverlight documentation.  here's treeview related one: treeview styles , templates   Silverlight  >  Silverlight Controls and Silverlight Toolkit ...

hi, i new database. need create "hexagon" (beehive) polygon layer cover entire feature layer. user provide the size (diameter size) of each hexagon. python tool exist already, need in sql. possible? if so, how do this? much. bm hello, can explain approach more detailed (on example), please? olaf helper [ blog ] [ xing ] [ mvp ] SQL Server  >  SQL Server Express

i having trouble trying improve processing speed mdx query.   this 1 driving me bonkers i’m hoping can me.   here mdx query:   select crossjoin ([year],{[measures].[quick ratio]}) on columns , crossjoin ( descendants ([department]), descendants ([gl company])) on rows from [glratios]   year count: 9 department count: 33 gl company count: 41 gl summary category id.category count: 25   quick ratio calculated member calculated follows:   'iif(([gl summary category id].[category].&[current liabilities],[measures].[balance]) <> 0,( (([gl summary category id].[category].&[cash],[measures].[balance]) +([gl summary category id].[category].&[accounts receivable],[measures].[balance])) /([gl summary category id].[category].&[current liabilities],[measures].[balance])) ,0) '   the result cell set consists of 1430 rows , 11 columns.   storage method molap.   i have designed aggregations.   1) when run query sql server m...

i have numeric value of data type numeric(38,12) in sql server 2000. loading csv happens is 2000--data looks 115,834,000.00 when loaded csv ---115834000--this how looks. want in database. it of great me, if can tell me work around. thanks, preensheen you number doesn't "look 115,834,000.00" in database.  it's numeric.  it's stored in binary.  it's not text. when use ssms or query tool retrieve value, chooses format number string, , chooses use regional settings display you. ssis typically used machine-to-machine etl transforms.  machines hate formatted numbers, because aren't wimpy humans need thousand separators understand how big number is.  (i'm wimpy human - i'm not picking on you.)  therefore, when ssis writes number text file... writes number without embellishment. in order format - it's pleasing human eye, you're going have turn number formatted string.  unfortunately, ssis's expression language doesn't have...

during ssis deployment validation error have got below snap shot attach, how remove it, can remove warning messages, don't take --himanshu kulkarni, mark thread answered if answer helps you. helps others have same problem !!! hi himanshu, i not see lower image, but unfortunately, warning above should sound alarm. deploying production without ability apply desired configuration not going end well. i suggest review path config. typically a security issue account executing package cannot folder file is, or path expressed mapped drive cannot expanded. or path incorrect. to make story short, need fix access config. arthur my blog SQL Server  >  SQL Server Integration Services

i have stored procedure generates following output. the query generates output stored procedure follows: select tat.[agent-id], tat.[agent-guid], tat.[agent-name] [agentname], tw.tagwidgetid, tw.tagwidgetname, t.tagid, core.fninitialcapitalization(t.displayname) tagname, tt.tagtypeid, tt.tagtypename, tdt.tagdatatypeid, tdt.tagdatatype, tu.tagunitid, tu.tagunit, --case -- when itv.tagindex null 0 -- else itv.tagindex --end [tagindex], isnull(itv.tagindex, 0) [tagindex], --case -- when itv.valueindex null 0 -- else itv.valueindex --end [valueindex], isnull(itv.valueindex, 0) [valueindex], ...

hello in source table, have columns firstname , lastname, both of datatype nvarchar. in dataflow, created 2 new derived columns mapped these 2 columns. when pushing data source, noticed firstname column had value of null while lastname empty string (for rows did not have value) my question is, why source table column firstname showing null value when derived column datatype string , source string? should showing empty string right? thank in advance hello the problem resolved. did not change (strange), reran package , noticed firstname column blank if no data instead of value null thanks SQL Server  >  SQL Server Integration Services

i have 2 build servers, 1 running domain account: acca, other running as domain account: accb, and default service account of tfs acca. when i queue new build using build agent hosted accb, error occurred: acca not authorized connect build agent. i want connect build agent accb, how can that? change service account of tfs?   many thanks, louis  in vsts 2008, there 2 fields, requested , requested for. requested field set server , account made queuebuild call. ci , scheduled builds build system account. manual builds should user queued manual build. requested field seems interested in using. build system account scheduled builds. in other cases, user initiated build. ci builds means user did checkin. manual builds means user queued build.   in ui display requested for, though says requested by.   if using vsts 2008, should behavior want free. so, not sure what's happening in installation cause not work.   when @ completed builds tab of build explorer, builds...

hi all,   is there anyway can select columns different values having same id in row? below data   wo num      productcode location id w-1000       aaa              a1 w-1000       aaa              a2 w-1000       aaa              a4 w-1001       aab              a3 w-1002       aac              a7   and data below trying achieve w-1000        aaa             a1,a2,a4 w-1001  ...

hello, i have merge replication running on sql server 2005 developer edition. able use own conflict handler implemented , deployed own businesslogicmodule written in c#. till here works fine not know how handle following scenarios: 1) when, while synchronization, insert error occurs example because of unique key constraint on rows, not see way solve conflict inside conflict handler. 1 option example delete conflicting row @ subscriber or publisher. not know how inside custom conflict handler. 2) if override example method updatehandler businesslogicmodule have access publisher , subscriber dataset have update conflict. dataset contains 1 table with 1 row. there way define replication have referenced tables in dataset, too? unfortunately, logical records not option because not work custom conflict handlers. hello,   have solved problem no 1) i.e. unique key constarint problem. have similar problem , need help.please post if found solution   ...

hi guys, i have server windows 2003 sp2 , sql server 2005 sp3 and a ssis package make processing cube analysis services processing task. my cube read data on oracle database.  during processing task have connection problem , processing fail, when connection restablished i try run package again, processing task failed again. the task process again when restart ssas service. i use one processing task process dimensions (12 dimensions) , measure group (3) , partitions (3), cube not big have less tha 1gb i process all objects full mode.  someone have idea can solve issue without restart ssas service? thanks all! can please check errors logged in windows event log @ during time SQL Server  >  SQL Server Analysis Services ...

i have new (virtual) windows 7, vs2008 sp1, silverlight 3 environment.  project ria app, use separate (pre-existing) wcf server other things, e.g., graphing data.  should not able step wcf service?  wcf project in same solution silverlight , silverlight.web projects.  compiled debug options turned on, , vs config'd in "debug".  have warnings turn on if no debug info available, , no warning.  doesn't stop on breakpoint.  no clues, no warnings, no break. thanks! i've found  it's tricky debug wcf code if wcf service under different web project other main web project (the 1 has pages , silverlight link) .  do need host wcf on different site? if yes, might better off first make wcf web project running under local iis. 1) add web application under iis point wcf web project folder.  make sure can access using url http://localhost/yourwcfsite/yourwcf.svc in browser. 2) put clientaccesspolicy.xml file under c:\i...

hi i want  do  what see basic stuff.  nightly, 1 database 'updated'  match master.  both azure sql db's on same 'azure sql server'. know can't 'linked servers' in azure 5 tables fk.  to keep things simple will, on target database: remove fk delete/truncate target tables. insert data master db.  there no syncs or updates needed, delete , dump in job. problem none of seems possible azure can see though looks on surface azure meant task. i've tried data factory while seems ok insert/append pile of rows 1 'connection'  another, there doesn't seem  be else can  like first delete target rows never mind remove , re-apply fk's. being able  insert new data seems pointless. i tried the storedprocedureactivity  well in data factory thinking able  run 'pre' , 'post' sql after insert seems  the 'storedprocedure' bit concerned 'mocking'  the tables insert. anybody ideas. said consi...

tfsdeleteproject states deletes project it's associated version control fearful meant trully removed version history. happy find out "delete" action on team project root directory , still able go , old files etc. great. how start new team project based on old deleted team project? know can branch old version in arbitrary way, can project creation wizard can not handle this. i cannot this: tf undelete $/olddeletedproject or tf branch $/oldundeletedproject  $/resurrectedproject /version:50 as these operations return error message: tf10169: unsupported pending change attempted on team project folder $/olddeltedproject.  use project creation wizard in team explorer create project or the tfsdeleteproject tool delete one. our current subversion repository has 250 independent projects on 2.5 years. continuing @ rate hit 500 project maximum, think delete old inactive projects keep below number, feasible if can resurrect old information. a related question, sharepoint site documen...

i have been unsuccessfully trying insert aurora database. supported? hi there, since amazon's aurora mysql not see why not. , not think anyhow ssis related because @ end driver used proper rights , connection string. furthermore, did not tell specifics assume can connect successfully, inserting data results in error yet need let know -> holds key resolving hurdles. arthur myblog twitter SQL Server  >  SQL Server Integration Services

hi trying use ssis convert  and import data input text file sql server database . it giving error  date field. the input data date      90407     , out put should  2007-09-04 . ( or mm/dd/yyyy) .it can null too. mote input  data sample:101112  or  50613 how convert it? use data conversion task  with data type dt_date.did not work . i think need use derived  column.not sure should expression ,because input 7 , 8 chars long.  i error  the conversion returned status value 2 , status text "the value not converted because of potential loss of data."  error: data conversion failed while converting column "startdt" (46) column "copy of startdate" thanks, jay you can convert string first in derived column transformation , use data conversion.  or can conversion directly in derived column.  here code generate string work standard date. ...

hi all, i'm trying create ssis package automate restoring multiple existing backups our san, different sql server instance originated from. i've created foreach loop, configured follows: folder: \\backupserver\sql backup\ files: *.bak retrieve file name: qualified variable mapping configured user::bak , string data, , index of 0, no value or expression defined. use tempdb declare @bak nvarchar (max) set @bak = '?' declare @path varchar(1000)= ''+ @bak +'', @restoredatapath nvarchar(max)='\\sqlserver\r$\usrdata', @restorelogpath nvarchar(max)='\\sqlserver\s$\usrlog' declare @table table ( logicalname varchar(128) , [physicalname] varchar(128) , [type] varchar , [filegroupname] varchar(128) , [size] varchar(128) , [maxsize] varchar(128) , [fileid] varchar(128) , [createlsn] varchar(128) , [droplsn] varchar(128) , [uniqueid] varchar(128) , [readonlylsn] varchar(128) , [readwritel...