I was using Method 4, saw this post and was an immediate convert to Method 1 till I saw Method 3, the simplest yet, and as it turns out, the...

Here's one I get all the time:

"Column 'col1' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause"

because I...

I'm interested in this as well - anybody? Bueller, Bueller....

Gaurav,

He left out some important details about the inner loop. That one should be configured as a Foreach File Enumerator, not and ADO enumerator. The rest of the...

I've successfully used parameter mapping with an Insert statement, the only difference in mine is I used a Values clause instead of a Select. why don't you try to...

Parameter of type Long maps to variable of type Int32 just fine (aren't all the different data types maddening in SSIS?) -I've done that successfully many times using an OLE...

you must work in the same place I do.

thanks so much. Would you also recommend scheduling the master package using SQL Agent?

oh I forgot to show you how to assign a value to an SSIS variable in code:

Dts.Variables("your SSIS variable").Value = varConnectionString

I'm no sure what you meant when you said you...

If you have followed the suggestion in the error message you posted and STILL are getting the error then you have a syntax or other error in your script preventing...

Use a script task. Include the variable you want to assign the connection string to on the ReadWriteVaribles property on the Script tab of the Script task Editor....

Yes, totally agree. I work in a small shop without many "smart people" and I not only start to enjoy my job less, but after a while get downright...

No, but thanks for trying! I'm not doing anything webby right now at all - just trying to get a freakin SSIS package with a script component to run....

Some more info on my "out of memory" error thrown in my script component:

It is configured as an asynchronous transformation. In some cases , I add multiple rows...

No, not calling custom assemblies though I do have one loaded as a reference. I wrote a custom class as part of the script component. Thanks so...