.NET

SpireMedia, ranked by DBJ as one of Denver's Best Places to Work and Denver's Top Web Development Firm, seeks multiple Web developers with advanced Web application programming abilities. We are developing Rich Internet applications on the leading edge of technology and are seeking like-minded developers who are able to leverage their existing skillset as well as learn new methodologies. You must be results-oriented and able to work in a team-based development environment.

If you are an experienced OO developer with a CFMX , Java, C#.NET, or Ruby background familiar with programming within MVC frameworks and are interested in growing your skillset to include Flex, AJAX, Silverlight, and AIR RIA development, we’re interested in talking to you.

Must have demonstrated experience programming .NET Assemblies in C# or developing custom java classes, packaging and deploying WAR/EAR applications under tomcat. Database experience with SQL Server 200-2005 and/or Oracle/PostgreSQL is a requirement. Any RIA development including AJAX and/or Flex is highly desirable, but we can train the right candidate on using Flex Remoting/Actionscript 3 and AJAX to build RIAs. You will be leveraging WebORB and LiveCycle server components and code generators. The applications we build work on the Web and within the Enterprise, so your knowledge of scalability will help. You also need to be able to multi-task across multiple projects and manage your time well.

Secondary Skills Include:

DOM 2, CSS, XHTML
XML, XSLT
CFMX - component object model development
Cairngorm Microarchitecture
Spring Framework
iBATIS Data Mapper framework
Hibernate/NHibernate
XAML
Quality Assurance

Today we had an interesting problem:
Create an SSIS dtsx package that gets a file from an FTP server, puts it in a local directory, then inserts the data from the file into a table. Seems pretty easy, right? Well, the only hard part was getting the regular expression built to get the correct file from the server. The files are a daily data feed feed called "filename0419" or filnamemmdd.

We got to the point of setting the variable using this pretty quickly:

"filename" + (DT_WSTR,30)MONTH(GETDATE()) + (DT_WSTR,30)DAY(GETDATE())

The problem here is that it was returning filename419 - (and would return filename11 if it happened to be Jan. 1) we needed to pad out the dates being returned by the GETDATE() function.

Here is the solution brought to you by SpireMedia top notch developer Tina:

"filename" + SUBSTRING( (DT_WSTR,30)GETDATE() , 6, 2 ) + SUBSTRING( (DT_WSTR,30)GETDATE() , 9, 2 )

this regex returns what we need: filename0419 (and if it's Jan 1, filename0101)