.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Fauzul Azmi
Asad Ali
Post New Web Links

Wild card filter character in SSIS

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
 
In my Data flow task i need to select certain rows which are matching my criteria. The criteria requires using wild card characters like Field1 = '%aaaa%'  or Field1 = '%bbbb%' ......                                                                          Field2 = '%aaaa%'  or Field2 = '%bbbb%' ...... There are 6 fields ( Field1.. Field6 ) that have to be compared against values from a table ( aaaa,bbbb,ccccc etc from table) FindString is not a option. Any help will be appriciated!  


View Complete Post


More Related Resource Links

SSIS And Sybase Source OLEDB connectivity issue with code page for character set

  
Hi I am using SSIS 2008 to connect the Sybase Server version 15.0.3 64-bit. The default character set id used by this Sybase server is 4 (i.e. roman8). (http://manuals.sybase.com/onlinebooks/group-charc/chg0300e/charsets/@Generic__BookTextView/1706;pt=266) I had installed Sybase Client for Sybase OLEDB Driver (ASEOLEDB) to integrate this in OLEDB Source Editor. As per guidance from one of the past MSDN forum discussion, I tried setting property of AlwaysUseDefaultCodePage property to "FALSE"  (http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/f5af9328-e1fb-48d7-a85d-1d08bb7cf0e5/). However, I am still experiencing error message as follows:- ********************************************************* Error at Package2 [Connection manager "xxxxxx.xxxxxxx"]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.  Source: "ASEOLEDB"  Hresult: 0x80004005  Description: "[00000] [Native Code: 30061] [ASEOLEDB]Could not load code page for requested charset". An OLE DB record is available.  Source: "ASEOLEDB"  Hresult: 0x80004005  Description: "[1ZZ001] [Native Code: 30016] [ASEOLEDB]Internal Error". Error at Data Flow Task 2 [OLE DB Source [1]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMC

How to read Hex 00 character in SSIS

  
hello there   i have a large text file which i need to import into sql server. i have been able to map the fields and load the data. it is a fixed width file. the process works. however during testing i found that there are some character which are not visible in notepad. on a hex editor they show the value of 00 - null. in the file . the ssis package reads till the column it finds null and then considers it as a carriage return and moves to the next line.   please suggest how i can resolve this issue. i wrote a vbscript where i could open the file and save it again using notepad, it works for small files. but my input file is around 2 gb.   thanks prasanna

Wild Card Best Bet Matching

  
Is there a way to use wildcards in the keywords used in the Best Bets configuration?

Filter out logically deleted data from dbf file using SSIS?

  
Hi Guys, while loading dbf file to sql server using SSIS,How can i filter out the records that are logically deleted in dbf file?    ~Technology Analyst~

Wild card search with sharepoint datas on SSRS

  

Hi all,

I have created a report with all the fields from a share-point list. The report is fine. Now I have to do a wild-card search in that.

I have to create a text-box where a user enters any text, and when he clicks "view report" the report table should display all the rows with all the occurrence of that keyword entered on that textbox.

 

Dataset I used is

<Query>   <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
   <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
      <Parameters>
         <Parameter Name="listName">
            <DefaultValue>ListName</DefaultValue>     
         </Parameter>     
      </Parameters>
   </Method>
   <ElementPath IgnoreNamespaces="True">*</ElementPath>
</Query>

How to achieve this. Any suggestions


Wild card search with sharepoint datas on SSRS 2008

  

Hi all,

I have created a report with all the fields from a share-point list. The report is fine. Now I have to do a wild-card search in that.

The report will be like this

No      Name     Department

===================

1       John         Finance

2       David       IT

3       Thomas    Consulting

4       Smith       Legal

I have to create a text-box where a user enters any text, and when he clicks "view report" the report table should display all the rows with all the occurrence of that keyword entered on that textbox.

For eg. if I type 'a' in the text-box, it should display all the rows that has 'a'. The output would be

No      Name     Department

===================

1       John         Fina nce

2       Da vid       IT

3       Thom

SSIS Function for find the Occurance of a character

  

Please help me to find the solution for the below requirement.

Input data: "AAAA,BBBB,CC" or "A,B,CCC"

I need to check whether the record is having any comma(,) or not. I need to check this this in a "conditional split transformation".

Please let me know which function will help me.

Many Thanks,

Paritosh


Wild Card with Like Query

  

how i can search all the names that contains hypen ?


multiple regex wildcard and wild card in the middle

  
Is it possible to have more than one wild card? Can it be in the middle ie </td></tr><tr*><td*>

Using jQuery to Filter Table Rows

  
The project is using the .net GridView control, so I had limited control over the output HTML code. Still, I think this code can work for most tables. One thing to notice: you should use the class "filterable" on your table or on one of its parents for the code to work.
First, we need a text box:

GridView Multiple Filter AJAX Control

  
This AJAX control enables the user to filter data within any column inside a GridView. The user can add multiple filters and can delete existing ones too.

Using Conditional Split data Transfer in SSIS 2008

  
This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

WebMatrix conversion failed when converting from a character string to uniqueidentifier?

  

I am trying to retrieve xml from a small function in my .cshtml page. Its throwing me an error. This however, runs fine in a console/form environment.

It takes 3 parameters and 1 exception.

myDll.GetXML(year, username, uniqueidentifier, out ex);

When I run this page I get the error, "Conversion failed when converting from a character string to uniqueidentifier."

Or a stack of.

System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting from a character string to uniqueidentifier.

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

   at System.Data.SqlClient.SqlDataReader.get_MetaData()

   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBeha

Where to Filter the companies returned by the EF?

  

Hi,

I am just starting with dynamic data. I have an enttity framework called UsersModel.edmx.

It returns a list of all companies in the tblCompany table. This list is really big.

I need to filter the list returned to all user controls on the client so that it only returns the company that have a CompanyTypeId= 2 or CompanyTypeId= 3 and company name != "".

1 - Is it possible to filter the company list returned on the server so that I can filter only once for all the controls that use that on the client?

My ideas was to do something like this using linq and lambda but I am not sure how:

return tblCompanys.Where(c => c.CompanyTypeId == 2 || c.CompanyTypeId == 3 && ).Where(c=>c.CompanyName != "").OrderBy(c => c.CompanyName).Distinct().OrderBy(c=>c.CompanyName);
 

2 - I have created a partial class and a metadata class and added the DisplayColumn attribute to use the company name and sort by company name ascending.

Could I use the code to filter the returned companies in this? where?

namespace MarsMedicalModel
{
    [DisplayColumn("CompanyName", "CompanyName")]
    [MetadataType(typeof(tblCompanyMetadata))]
    public partial class t

Filter by Computed Column

  

Hello!


After looking for a driver to open legacy dbf drivers to connect, the next level trouble a have is this one:


first, i can retrieve the data but when trying to filter by a parameter (somesc columns) i get an error.

The error says about the database can't determine some blah blah!

The error is a columm tha is formated (  1234  ) about  8 space, fixed. The values in the query appears like that. I resolve this by Trimming Ltrim(ColumnName) and i get this (1234).

Now in SqlExpress, how can i filter by the new Trimmed Expression? (This is a primary key that the DBF use)

Sample:

SELECT column1, column2, column3
TABLE FoxProDB

Now 

SELECT Ltrim(column1) as NewExp, column2, column3
TABLE FoxProDB
Where NewExpre = @NewExpres                  -Error-


Thanx!


LDAP nested groups filter

  

Hi all,

In my organization we use nested groups.

For a particular usage, we have a group (let's assume that the group name "kuku"), and the names of all the nested groups under it contains "kuku" as well.

We may assume that no other group in the LDAP has "kuku" in the name.

I need to create a filter which will return all the users which belong to one of the "kuku"s group.

Obviously, using this filter will bring only the head kukus

(&(&(objectclass=user)(objectclass=person))(memberOf=CN=kuku,cn=.rest of the group DN.))

How can I use wild card to fetch all users which belong to any kuku?

For example: (&(&(objectclass=user)(objectclass=person))(memberOf=CN=.*kuku.*))

Thanks,

Asi


Want to create Online Business Card designing functionality

  

 I am going to create Online Business Card designing functionality.

 I am newbie regarding graphics in asp.net. I want to create exactly like following site.

 

http://www.smitteninvitations.com/designStudio.aspx?variantId=86&Quantity=50

 

I have some questions

 

1) How can I write user text in existing image on the fly?

2) How to embed that with aspx page?

3) How to generate it with user inputs like text, font color, size?

 

Please give me any tutorial URL or any link that could help. Is there any compo

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend