Viewing 15 posts - 16 through 30 (of 1,117 total)
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...
March 23, 2013 at 7:14 pm
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...
March 23, 2013 at 7:08 pm
If you can use third-party solutions, check the commercial COZYROC OpenPGP Task. It is completely integrated in SSIS and very easy to use.
March 23, 2013 at 7:05 pm
CptCrusty1 (2/28/2013)
March 5, 2013 at 7:07 pm
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...
March 3, 2013 at 9:52 am
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...
December 21, 2012 at 8:11 pm
opc.three (11/15/2012)
CozyRoc (11/15/2012)
Check here for sample code.
The site says under Requirements:
Depends on CozyRoc Script Task Plus component for implementing parameters user interface.
Is CozyRoc Script Task Plus something that must be...
November 15, 2012 at 10:00 pm
If you can use third-party solutions, check the commercial COZYROC Zip Task. It is completely integrated in SSIS.
November 10, 2012 at 8:26 pm
harri.reddy (10/25/2012)
will xml will be same for all files or it will be different,i am getting files from different companies.
if it...
October 25, 2012 at 7:10 pm
harri.reddy (10/25/2012)
ok,but i am getting multiple file in a folder,how can i pass file in edi source so that it can pick up one by one
You can setup the input...
October 25, 2012 at 2:39 pm
harri.reddy (10/25/2012)
i am getting all this files from client ,so i cant have configuration
They have to provide spec file for it. Otherwise it will be impossible or very hard to...
October 25, 2012 at 2:10 pm
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...
October 25, 2012 at 2:01 pm
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...
October 25, 2012 at 12:10 pm
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...
October 25, 2012 at 12:02 pm
Viewing 15 posts - 16 through 30 (of 1,117 total)