Hi Mike,

I think a good stairway level could be the one in which you could show how to use the XLM and JSON extractors, developed by the MS...

Maybe this can help you:

http://www.ssas-info.com/analysis-services-scripts/1210-powershell-script-to-list-info-about-one-analysis-services-database

Regards

Thank you for your suggestion!

Hi Lutz, it was a MySQL problem: I used the Text data type instead of LongText!!

Thank you!

Thanks Lutz, you are right. It was a my misunderstanding, VARCHAR(MAX) can hold up to 2 GB! :w00t:

I'll try it tomorrow and I'll let you know.

Thank you again for your...

Thank you Matthew 🙂

The xml text has a lot of rows I have to import in a MySQL table every night. A solution can be that I call an INSERT...

Thank you for you answer Lutz! 🙂

I tried this solution and it works right, but I often have to import xml text that has more than 8000 chars! Here I...

I'm sorry, this is the wrong section for this thread... Can any admin move it to "T-SQL (SS2K5)"? Thank you

Thank you for the script Wildcat, it's very useful for me!

Ok, I know this solution works. I was trying to export with that new provider...

As you can see, in SQL Server 2008 you can choose the Excel 2007 Provider directly.

You are right, but I choose the Excel 2007 provider to export it. I change the extension in the wizard, because it generate a file with the xls extension automatically,...

I got the solution empirically... The package goes on with this string stored in the @cmd variable:

C:\Progra~2\Micros~2\90\DTS\Binn\DTExec.exe /DTS \MSDB\StratificaGiacenzaDaCSV /SERVER DV-ERP /SET \package.variables[strRollUpDate].Value"; 2008/10/01 23:00" /MAXCONCURRENT " -1 "...

Look at this:

http://weblogs.asp.net/mikebosch/archive/2007/10/26/ssis-skipping-rows-and-stripping-subtotals.aspx

😉

I solved the issue adding a " at the beginning of the string:

EXEC master..xp_cmdshell '""C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /DTS "\MSDB\StratificaGiacenzaDaCSV" /SERVER "DV-ERP" /SET \package.variables[strRollUpDate].Value;"2008/09/30 23:00" /MAXCONCURRENT " -1 "...