Viewing 15 posts - 9,166 through 9,180 (of 9,720 total)
That's not what I meant. I only ever use the OLE DB sources and destinations. Hence, I don't know the trick (and there is one, I remember seeing...
January 10, 2008 at 8:42 am
Technically, nothing should be using the SA account. If you have jobs, processes, users or anything else using the SA account, you've already got a serious security problem.
SA should...
January 10, 2008 at 8:26 am
And once the email goes out, even if it's only to legit business users, it only takes one "blonde moment" to forward the email to someone outside of the business,...
January 10, 2008 at 8:14 am
I always use OLE DB sources, so I really can't answer that question for you. Has anyone else done ODBC sources?
I recommend the SSIS book put out by McGraw...
January 10, 2008 at 8:03 am
What you need to do next is add a data flow task to the control Flow. Data flow should be in the Toolbox. Add that, double-click the icon,...
January 10, 2008 at 7:29 am
Yes, that's what I was looking for, but couldn't find it because I was looking in BOL under "Table" instead of "Database".
And in BOL 2000, they actually list "statement" as...
January 10, 2008 at 6:52 am
You can also use the COALESCE() function to pull everything together.
Declare @cols varchar(4000);
Select @cols = COALESCE(@cols + ', ' + MyColName, MyColName)
from MyTable Order by MyDate;
Select @cols;
The order by...
January 10, 2008 at 5:40 am
You want scary documentation?
Google "SA Account" or "SA Account best practices". This should come up with plenty. Especially since so many worms & viruses use the SA account...
January 10, 2008 at 4:37 am
And then there are global temp tables that start with 2 pound signs (##d). These tables are available to any connection using the database so long as there are...
January 10, 2008 at 4:21 am
You're also going to have to create your destination data source before you do anything. Once you've done that, add a Data Flow Task to the Control Flow. ...
January 10, 2008 at 4:16 am
You know, it occurs to me to add a few more replies to the original post.
RE Q#2) Yes & no. If you're new to SQL 2k5 or haven't used...
January 9, 2008 at 4:15 am
The only way that kind of lazy works IRL is if you have a boss that doesn't care if you can actually adminster or develop on SQL Server and allows...
January 9, 2008 at 4:05 am
Thanks for the response, Steve. I'll just use the general search again, then.
January 8, 2008 at 9:20 am
As far as question # 1 goes, make sure you download the errata for the book (regardless of version) before studying. Every version of the book has its...
January 8, 2008 at 7:33 am
Viewing 15 posts - 9,166 through 9,180 (of 9,720 total)