For the process you want to accomplish using the standard SSIS will not be much of help and will in fact make your solution even more complicated.

If you still want...

How did you determine the Lookup transformation is what slows you down? I believe the issue is the OLE DB Command transformation. Try loading the update rows into a staging...

If you can use third-party solutions, check the commercial COZYROC OpenPGP Task. It is completely integrated in SSIS and very easy to use.

CptCrusty1 (2/28/2013)

---

I'm not a .Net developer and have very little familiarity with creating utilities so this option wouldn't work for me with out turning it into a project that would...

Excel automation from SQL Job Agent will not work because the Excel automation is based on running the Excel application itself. The Excel application is desktop application which requires full...

Another inexpensive alternative for SSIS is the COZYROC SSIS+[/url] library. It includes Dynamics CRM adapters among many other useful extensions. All deployment types are supported: Premise, Live, Hosted, Federation. No...

opc.three (11/15/2012)

---

The site says under Requirements:

Is CozyRoc Script Task Plus something that must be...

Check here for sample code.

If you can use third-party solutions, check the commercial COZYROC Zip Task. It is completely integrated in SSIS.

harri.reddy (10/25/2012)

---

ok,but we have to supply two files xml and .dat

will xml will be same for all files or it will be different,i am getting files from different companies.

if it...

You can setup the input...

They have to provide spec file for it. Otherwise it will be impossible or very hard to...

The EDI Source component is part of the SSIS+ library. You can download the latest version from here. There are separate installers for 32bit and 64bit systems. When you test...

As Koen have stated this is not possible with the standard SSIS, which only supports static metadata. This means you have to create separate data flow for each table you...

This look like EDI file. If I'm correct, then you can forget about processing it with the regular Flat File Connection Manager. The EDI format is hierarchical and more similar...