Viewing 15 posts - 1,696 through 1,710 (of 4,272 total)
I'm guessing not, since you aren't telling him what he wants to hear. Give a tool and a fair amount of time and ALL the transaction log dumps, he...
January 24, 2011 at 8:17 am
I would recommend not using that username for anything. In my installations we set the password to some random value that the users don't know, even the DBA usually...
January 21, 2011 at 2:29 pm
GSquared (1/21/2011)
The For...Each loops in SSIS can specify that they are for each file. There's an option for including subfolders.
This is how I would do it. It requires...
January 21, 2011 at 2:16 pm
I was thinking about adding to the utility I wrote for DTS to do this as well..
CEWII
January 21, 2011 at 10:32 am
How many packages and did you use paths in SSIS?
CEWII
January 21, 2011 at 9:46 am
I often recommend trying it with all the possible combinations of temp tables and table variable. In some cases I have been looking at CTE's. Wayne provides some...
January 21, 2011 at 9:44 am
Keep in mind that msdb is a system database and contains information related to the source system. Given that, don't restore msdb from another server.
If you know know the...
January 21, 2011 at 9:31 am
Good idea Phil.. So it was updating but he expected the variable tab to show the updates.. I'll file that one away..
CEWII
January 21, 2011 at 9:24 am
So as I read that you only have them defined at the package level, NOWHERE else, not in any other containers nothing.. You might add a call to a...
January 20, 2011 at 3:57 pm
Mike,
I'm not sure you have to do anything when you compile the apps. They will be architecture agnostic unless you explicitly change the target architecture, so by default they...
January 19, 2011 at 2:28 pm
Brandie,
I think SERVERPROPERTY provides much of the information. What are you looking for in particular? That function can tell you the name of the machine that a clustered...
January 19, 2011 at 1:20 pm
Perhaps I missed something..
I'm not sure why you want want to target an architecture unless you needed to.. The client drivers (native client) for 2005/2008/2008R2 all have 32 and...
January 19, 2011 at 1:10 pm
Are you setting an end date for the trace or changing its state, I would have to say that you need to include more data about what exactly your code...
January 18, 2011 at 3:42 pm
I'm curious, we are calling these security holes in SSIS.. Do we have any other packages that handle it better and is it the duty of the ETL to...
January 18, 2011 at 3:37 pm
Viewing 15 posts - 1,696 through 1,710 (of 4,272 total)