Viewing 15 posts - 1,006 through 1,020 (of 4,272 total)
This is really an SSIS question it seems..
First, you can't do it that way, period.
Why don't you explain what you are trying to accomplish and we'll help you try to...
October 11, 2011 at 2:44 pm
Just tried it.. And no you can't.. Sorry. Never saw that functionality..
CEWII
October 11, 2011 at 2:24 pm
I would probably use a Script Task and generate the list manually from the file system and then feed that list to the FEL. I refuse to use xp_cmdshell...
October 11, 2011 at 1:56 pm
As far as tests..
I fail it over a bunch of times and to every possible node.
I make sure I don't have any connection problems when it is runing on any...
October 11, 2011 at 1:54 pm
Jack,
Its really easy to do a failover. In the Failover Cluster Management app, open your cluster and open up "Services and Applications", you'll see SQL Server (or whatever...
October 11, 2011 at 1:46 pm
imani_technology (10/11/2011)
On local machine:Microsoft SQL Server Management Studio10.0.1600.22 ((SQL_PreRelease).080709-1414 )
On remote machine:
Microsoft SQL Server Management Studio10.50.2500.0
Microsoft Analysis Services Client Tools10.50.2500.0
Do you think the version differences are the problem?
Yes, based on...
October 11, 2011 at 1:37 pm
winston Smith (10/11/2011)
Next question. SSIS is a shared component. if i installed a named instance first and then the default, would SSIS be part...
October 11, 2011 at 1:13 pm
What is your real question? What are you trying to answer?
Between 2005 and 2008 the basic structure and capabilities are the same. In 2008 some of the components...
October 11, 2011 at 10:18 am
And by using the DATE datatype you don't get it..
CEWII
October 11, 2011 at 9:56 am
I believe so.
Should give you
DECLARE @StDt DATE, @EndDt DATE, @Now DATE
SET @Now = GETDATE()
SELECT @StDt = DATEADD( dd, ( -1 * DATEPART( dd, @Now ) ) +...
October 11, 2011 at 9:52 am
My first thought is the pacakge store is not stored on Instance1..
Go out to: C:\Program Files\Microsoft SQL Server\100\DTS\Binn
And look for file: MsDtsSrvr.ini.xml
look for information about folders, in particular:
...
October 11, 2011 at 9:45 am
While it is certainly desireable to have only one reference to a server in the config table, it appears that your issue is more about strict adherence to the 3NF....
October 11, 2011 at 9:36 am
Are you using the same version of the tools on the remote machine? I have seen this while trying to use SSMS from SQL 2008 to try and connect...
October 11, 2011 at 9:30 am
Not to be flippant, but did you read that article? It doesn't use Linked servers at all and I don't recommend using them either. It does use a...
October 6, 2011 at 9:50 am
Uh, silly question, why not just degauss your backup tapes 7 years from when they were taken?
The retention policies generally say how long you must retain the data for, it...
October 6, 2011 at 12:01 am
Viewing 15 posts - 1,006 through 1,020 (of 4,272 total)