Chris,

you can do all of the data conversions in the derived column component so you only actually need one component rather than three.

-jamie

Unfortunately not. Hopefully encryption of dtsconfig files will come one day.

-Jamie

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=254160&SiteID=1

Yeah, one thing I always say is that a DTS mindset is more a hinderance than a help. SSIS is a new paradigm.

-Jamie

Dick,

Yes, you can ref other variables in the expression.

The ability to parameterise SQL statements is there because that's how you did this sort of thing in DTS. Expressions as a...

Interesting. Thanks Rick.

Try constructing the SQL statement in a variable as explained here: http://blogs.conchango.com/jamiethomson/archive/2005/12/09/2480.aspx

This is considered best practice rather than messing about with parameters.

-Jamie

Henrique,

Do not use an ActiveX script. They are there for legacy purposes only. If you need to do any scripting then use the Script Task.

Grant's option is the best one....

Its truer to say that the package must be executed (as opposed to created)on the same server as the destination DB.

Its not a problem tho. The "default" destination adapter to use...

Take a look at the connection string using this technique: http://blogs.conchango.com/jamiethomson/archive/2005/10/10/2253.aspx

and see if there are any problems with it.

And remember, SSIS will NOT store passwords in the config file...

OK,

http://blogs.conchango.com/jamiethomson/archive/2005/12/01/2443.aspx (An explanation of one use of them)

http://blogs.conchango.com/jamiethomson/archive/2005/12/04/2458.aspx (contains a  downloadable demo)

http://blogs.conchango.com/jamiethomson/archive/2006/01/23/2702.aspx (A small tip about using them)

-Jamie

Are you doinng any logging from the packages? What errors do you get from the packages?

-Jamie

A precedence contraint is the red, green or blue line that joins 2 things together in the control-flow.

A raw file is a proprietary format storage file used to pass data...

What error message do you get?

Are your passwords stored in the package?

What is the package's ProtectionLevel property set to?

This problem is usually something to do with package's protection level.

-Jamie

Actually it explains "how to insert in destination table datas which aren't present in destination table"

Use the OLE DB Command transform to do an update.

-Jamie