Posts

SSIS Data flow task error -2146233033

Image
what error -2146233033? i created data flow task copy data ado net source flat file destination.   i redirecting records errors in flat file.   one of records has error code -2146233033 , can’t find description code. looked in msdn library "integration services error , message reference" , it’s not there. hi sn_d, based on research, error code “-2146233033” represents error message “input string not in correct format”. regarding issue, can check source/destination data , data types mapping in package. regards, mike yin technet community support SQL Server  >  SQL Server Integration Services

SQL Express Question

i'm not sure sql express download. want data management as the ui make forms. i'll importing data back-end access database. james hello james, then use sqlexp wt _x... installer; wt = tools you use sqlexp adv = adv anced services, includes additional reporting services , fulltextsearch olaf helper blog xing SQL Server  >  SQL Server Express

No public ValidationSummary in the Toolkit DataGrid

is there reason why there no public getter returns _validationsummary in datagrid,there 1 in dataform. by using public getter possible add errors standard validationsummary in dataform isn't in datagrid. datagrid.validationsummary.errors.add( new validationsummaryitem(validationerror.errormessage)); or there way this? regards, hi erwin8, sorry misunderstanding. now meaning, built-in datagrid has validatesummary template part doesn't expose validatesummary control, can inherit , expose it: public class customdatagrid : datagrid { public customdatagrid() { this .defaultstylekey = typeof (customdatagrid); } private validationsummary _validatesummary; public override void onapplytemplate() { base .onapplytemplate(); _validatesummary = this .gettemplatechild( "validationsummary" ) as validationsummary; } public validationsummary validationsummary { get { return _validatesum...

MDX Query with parameter

hi ,  i newbie ssas. have created cube having measures [total working days] , [total attendance]  dimentions [employeename],[depatment],[working date] . claling ssas in  sql reports. problem in how measures [total working days] , [total attendance] between 2 dates?   select non empty { [measures].[total working days], [measures].[total attendance] } on columns, non empty { ([employee].[employee name].[employee name].allmembers ) } on rows [employee cube] ..... ( search datetime )? it seems didn’t create user-defined hierarchy. important time calculation. in case, try this:   select {[measures].[call count],[measures].[call duration]} on columns, non empty {    filter(        [time].[ starttime]. [starttime], cdate([time].[ starttime].currentmember.membervalue)> cdate ('2008/10/11 11:20am') and cdate([time].[ starttime].currentmember.membervalue)< cdate (''2008/10/12 03:20pm') ) on rows from [m...

DateName - Month not July we require 07

  hi:   i puzzled following:   if execute " datename ( mm , getdate() ) ", result of july. want month in decimal '07'   can explain change command here?   suresh use datepart instead of datename.   datepart ( mm , getdate ())   regards SQL Server  >  SQL Server Database Engine

SCOPE_IDENTITY via an ODBC connection

in order provide higher availability our internal intranet, upgrading our sql environment single sql 2005 server 2 mirrored sql 2008 servers.  part of process, updating of our php code use dsn connection instead of mssql functions take advantage of mirroring without writing custom solution.  however, during process, have run important problem hoping can shed light on.   in our database classes, after perform insert, use scope_identity() function return primary key of record inserted.  although works using php mssql functions, no longer works when use odbc connection.  based on our testing, both @@identity , ident_current(‘tablename’) work, scope_identity() not.  unfortunately, cannot use @@identity because every change in our database logged in audit table means @@identity returns primary key of our audit table instead of record inserted.  cannot use ident_current(‘tablename’) because works across connections , not connection of user performing insert.  ident_current(‘tablename’) met...

Microsoft Word Has Stopped Working

Image
this office 2013 professional plus. this error happens when start word, , randomly when use ctrl+c, or alt-tab screen. error plain annoying. there solution problem? problem details: problem signature:   problem event name:    appcrash   application name:    winword.exe   application version:    15.0.4551.1006   application timestamp:    526938c8   fault module name:    nvwgf2umx.dll   fault module version:    8.15.11.8688   fault module timestamp:    4a983728   exception code:    c0000005   exception offset:    000000000006aa8f   os version:    6.1.7601.2.1.0.768.3   locale id:    4105 additional information problem:   lcid:    1033   skulcid:    4105 read our privacy statement online: ...