Viewing 15 posts - 1 through 15 (of 48 total)
Servers should not need to be linked for this to be accomplished.
The account that SQL Agent runs under needs the relevant access to the relevant databases for processing purposes. Either...
July 30, 2010 at 6:06 am
Depends on your architecture... if it's distributed (as opposed to all on one box) most likely you have the "double-hop" issue and need to configure Kerberos to correctly delegate user...
July 30, 2010 at 6:01 am
Well if you change the data columns in the source file, you have to add them to the flast file connection manager component and through the data flow to the...
July 30, 2010 at 5:51 am
Use a precedence constraint on the connector from that task to subsequent tasks.
In the precedence constraint, use an expression to test for a true or false value as to whether...
January 17, 2010 at 11:40 am
You can execute SSIS packages using DTExecUI.exe
You can find this utility under SSIS tools on a machine that has SSIS installed
January 1, 2010 at 12:02 pm
Two that I know of
That uses linked servers and stored procedures to replicate your SF database locally - we tried it but had mixed success especially with large...
January 1, 2010 at 11:43 am
Run a trace on the Analysis Server to see which account is accessing the cube to perform the processing.
Ensure that account has the security clearance to process the cube in...
October 5, 2009 at 4:39 am
You could double-check your SSAS Server security - they are different to the SQL Server security
Right Click on the SSAS Server from SSMS and check the security credentials - see...
October 5, 2009 at 4:25 am
I did this yesterday.
To configure a connection manager to connect to a dBASE or other DBF file
Add a new OLE DB connection manager to the package. For more...
February 11, 2009 at 4:11 am
Here is a good starting point
November 25, 2008 at 5:53 pm
Well, you could try
Followed by a Data Conversion Task to String
i.e. two separate tasks
November 24, 2008 at 12:30 pm
You might try a derived column using SUBSTRING(yourvalue, 1 100) which will truncate to 100 chars, followed by your conversion to correct string type
November 21, 2008 at 1:48 pm
Sounds like your pages are rendering wider than standard Portrait / landscape A4 page widths.
Check that both your report settings and the size of the obects on the design canvas...
November 21, 2008 at 1:09 pm
Try Teo Lachev's new book
I have his SSAS 2005 book and it's excellent.
November 21, 2008 at 1:04 pm
or did you mean this
= Format(DateAdd("s",-1,DateAdd("d", 1, Parameters!rsThruDate.Value)), "dd-MMM-yyyy")
November 21, 2008 at 12:55 pm