COZYROC has recently introduced the commercial SSIS NoW module. You can now implement SSIS package execution from web service address much easier and without requiring to implement...

The standard Data Flow Task supports only static metadata (columns), defined at design time. If you can use third-party solutions, I would recommend you check the commercial COZYROC Data Flow...

You have to transform the input XML file before trying to read with the XML Source component. Check this post.

Brad,

There is no other way. You have to refresh the components, to make the additional column appear.

Where do you use the password variable? Inside a standard connection manager or in your script ?

Hi,

If you can use third-party solutions, check the commercial COZYROC Parallel Loop Task. The task allows you to select For Each Loop container and execute multiple iterations from the loop...

onejbsmith (2/23/2014)

---

Try the SQL Bulk Copy Component from http://www.Aichabiis.com; it was designed specifically to make it easy to speed up large data loads. It will allow you to...

blasto_max (12/16/2013)

---

LutzM (12/15/2013)

---

What you've described so far is HOW you do your corrent task. But not, WHAT this task really is.

If you'd describe the task you're faced with, we might...

If you use OLE DB connection, the result object is ADO Recordset.

I would say propInfo is NULL. That's why you are getting the error.

The easiest option is to use third-party task like the commercial COZYROC SFTP Task. The task is very similar to the standard FTP Task and supports both FTPS and SSH...

Hi Sam,

If you can use third-party solutions, check the commercial COZYROC SSIS+[/url] library. It contains Excel adapters which support more than 256 columns.

ImageMagick is free.

Hi Karl,

You can use the native database tools to export your table data into CSV file. Then import the CSV file.

Hi Pranay,

COZYROC doesn't provide XML Destination component at this time. We provide Template Task, which can be used to generate arbitrary text documents including XML. You can generate documents with...