Viewing 8 posts - 16 through 23 (of 23 total)
Depending upon what you are trying to achieve, you may want to consider calling the web service from a script task or script component. I describe exactly how this...
November 18, 2007 at 4:41 pm
A simple XSLT transform is all you need. Try http://andrewjwelch.com/code/xslt/csv/csv-to-xml_v2.html as your starting point.
November 18, 2007 at 4:30 pm
Your question makes me think that you wish to use an SSAS cube but you are actually thinking about trying to solve the problem with SQL. You need to...
November 18, 2007 at 4:23 pm
An XSLT transform using the sort option on the relevant nodes should do it! You could deploy this as a command line utility to all the team. Even...
November 15, 2007 at 2:03 am
By far the best book is Kirk Haselden's Microsoft SQL Server 2005 Integration Services. Kirk is the Development Manager on the Integration Services team so really knows what he...
November 14, 2007 at 5:20 pm
The same un-sorted list also happens in SQL Server Management Studio projects. Personally, I fix the issue by editing the file in UltraEdit or notepad.
However, if...
November 14, 2007 at 5:11 pm
Easy, use Aspose.Cells to generate native Excel files directly from your Script Task or Script Component in SSIS. I recently posted a blog entry on how to get data...
November 14, 2007 at 5:03 pm
When I used the UK postcode service, some batches were amazingly quick and others were inordinately slow. Talking to the very helpful guys at Postcode Anywhere, it seems the...
November 12, 2007 at 3:54 pm
Viewing 8 posts - 16 through 23 (of 23 total)