i've seen several links when searching for this problem but nothing definitely solves this...or if it does it seems to be among people who seem to know scripting really well and can figure stuff out. my problem is as follows.
i have a remote server that i connect to (need credentials and cannot use windows authentication), and from this box i need to extract certain tables from certain databases. i tried a linked server and its ridiculously slow. the other method was to build
it via ssis (which needs a mapping structure for each table and cannot be made dynamic). lastly i came across this. this works really well, but i'm amazed that I cant use a variable for the table name. I've tried hardcoding the name, using a string and object
variables but no go.
so i see that people have created a custom transfer objects with vb.net and c#. can someone please give me the layman's code block to enter into the script task? i've tried following instructions and end up with errors. As i paste the code some segments
remain underlined and when you hover your mouse you see tooltips like Type StringCollection not defined. So maybe i'm missing some libraries or dll's that are supposed to go in and i have no clue which ones. i really like using the expressions and have iterated
object variables and simple variables alike and its ridiculous that this is has room to be con
View Complete Post