Posts

why can i NOT convert ANSI to UNICODE using `Data Conversion Transformation`

Image
hello i wondering point of transformation if can not convert between: unicode - code page 65001 to non-unicode - code page 1252 in image below tried converting unicode columns ansi - fails is there configuration needed work? i have use derived columns this; wonder transformation for. many thanks data warehouse | data migration | etl/elt | uk | http://www.brainpowered.net/cms what error get? what source? if it's database, it's easier cast in source query: http://microsoft-ssis.blogspot.com/2011/01/cast-and-convert-to-avoid-data.html please mark post answered if answers question | ssis blog: http://microsoft-ssis.blogspot.com | twitter SQL Server  >  SQL Server Integration Services ...

Script task file check error

Image
hi , in ssis package using script task check whether file exists or not. i having 3 variable below user::v_filepath >file path user::v_geographylevelfilename >filename user::v_fileexistsflg >flag below code using same string filepath = dts.variables["user:v_filepath"].value.tostring() + dts.variables["user::v_geographylevelfilename"].value.tostring(); if ( file.exists(filepath) ) { dts.variables["user::v_fileexistsflg"].value = 1; } messagebox.show(filepath); messagebox.show(dts.variables["user::v_fileexistsflg"].value.tostring()); dts.taskresult = (int)scriptresults.success; but getting exception error. find attached screenshot of error thankx & regards, vipin jha mcp there few areas need check. 1. add namespace, system.io #region namespaces using system; using system.data; using microsoft.sqlserver.dts.runtime; using system.windows.forms; using system.io; #end...

Navigation Frame cache does not reset

hi guys, i have mainpage navigation frame in set cachesize 2 i have 4 pages , 1 of them has navigationcachemode "enabled". can tell me why silverlight caching page correctly never reset cache? the main page looping through same 4 pages every 5 seconds. i load page through code in storyboard completed event handler. contentframe.navigate(i new uri here function)   hi. describe, cannot see wrong here. mean "reset cache"? only pages have cache mode set "enabled" count against cache size. default "disabled". if set cache size 2 , enable 1 page cached, page cached indefinitely; others discarded , re-created later. correct, , describe, it? Silverlight  >  Programming Silverlight with .NET – General ...

Silverlight under ReactOS

Image
hello, i have installed reactos on virtual machine , tried install silverlight under os. reactos computer operating system intended binary compatible application software , device drivers made microsoft windows nt versions 5.x , (windows 2000 , successors). claimed composed entirely of free software, means of complete clean room reverse engineering process, extensive on-going audit, being undertaken protect against claims made outside project. http://reactos.org   so let's watch screen =) , when installtion application has been started, reactos has been suspended =) i guess reactos isn't 100% compatible windows. not sure there's more can that. maybe let reactos folks know? pete Silverlight  >  Silverlight Installation and Setup ...

Type of Locks in Slq server

hi, how many types of locks in sql server ? how release locks? what use of locks? help me. thanks, ramaprasad. hi you can have @ following links http://msdn.microsoft.com/en-us/library/ms190615.aspx http://msdn.microsoft.com/en-us/library/ms190253.aspx SQL Server  >  SQL Server Database Engine

How do you get a TFS Security Report

we have auditors come in review our practices. 1 thing tfs lacks way report on security of users , user groups within tfs project or tfs server whole. missing way information? to see added whom tfs server , where. invariably request gave jim access db code. pretty sure not exist in tfs2008 know if handled in tfs2010? thanks. hi, brthomas, as mattias mentioned, there no such tool find out gives whom permission. can try mattias’ method. in addition, may use tfssecurity /imx command display expanded membership identity information specified group. hope helps! if have question, please feel free post here. best regards, cathy kong   Archived Forums V  >  Team Foundation Server - Setup and Administration ...

Is it possible to create a DB snapshot using Smo entirely from C# .NET code

is possible creat db snapshot using smo entirely c# .net code without resorting trans-sql , sp? a related question: how can enumerate db snapshots smo? thanks. alexb hello alex there no support of creating databasesnapshots using smo instead of executing sql query. can iterate through databases , verify "isdatabasesnapshot" property know whether database snapshot or not.   server srv = new server ( "." );   string databasename = "test" ; srv.connectioncontext.executenonquery( string .format( @"create database {0} on ( name = {1}, filename = 'c:\program files\microsoft sql server\mssql.1\mssql\data\dbs.mdf' ) snapshot of {1}" , snapshotname, databasename));   this .server.databases.refresh();   console .writeline( "list of database snapshots:" );   foreach ( database db in srv.databases) {   if (db.isdatabasesnapshot) {   console .writeline(db.name); } } thanks sreekar ...