Viewing 7 posts - 1 through 7 (of 7 total)
I would suggest, if not done yet, testing the correct command on the commandline itself and afterwards making it dynamically within SSIS. And keep in mind that:
- a backslash is...
September 12, 2013 at 9:12 am
Try the following: "-min -m -en \"" + @[User::UnZipFileName] + ".ZIP\" " + @[User::UnZipFileName]
September 12, 2013 at 9:02 am
You actually need double double quotes 🙂 For example: "\\NetworkFolder\\Address\\Misc\\Reports Processing\\\"".
See http://www.sqlservercentral.com/Forums/Topic704932-148-1.aspx for the same issue if i am correct.
September 12, 2013 at 8:42 am
You can find all the improvements over here: http://technet.microsoft.com/en-us/library/ms131456.aspx
I assume the performance is not significantly improved with the new provider. You would have more improvements in the SQL...
September 12, 2013 at 7:44 am
Well, SSRS is cheating a bit to make this possible when you are using multi valued parameters.
Here is an example how to work with it. http://sqlblogcasts.com/blogs/simons/archive/2007/11/22/RS-HowTo---Pass-a-multivalue-parameter-to-a-query-using-IN.aspx.
An other option...
September 12, 2013 at 3:30 am
Have you added double quotes to the location in your command as well? If you do not have that, winzip will not recognize it as a location.
September 12, 2013 at 3:08 am
It is no problem 🙂 You do not have to install any new drivers or providers to connect to SQL Server 2012. You can use the SQL Server Native client...
September 12, 2013 at 2:33 am
Viewing 7 posts - 1 through 7 (of 7 total)