Running functions in an Ssis package

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

robboll - 03 Feb 2010 09:58 GMT

Whenever I paste in some Vba code from an ms access module it errors
on parts of the code that I have no problems with in Access. I
couldn't find a references library in ssis and the script task
defaults to a sub procedure. So I'm thinking maybe functions aren't
allowed or I'm using an incorrect method. All I'm trying to do is
entanciate two variables: FY and FM with the current fiscal year and
fiscal month to use in a select statement.

Any assistance with this greatly appreciated!

RBollinger

Reply to this Message

Todd C - 05 Feb 2010 15:16 GMT

Functions are certainly allowed in SSIS Script tasks. You just don't have the
VBA object model at your disposal but I'm conficent that you can get the
right logic with just a few lines of code.

I have seen some of your other posts concerning this issue, but could you
re-state the issue in sentances your mother would understand (ie: NOT
code-speak). Then we'll help you write the code.

Signature

Todd C
MCTS SQL Server 2005

> Whenever I paste in some Vba code from an ms access module it errors
> on parts of the code that I have no problems with in Access. I
[quoted text clipped - 8 lines]
> RBollinger
> .

Reply to this Message

robboll - 05 Feb 2010 22:23 GMT

If Functions are allowed is SSIS Script tasks, where are the library
references listed in SSIS?

thanks!

BTW Todd, I really appreciate your responses. It seems there isn't a
whole lot of help with SSIS in cyberworld. Do you have any
suggestions on where I should be looking to jump these hurdles? I've
attended a couple of programmed courses that I thought were a complete
joke. If I can fight my way through a practical application task like
this I believe it is ten times better than taking a class. You've
been a great help!

RBollinger

Reply to this Message

Todd C - 08 Feb 2010 13:56 GMT

I leanred a LOT from responses in these forums. It's good to know others are
too.
I also learned a lot from books. One of my favorites on this subject was
"Professional SQL Server Integration Services" by Wrox (Sorry I don't have
the ISBN for you). It as written by a host of authors and had many good
exercises to help you learn the concepts.

Be careful referencing external libraries in your script functions because
when you deploy this to a server, that machine may not have those libraries
available.

HTH

Signature

Todd C
MCTS SQL Server 2005

> If Functions are allowed is SSIS Script tasks, where are the library
> references listed in SSIS?
[quoted text clipped - 11 lines]
> RBollinger
> .

Reply to this Message