The Community is hosting an End of Summer sweepstakes! Participants must complete tasks to earn tickets that will enter them with a chance to win a free year of Constant Contact and other great prizes!*
*No Purchase Necessary. For Official Rules, visit here. Constant Contact’s End of Summer 2020 Sweepstakes ends on October, 20, 2020 at 11:50 PM EST.

constantcontactutility dll

Highlighted
Occasional Contributor

constantcontactutility dll

How do you import these dll so they can be used in a SSIS 2008 script component? 

4 REPLIES 4
Highlighted
Moderator

Re: constantcontactutility dll

I have not used our libraries in an SSIS Script Task, but I have found this helpful resource online for accessing custom .NET assemblies in SSIS Script Tasks. Please let me know if you don't find this helpful, or if you have any questions.

Nick Galbraith
Support Engineer
Highlighted
Occasional Contributor

Re: constantcontactutility dll

Thanks,

 

I get an error "No Template Available" when adding the reference. The assemblies are usable until the script task is closed and reopened, then they have lost thier reference.

Highlighted
Moderator

Re: constantcontactutility dll

I did some digging, and I was able to find a string of people having similar errors, while using both custom and standard assemblies. I found this site after some time, and it seems as though he was able to get them installed and lists his method.

 

Again, let me know if this isn't helpful, and I'll try to find some good references to the problem.

Nick Galbraith
Support Engineer
Highlighted
Occasional Participant

Re: constantcontactutility dll

 I have SSIS working with the dll's & the scripts, and yes it took a little tweaking. Further I think that at first working with the DLL's during dev will hinder comprehending how the API works, and now that a unified set of cs scripts are available, I suggest using those for dev then switch to the DLL's in alpha and beta builds/testing and deal with any remaining issues then.

It's been a couple of weeks so I'm not remembering what the errors were and their solutions, but it's enough to say I have it working with the DLL's in Sql Server 2008 r2 developer edition.

 

And now in WPF (.Net 4x)

JeffP...
Developer Portal

View API documentation, code samples, get your API key.

Visit Page

Constant Contact 2020 End of Summer Community Sweepstakes!

The Constant Contact User Community is hosting a sweepstakes. The more you participate, the more chances you have to win! Read on to learn more...

Read More
Featured