I am trying to use a text file to provide a variable in an SSIS package so that the end user can input different invoice numbers to be run through a process. I have found some help online which says to use a Script Component to pull the data from the file into the Variable however I have not written much Visual Basic code in the past and I have got a bit stuck. I am using Visual Studio 2008 however the article I have found online is using Visual Basic for Applications and I keep getting errors when I use that code. Help!
I'm not sure why you would use a script component, when all you should really need is a Flat File Connection / Flat File Source Component and perhaps a Derived Column Component. Am I missing something?
Francis ----------------- SQLRanger.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply