Viewing 15 posts - 4,456 through 4,470 (of 11,678 total)
Phil Parkin (10/17/2013)
Only when you want to set up a dedicated SSIS Server...
October 18, 2013 at 1:17 am
dan-572483 (10/17/2013)
October 18, 2013 at 1:17 am
Jim1234 (10/18/2013)
Thanks! The problem is solved by increasing the space...
Great, glad you got it solved.
October 18, 2013 at 1:10 am
brucekoivu (10/17/2013)
You may need POWERPIVOT which is an SQL 2008 Enterprise feature.
I'm very curious what PowerPivot has to do with PerformancePoint.
You only "need" it if you're going to build...
October 17, 2013 at 10:56 am
Please do not crosspost. It wastes peoples time and fragments replies.
Original thread with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1505694-147-1.aspx
October 17, 2013 at 7:40 am
Performance Point is a SharePoint feature, not a SQL Server one (also not from SSRS), so I believe Entrerprise is not needed. (can't find documentation though that backs this up).
You...
October 17, 2013 at 7:35 am
How do you select the data at the source? Why is the numeric column read as a string column?
October 17, 2013 at 6:15 am
avdhut.k (10/17/2013)
Hi Koen,Datatype of the Numeric column in SSIS is UNOCODE [DT_WSTR]
That's a string datatype. And you're surprised the data is exported as...
October 17, 2013 at 6:09 am
avdhut.k (10/17/2013)
Attached Herewith is excel...
October 17, 2013 at 5:54 am
dorothy.burton (10/17/2013)
how do I set the variables for the FTP task?How to assign values to the variables at run time?
You use expressions on the properties of the FTP task.
October 17, 2013 at 5:29 am
dorothy.burton (10/17/2013)
All the ftp details are variables that get data from a database table and loop through the resultset.
Your point being?
October 17, 2013 at 5:12 am
dorothy.burton (10/17/2013)
How to download using .NET code. I have "ftpservername", "ftpdirectory" and the "filename" details.I need to copy this file to my local server.
Why not use the FTP task?
October 17, 2013 at 5:03 am
Try the protectionlevel EncryptAllWithPassword.
You'll need to supply the password to run the package though.
October 17, 2013 at 4:43 am
dorothy.burton (10/17/2013)
I am familiar with SSIS, but not sure of how to get this task done.
Depends on how you want to download the file.
Could be with the FTP task, or...
October 17, 2013 at 4:39 am
You could use SSIS to do this.
How are you planning to download the file? FTP?
October 17, 2013 at 3:50 am
Viewing 15 posts - 4,456 through 4,470 (of 11,678 total)