Can you elaborate what will your source SQL statement contain? Are you going to refer to the same columns in each iteration of your loop or the columns will vary?

Hi Dan,

You may have to use XSLT to transform the input XML document, before you process it with the XML Source component.

Try changing the column type to DT_NTEXT.

Hi Lukesh,

I think you are using the default EncryptSensitiveWithPassword option for package protection level. This option will only work if you use exactly the same user account to execute the...

I can suggest an alternative for you to check. It is for SQL Server Integration Services. The latest version of COZYROC SSIS+[/url] library includes NetSuite adapters. You can both read...

I can suggest an alternative for you to check. It is for SQL Server Integration Services. The latest version of COZYROC SSIS+[/url] library includes NetSuite adapters. You can both...

The standard SSIS Data Flow Task requires statically defined metadata and therefore requires setup of separate data flow for each source -> destination combination. If you can use third-party solutions...

VygonDBA (3/23/2012)

---

We have a couple of in-house servers running Jitterbit along side SQL Server 2008 R2 and was wondering if anyone has had any dealing with Jitterbit and whether it's...

This is a duplicate post.

bhushan_juare (9/5/2012)

---

Hi Guys,

I am working on SSIS packge where I want to save mail files(.msg) coming from Mail Server along with attachment using SSIS 2005

Kindly provide links if its...

Hi Ken,

Can you check the following article?

Post back your results.

It looks like you are modifying a reference to a variable with expression, which is incorrect. You have to setup variable which value is dynamically modified with expression.

I'll let you know how my testing goes. Thank you for this exchange, and the others we have been carrying on. It has been very useful to me, and hopefully...

I was trying to find if MySQL themselves have documentation somewhere explaining the performance difference, but I couldn't find any.

The only explanation I have is what I have mentioned earlier....

Knowing enough about MySQL APIs to be dangerous I would be quite interested to know how you're outperforming the methods mentioned on this thread by 30x. Do you have any...