If you can use third-party solutions, check the commercial CozyRoc Zip Task. It supports Zip, GZip, BZip2, Unix (rfc1950) and Tar archives and it is completely integrated inside SSIS.

Puneet,

If you can use third-party solutions, check the commercial CozyRoc Zip Task. It is completely integrated inside...

Hi,

You cannot change the OLEDB Source connection dynamically at runtime. However you can change the OLEDB Connection Manager parameters dynamically using expressions. Have you tried this?

touchmeknot (1/6/2011)

---

Phil, I never meant to offend you. People agree and disagree with many things.

But kindly, do not post any reply if your reply discourages others. People post here when...

JustMarie (1/4/2011)

---

After I started doing the research into this I found out that even once the files get imported there's processing variations. :rolleyes:

We have no control over the format...

This looks much more like what I have in mind, but I don't think I can pay for it and don't like the extra level of indirection. In addition,...

Have you seen Varigence's BIML product? You can generate complete SSIS packages using XML specification and you can also use .NET based scripting. If you are .NET -oriented developer ,...

Developing custom data flow component is not pretty. May I ask you how would you know which columns are mapped to which destination table columns? Are you going to have...

Did you try the forward slash, instead?

This looks like a bug in the driver. Try using OLEDB or ODBC driver instead.

Hi Steve,

The script is simple enough. I would concentrate on the variables. You probably have contention where the same variable is being accessed from multiple simultaneous places.

Without knowing what's your input XML file, I would say use the standard Merge component to combine inputs into a merged view. You will need key columns to make this...

Can you go to the package execution log view and tell us what is the complete error? You can right-click on the line of error and copy the complete text...

Why not use the standard ActiveX Script Task? You can execute legacy VBScript code like the one you have sent without any changes.

As da-zero said you should not use mapped drives, but specify the complete share path instead. The mapped drives setup is associated with the settings of the user account and...