And if integrated mode causes your hair to fall out - I jest, but I am bald! - then you can install the SSRS WebParts 2.0 cab file into SharePoint...

Try the following:

1) Can you access the server?

2) Can you access the share and verify write access is still enabled?

3) Can you run the command and verify that it executes...

If...

I am trying to Import a flat file (delimited) into a SQL server table. the was created from a unility which is not too flexible. I have the date format...

This article http://msdn.microsoft.com/en-us/library/ms140114.aspx may help point you in the right direction.

Also http://zulfiqar.typepad.com/zulfiqars_web/2006/11/ssis_web_servic.html or http://aspalliance.com/1167_A_StepbyStep_Approach_to_Creating_a_Web_Service_Task_Using_SQL_Server_Integration_Services.all.

Hope this helps!

Well maybe this example is not with windows functions as they are...

Or instead of breaking out into a external process, you can use the script task and SharpZipLib (http://www.icsharpcode.net/OpenSource/SharpZipLib/) or DotNetZip (http://www.codeplex.com/DotNetZip) C# Zip frameworks.

This is how...

Hi John,

I am currently building a data warehouse as a consultant in conjunction with a Microsoft Consultant and have asked this question. Using a data conversion process I have found...