SSIS package can't load dynamic library

Question

Post reply

SSIS package can't load dynamic library

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

washawgolla SSC Eights! Points: 841 More actions · Answer 1

Got it

My machine is 64 bit, I should enforce my ssis package to use 32 bit dll's

problem solved

Thanks,

teddy

washawgolla SSC Eights! Points: 841 More actions · Answer 2

I have one more question though;

I am importing around 60 tables to sql server from interbase; do I have to create 1 data flow task for each table (60 data flow task) or is there an easy way to do it in a single shot

Thansk

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 3

washawgolla (4/22/2010)
I have one more question though;
I am importing around 60 tables to sql server from interbase; do I have to create 1 data flow task for each table (60 data flow task) or is there an easy way to do it in a single shot
Thansk

You could make your package generic, by storing the tables names and columns et cetera in a reference table. Then loop over this table with a for each loop, store the values of the table in variables and use this variables to dynamically construct SQL queries. You won't have to use the data flow though, just Execute SQL tasks in the loop container.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

COZYROC One Orange Chip Points: 28499 More actions · Answer 4

washawgolla (4/22/2010)
I have one more question though;
I am importing around 60 tables to sql server from interbase; do I have to create 1 data flow task for each table (60 data flow task) or is there an easy way to do it in a single shot
Thansk

If you can use third-party solutions, check the commercial CozyRoc Data Flow Task Plus. It includes support for dynamic data flows and you can implement your requirement with only one data flow.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

cardmorekc SSC Rookie Points: 47 More actions · Answer 5

My machine is 64 bit, I should enforce my ssis package to use 32 bit dll's

Thats it Teddy. Had the whole day on this. Thanks Teddy.