Solved

Precedence Constraint Editor Expression

Posted on 2009-05-15
1
1,789 Views
Last Modified: 2013-11-10

I'm building a constraint editor in my SSIS package. In my expression, I want to check if the filename contains certain values before proceeding.

I wrote something like this, but it didn't work

@[User::FileName] Like "%RT10P%"

Do anyone have any ideas on how to do this?
0
Comment
Question by:jorbroni
1 Comment
 
LVL 1

Accepted Solution

by:
jorbroni earned 0 total points
ID: 24398002

Nevermind found solution.

I will use the findstring function to do this.

0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now