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


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

SSIS Expression

Posted By:      Posted Date: September 12, 2010    Points: 0   Category :Sql Server
 
Hi Guys,   Input: ProductCatalog_181416_20100513010253_2010517_22715_2010715_172740 Expression Used: SUBSTRING(@[User::FileName], FINDSTRING(@[User::FileName], "_", 1) + 1, FINDSTRING(@[User::FileName],"_",3) - FINDSTRING(@[User::FileName],"_",1)-1) Output Getting: 181416_20100513010253   Out Put Required : 181416_20100513   Can please help he out how to get above output.   Thanks,


View Complete Post


More Related Resource Links

SSIS Expression?

  
In my SSIS_HST table have 2 columns one is last process date and counter value.Those values are i am storing in package variables. i will take one enddate variable .enddate=last process date+ counter value.if the last process date valeu is 2010-02-07 and counter value is 3 then my end date value =2010-02-10.How add those expression in my end date variable..  

SSIS Expression Request

  

Hi Guys,

Input DataType String: C:\Test\CONV-Files\192572\01012010.ajk

Output Required: 192572

 

I am using below expression for start position, but for some reason FINDSTRING function is searching for "\", it throwing me error message. If I change it to ":" it will 2 position.

e.g: FINDSTRING(@[User::strFQDN], "\", 3)

All, I want is output like this 

192572

 

Thanks,

 

D

 

 

 

 


SSIS 2008-Variable Expression Type Cast Syntax Error

  

Hi all members.

I need to ask for the following code. I need to convert the variable into a string.

"Select Distinct convert (int ,A.CustomerCategory) as AccountReceivableCategoryID, convert (varchar(40), B.Text) as AccountReceivableCategoryNameE
from Inkunde A , inpara B
where A.CustomerCategory= B.SearchItem
and B.Language1 = 'EN'
and B.ParameterName = 'CATEGORY'
and A.CustomerCategory = (DT_STR,200,1252) "+  @[User::CategoryID] +"
Order By A.CustomerCategory"

Kindly any member let me know, How to correctly use the Type Cast fucntion in variables

Thanks and Best Regards,

Izhar


SSIS Expression to send email with dataset on the Mail Subject line.

  

Hi

I have a task - I need to email total number of products sold on the subject line of the mail task.

I have Execute SQL task process like select count(*) from tablename. Then I need to Mail the result set like "Total products sold September 2010 : 15000" on teh subject line.

I created a variable bit i dont know how to assign it on the subject line of the Send Mail Task.

I would really appreciate if you can guide me.

Thanks for your help.

Febten


SSIS - Setting TablesList Property with expression

  

I am having problems withing with the Transfer SQL Server Objects task in SSIS.  I would like to set the TablesList Property of the task to the value of an expression.  At a high level, I need to transfer a table from one server to another but the table name is dynamic so I can't use a data flow task.  Each iteration of the package execution will work off of one table so I need to set the TablesList property to the one table. 

Since the property is a collection, I am getting errors when I attempt to just assign the TablesList property to the variable value in the expression builder.  I get this error:

Error at Copy Table To Production: The result of the expression "@[User::TablesList]" on property "TablesList" cannot be written to the property. The expression was evaluated, but cannot be set on the property.

I also tried to open up the SSIS package in textpad and look at the formatting of the TablesList property and then set the variable to match what I saw in the XML......this gave me the same error.

Any suggestions on how to set a StringCollections property in SSIS?

Thanks in advance,

John


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.

[How??] Lamda expression with ByRef parameter

  

How to write lamda expression with ByRef/ref parameter in c# ??

The code below causing syntax error:

item.OnAction = (p1, p2, ref p3) => {
   .....
   .....
   return true;
};


item.OnAction = (p1, p2, & p3) => {
   .....
   .....
   return true;
};



Express Yourself: Encoding Videos Using Microsoft Expression Encoder 3 SDK

  

Video on the Web involves huge amounts of data. Learn the best way to manage and move that data with the help of Microsoft Expression Encoder 3.

Adam Miller

MSDN Magazine June 2010


Security Briefs: Regular Expression Denial of Service Attacks and Defenses

  

Microsoft security expert Bryan Sullivan believes denial-of-service blackmail attacks will become more common as privilege escalation attacks become more difficult to execute. He demonstrates how to protect your apps against regular expression DoS threats.

Bryan Sullivan

MSDN Magazine May 2010


Silverlight: Create Animations with XAML and Expression Blend

  

In this excerpt from his upcoming book, Laurence Moroney explains the basics of Silverlight animation and the animation tools available in Expression Blend.

Lawrence Moroney

MSDN Magazine August 2008


Silverlight: Create a Custom Expression Encoder Publishing Plug-In

  

Laurence Moroney demonstrates how to employ the Expression Encoder plug-in APIs by building and debugging a simple FTP upload plug-in.

Laurence Moroney

MSDN Magazine February 2008


Hanselminutes Podcast 227 - Inside Expression SuperPreview with developer Mike Calvo

  
Scott talks to Mike Calvo, a Microsoft Lead Developer based out of Minnesota (!) about Expression SuperPreview. SuperPreview helps developers and designers with cross-browser CSS and HTML issues. How'd they build it and with what? What's inside? How does the cloud fit in and how do they support Safari? I played with SuperPreview a bit last year, but started looking at it again last month when I noticed that version 4 has introduced support for Safari on Mac via a Cloud-based Remote Service. I fired up Expression SuperPreview 4, and saw this: Then I signed up: Which enabled Mac Safari for this initial beta. I assume they'll add a pile of other browsers. If I don't see immediate browser support for ALynx, the Amiga port of Unix...(read more)

Help with regular expression

  

Hello,
I am using this regular expression: /.*-lyrics-.*$

and I need the expression find urls like this:
http://domain.com/lor-mbongo-lyrics-loboko-txphzzf

and it do really does that!

The problem is that it finds also this URL:
http://domain.com/lost-lyrics-5mk4f/lyrics

Whar regular expression should I use to exclude urls that end with /lyrics ?

Thanks :]

 

 


Regular Expression to Match
in HTML

  

Here is the kind of text I want to match via a regular Expression

The id="dgSchedule" is always present in the TAG but its location may differ

The table is span over multiple line/contains white spaces/tabs...

I have the regular expression to match the start and end tag respectively over a single line

\<table .*\>

\</table\>

The problem is to match the whole table span over multiple lines

<table cellspacing="0" rules="all" border="1" id="dgSchedule" style="border-style:None;height:100%;width:100%;border-collapse:collapse;">
	<tr class="blackbar" align="center" style="background-color:#7FB4DE;font-family:Verdana;font-weight:bold;height:20px;">
		<td>From Place</td><td>To Place</td><td>Time</td><td>Bus Type</td>

	</tr><tr style="background-color:#DEECF5;">
		<td>1</td><td>2</td><td>00:15</td><td>Express</td>
	</tr><tr style="background-color:#EFF5FA;">
		<td>2</td><td>3</td><td>00:15</td><td>Express</td>
	</tr><tr style="background-color:#DEECF5;">

		<td>3</td

asp expression bound to user control parameter?

  

How can I get pass the DataKey of a GridView to a usercontol, preferably without code behind.


Why doesn't this work:

<ucOrderDetails:AJAX_OrderDetail ID="od1" runat="server" OrderNumber='<%# GridView1.SelectedValue.ToString() %>'  />

GridView1 is just a list of orders with a DataKey of OrderNumber.

od1 is not inside of a databout control, does it need to be?


Syntax error (missing operator) in query expression

  
Good Day Gurus!

I have a Excel user application which has a user form (named 'Registo') that displays criteria and an image that has been entered in it's corresponding spreadsheet. This works the way it should.  There's also the ability to search the spreadsheet via a form (by clicking 'Pesquisar' button) this opens a search form. However, I having a bit of a problem with it. When I try to search for something it basically doesn't do anything at all. It just sits there. So I tried to debug it and I think I'm having a problem with either the JET db engine or somethign with teh query or maybe I don't have the correct reference.

I 'borrowed' this Excel application from another forum because it's exactly what I'm looking for! However, I suck at vb.

So I was hoping somebody could take a look at the code and see if I'm missing something?  I'm kinda' desparate to get this working because I'm been trying to figure it out for days and I'm running out of time.  Cry
 
Option Explicit

'constantes para auxiliar na verificação do código
Private Const Ascendente As Byte = 0

using SharePoint List for SSIS package

  
I need to use a sharepoint list as data source for SSIS package, it works fine until the sharepoint site implement Kerberos only (IIS 7) authentication, anyone knows how to get around this? thanks.
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