It is possible and I have done it since my original post but it is not worth it, too complicated and not worth the effort. It would require some serious...

I concur what dawalker-1068762 has said. MERGE is a wonderful command but use carefully. If the source (SRC ) table is small and light it is feasable and nice to...

I load them programmatically or by editing the config file?

I have one parent table with multiple packages wrapped in sequence containers. the packages in the sequence containers have variables and connections that need to be changed as they move...

I could find and replace, that is what I want to do but how?

thanks Andrew. unfortunately mine is saved on file server not database. I had a script vbs that connected to object model of SSIS and changed values.

I will keep on searching

Awesome article!! So I am not the only one in the same boat. Back then it did suck but now looking back it was well worth it!

ok it seems like I have found the resolution to this problem and yes it is a setting in the SMTP server (in our case Exchange) not a problem with...

Real nice guitar man! But will that resolve the issue though if I am still using the same SMTP server and there are settings on the server that limit the...

well, it was working but now again it konks out with same error. Now using a SQL Task with waitfor delay '000:00:30'

This worked out for me, delaying it for 15 seconds (15000 milliseconds)

' Microsoft SQL Server Integration Services Script Task

' Write scripts using Microsoft Visual Basic

' The ScriptMain class is the...

typical network admin. hey I am a network admin 🙂 typical Microsoft disconnect!

how ar eyou doing all this T-SQL or what? If i assign the ID to ID the data updated successfully, but if i assign ID to Null the new item...

this is how I set package variables at run time

/set \Package.Variables[User::gvServerName].Properties[Value];"SERVER"

is DATA on another server or same sql server where SSIS package is running? does admin have rights to that folder?