Connecting Tech Pros Worldwide Help | Site Map

variables in SSIS

  #1  
Old November 5th, 2008, 11:15 AM
Pawel
Guest
 
Posts: n/a
Hello
I haven't found any solution neigther on MSDN Website nor Books online
so decided to ask a question to real experts :-)

I'm quite new to SSIS and VS so the aswer might be obvious but not for
me.

In the first step of Data Flow I want to select records from the
table.
I use OLE DB Source and in Data access mode i select SQL cemmand.
Is it possible to user variables (created on package) in WHERE clause?

I get error ...
Any ideas?

Thanks for any suggestions.
Pawel
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding files in a directory that begin with string datamonk answers 2 August 4th, 2007 03:45 AM
SSIS declare output stevemcdee answers 0 February 22nd, 2007 11:41 AM
Get the variable from Execute Process Task in SSIS to C# Carl answers 0 August 23rd, 2006 03:55 PM
need help in SSIS ETL development AMAN answers 0 May 30th, 2006 08:55 AM