Hi

I know this sounds stupid, but have you re-downloaded the package and opened it in VS? More times than I care to remember have I opened a package to find...

bump

anyone got any ideas on this?

Hi Jo, I've tried your code with my email address, and our local exchange server and it worked fine. It seems that your peoblem is more with server config than...

Just SQL update statements. Typical would be a couple of deduplication querys, TPS, MPS and our internal Do Not Contact list.

You could use an OnPostExecute Event handler to write to the file. Either

1. write to a string for each event and use a data flow to put to a...

It seems that you will need the ability to change the input fields metadata at runtime, I'm not sure this is possible, as these are set at design time and...

duplicate thread, see link

Hi, You need to set the result set to store to a variable, otherwise you will get this error.

Right click anywhere on the control flow screen and select variables, add...

It doesn't really matter, the one I have infront of me uses an OLE DB, and this works fine.

L

Hi xavendano

First You need to have the resultset of the inital query going into an SSIS object variable you create.

Then change the enumerator in the loop container to "For Each...

Well, that makes the problem much simpler. You could have a SQL task pull a list of tables into a recordset, use a script, or sql task to generate the...

WinSCP doesn't have an API, so there isn't any methods which are available to us. The usual approach would be to develop a winscp script which contains the desired commands,...

Yea, I was thinking this, and would be a good idea if I could make it generic somehow. I made a script to dig the metadata from the dts framework...

Hi Mathew

Add a breakpoint to the first control in the package, and set it to run. You now should see the locals window at the bottom of your screen. You...

Hmm, interesting idea, however I'm not sure this would be any more efficient than concatinating the fields from the data source. This would involve me either changing files manully (not...