If you can use third-party solutions, check the commercial CozyRoc Table Difference component. It solves the exact requirement you have.

You have to transform your XML with XSLT, before loading it with the XML Source component. Check this post.

The only way you can use .NET 4.0 libraries in your scripts is to use SQL 2012, which is not yet officially released.

You might be able to get it working...

Hi Pete,

If you can use third-party solutions, check the commercial CozyRoc Data Flow Task Plus. It is an extension of the standard Data Flow Task , with support for dynamic...

This reply is a bit late, but still worth knowing. If you can use third-party solutions, check the commercial CozyRoc Excel components. These are the relevant components:

* Excel Source component...

This reply is a one-year late, but still worth knowing. If you can use third-party solutions, check the commercial CozyRoc Excel components. These are the relevant components:

* Excel Source component...

Mike Palecek (12/16/2011)

---

I have a package that generates an XML file that I need to send to one of our customers every night.

Their FTP server will only allow connetions using...

kramaswamy (12/14/2011)

---

Yeah Elliott, that's what I figured - had basically already started that anyway, since I was fairly sure there wasn't a better solution. CozyRoc software would be nice, but...

Compared to the standard Excel adapters, CozyRoc adapters support both 32bit and 64bit execution. Make sure you did use...

Arman Khan (12/5/2011)

---

Hi.

Is there a way from SSIS package to load all the Windows Error Logs into a Database from all the windows server.

I am looking to collect all...

This is not the best place for this question. Try posting here.

Did you use the 64bit installer for SSIS+ ? You have to use the 64bit installer for 64bit systems.

You don't need a license key to test and develop from Visual Studio (BIDS).

Is your copy of SQL Server registered or it is evaluation? You will need registered copy to...

Follow these steps to include in your toolbox:

* Open BIDS

* Open any SSIS package

* Open your Toolbox

* Right-click with your mouse in it and select Choose Items… menu

* Click on...

Welsh Corgi (11/27/2011)

---

Is a trial version of CozyRoc available?

I'm sure that it is a great product but I would need to prove that it would help with a specific project...