sql server - Creating a FuzzyLookup object using BIML with BIDs Helper -
i'm trying create fuzzylookup object using biml bids , visual studio 2008.
the following code erros , not compile error "could not resolve reference dbo.juniorsurveyresponses". object dbo.juniorsurveyresponses exists , have correct permissions it.
if remove fuzzylookup create remainder of code compiles without error. code https://www.varigence.com/documentation/samples/biml/fuzzy+lookup.
any ideas error?
<biml xmlns="http://schemas.varigence.com/biml.xsd"> <connections> <oledbconnection name="sportsdata" connectionstring="provider=sqlncli10;server=myserver;initial catalog=mycatalog;integrated security=sspi;" delayvalidation="true" /> </connections> <packages> <package name="my package" constraintmode="linear"> <tasks> <dataflow name="my dataflow task"> <transformations> <oledbsource name="surveyresponses" connectionname="sportsdata"> <directinput>select * surveyresponses</directinput> </oledbsource> <!-- performs fuzzy lookup on attribute column against juniorsurveyresponse db, , outputs corresponding response column newresponse. --> <fuzzylookup name="fuzzy lookup transformation" connectionname="sportsdata" exhaustive="true" > <referencetableinput tablename="dbo.juniorsurveyresponses" /> <inputs> <column sourcecolumn="attribute" targetcolumn="attribute" /> </inputs> <outputs> <column sourcecolumn="response" targetcolumn="newreponse" /> </outputs> <inputpath outputpathname="surveyresponses.output" /> </fuzzylookup> <flatfiledestination name="outputfile" connectionname="flatfileconnection" overwrite="true" /> </transformations> </dataflow> </tasks> </package> </packages> </biml>
i think problem referenced example varigence.com is using referencetableinput
. believe means expects <tables>
collection defined within project , of stuff.
instead, think you're looking externalreferencetableinput
syntax like
<externalreferencetableinput table="dbo.juniorsurveyresponses" />
using source, following fuzzy lookup created.
if that's not how fuzzy lookup should look, let me know. never use transformation despite heavy ssis usage.
for following along @ home, created 2 tables in source system as
create table dbo.juniorsurveyresponses ( attribute varchar(50) , response varchar(50) ); create table dbo.surveyresponses ( attribute varchar(50) , response varchar(50) );
Comments
Post a Comment