Thank you both for bringing up the issue and providing the info!! This was driving me nuts.

You can remove the root tags in the script. Be sure to include the brackets > < around ROOT and /ROOT inside the quotation marks, they won't print in...

I would recommend:

http://www.wrox.com/WileyCDA/WroxTitle/Professional-Microsoft-SQL-Server-2008-Integration-Services.productCd-0470247959.html

Matt

Sorry, my XML form got stripped. Not sure how to reproduce that in the forum. Probably forbiddent characters or format. The SQL statement tells the tale.

Matt

Regarding Tim's original question, I’m sharing this because it drove me crazy for a week. Hope it's useful.

I used a method similar to Dan’s, outputting to a flat file...

Hi Bhushan,

I would test to verify that the Lookup can't compare those types. Nevertheless, I think you're on the right track. The Lookup can be set to various...

Hello Bhushan,

I'm glad to know about the issue with floats and the Profiler, thank you for that. I agree with your plan, it's what I would try first.

Matt

Bhushan ,

Forgive me if I came across as a 2008 expert, we're using SSIS 2005 currently so I don't have the Profiler to test with, and am theorizing at this...

Bhushan,

What version of SSIS? Here's a link but it only applies to the 2008 Profiler Task. Not sure if this is exactly what you want to do but...

I'll give it a go. Thanks!

Peleg,

I second Alvin's suggestion and have had success with this approach.

http://rafael-salas.blogspot.com/2007/03/ssis-file-system-task-move-and-rename.html

Matt

OK, finally got this working but with one minor correction.

That is, I needed to use an Execute SQL task vs. a Data Flow task to be able to specify the...

Thanks pss, I'm going to give that a try today.

Matt

All good suggestions. I like the template idea, seems the cleanest way to do it. I saw another method whereby you select a huge range of cells and...

Hi,

I've just embarked on this same road myself (yesterday), and I know very little at this point. It's possible to programmatically manipulate worksheets from a Script task, but you...