Ir para conteúdo
Fórum Script Brasil

rafael silveira

Membros
  • Total de itens

    6
  • Registro em

  • Última visita

Sobre rafael silveira

rafael silveira's Achievements

0

Reputação

  1. Bom dia, eu tenho sempre que trabalhar com arquivos em txt, de mais de 2 gb de tamanho e extrair informações, mas alguns arquivos vem com formato americano, de separação de numero, como o "ponto" no lugar da "virgula", quando estou importando eu consigo transformar a coluna de valores no formato SI , que é o usado no brasil ? ou tenho que usar algum comando dentro do sql pra isso ?
  2. eu consegui instalar, mas só depois de fazer tudo acima e instalaro sql server native client 10.0, Valeu pela ajuda,
  3. Eu ainda não consegui, acessei o log, e ele me mostra isso : Summary_RAFAELMAC-PC_20111109_134836_LandingPage Overall summary: Final result: Passed Exit code (Decimal): 0 Exit message: Passed Start time: 2011-11-09 13:48:39 End time: 2011-11-09 13:51:41 Requested action: LandingPage Machine Properties: Machine name: RAFAELMAC-PC Machine processor count: 4 OS version: Windows 7 OS service pack: Service Pack 1 OS region: United States OS language: Português (Brasil) OS architecture: x86 Process architecture: 32 Bit OS clustered: No Package properties: Description: SQL Server Database Services 2008 R2 ProductName: SQL Server 2008 R2 Type: RTM Version: 10 SPLevel: 0 Installation location: c:\d5b149fd24f15d7fb78a626d561d\x86\setup\ Installation edition: EXPRESS_ADVANCED User Input Settings: ACTION: LandingPage CONFIGURATIONFILE: ENU: True FARMACCOUNT: <empty> FARMADMINPORT: 0 FARMPASSWORD: ***** HELP: False IACCEPTSQLSERVERLICENSETERMS: False INDICATEPROGRESS: False PASSPHRASE: ***** QUIET: False QUIETSIMPLE: False UIMODE: AutoAdvance X86: False Configuration file: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20111109_134836\ConfigurationFile.ini Detailed results: Rules with failures: Global rules: There are no scenario-specific rules. Rules report file: The rule result report file is not available. alguém pode me dar uma luz ? tks,
  4. Eu fiz o na ordem, instalei o .net framework 3.5, só não consigo visualizar onde ativo ele., e instalei o .net 4.0 client profile, mas minha versão é windows 7, e não acheio o windows installer para esta versão. Poderi me ajudar, continua dando o mesmo erro, o que devo fazer agora ?
  5. Boa tarde, alguém poderia me ajudar, porque eu não sei que erro deu na instalação do SQL server 2008 express r2 consigo abrir o processo de instalação, mas antes de iniciar, já aparece em uma caixa vermelha este erro, abaixo. See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Configuration.ConfigurationErrorsException: An error occurred creating the configuration section handler for userSettings/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings: Could not load file or assembly 'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. O sistema não pode encontrar o arquivo especificado. (C:\Users\Rafael Silveira\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\10.0.0.0\user.config line 5) ---> System.IO.FileNotFoundException: Could not load file or assembly 'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. O sistema não pode encontrar o arquivo especificado. File name: 'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' at System.Configuration.TypeUtil.GetTypeWithReflectionPermission(IInternalConfigHost host, String typeString, Boolean throwOnError) at System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.Init(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord) at System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.InitWithRestrictedPermissions(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord) at System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory..ctor(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord) at System.Configuration.RuntimeConfigurationRecord.CreateSectionFactory(FactoryRecord factoryRecord) at System.Configuration.BaseConfigurationRecord.FindAndEnsureFactoryRecord(String configKey, Boolean& isRootDeclaredHere) WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. --- End of inner exception stack trace --- at System.Configuration.BaseConfigurationRecord.FindAndEnsureFactoryRecord(String configKey, Boolean& isRootDeclaredHere) at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject) at System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission) at System.Configuration.BaseConfigurationRecord.GetSection(String configKey) at System.Configuration.ClientConfigurationSystem.System.Configuration.Internal.IInternalConfigSystem.GetSection(String sectionName) at System.Configuration.ConfigurationManager.GetSection(String sectionName) at System.Configuration.ClientSettingsStore.ReadSettings(String sectionName, Boolean isUserScoped) at System.Configuration.LocalFileSettingsProvider.GetPropertyValues(SettingsContext context, SettingsPropertyCollection properties) at System.Configuration.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider) at System.Configuration.SettingsBase.GetPropertyValueByName(String propertyName) at System.Configuration.SettingsBase.get_Item(String propertyName) at System.Configuration.ApplicationSettingsBase.GetPropertyValue(String propertyName) at System.Configuration.ApplicationSettingsBase.get_Item(String propertyName) at Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings.get_WindowPlacement() at Microsoft.SqlServer.Configuration.LandingPage.LandingPageForm.OnLoad(EventArgs e) at System.Windows.Forms.Form.OnCreateControl() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.WmShowWindow(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.ContainerControl.WndProc(Message& m) at System.Windows.Forms.Form.WmShowWindow(Message& m) at System.Windows.Forms.Form.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) ************** Loaded Assemblies ************** mscorlib Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.5448 (Win7SP1GDR.050727-5400) CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll ---------------------------------------- mscorlib.resources Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.5448 (Win7SP1GDR.050727-5400) CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll ---------------------------------------- LandingPage Assembly Version: 10.0.0.0 Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1540 ) CodeBase: file:///c:/ec07bdab7b359171f8b69027e3/x86/LandingPage.exe ---------------------------------------- System.Windows.Forms Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.5446 (Win7SP1GDR.050727-5400) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.5447 (Win7SP1GDR.050727-5400) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- System.Drawing Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- Microsoft.SqlServer.Configuration.Sco Assembly Version: 10.0.0.0 Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1540 ) CodeBase: file:///c:/ec07bdab7b359171f8b69027e3/x86/Microsoft.SqlServer.Configuration.Sco.DLL ---------------------------------------- Microsoft.SqlServer.Chainer.Infrastructure Assembly Version: 10.0.0.0 Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1540 ) CodeBase: file:///c:/ec07bdab7b359171f8b69027e3/x86/Microsoft.SqlServer.Chainer.Infrastructure.DLL ---------------------------------------- System.Xml Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- Accessibility Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll ---------------------------------------- Microsoft.SqlServer.Management.Controls Assembly Version: 10.0.0.0 Win32 Version: 10.50.1600.1 ((KJ_RTM).100402-1540 ) CodeBase: file:///c:/ec07bdab7b359171f8b69027e3/x86/Microsoft.SqlServer.Management.Controls.DLL ---------------------------------------- System.Configuration Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- ************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box.
  6. Bom dia, tenho uma coluna que vai o numero de cada filial, mas alternando com valores nulos, exemplo: FILIAL 120 _ _ _ _ 125 _ _ _ _ e vai assim ate a filial 200, gostaria de saber como fazer uma formula para copiar a filial até a proxima sem apagar a mesma. exemplo 120 120 120 120 125 125 125 125 tentei diversas maneiras, mas não consigo, tentei o raciocinio do excel, mas não deu, poderiam me ajudar ? Obrigado,
×
×
  • Criar Novo...