Viewing 15 posts - 9,646 through 9,660 (of 9,720 total)
Steve,
Believe it or not, having IT experience period will do much to help you out. My major problem was not having any professional (read "paid with appropriate job title") IT...
February 8, 2007 at 6:27 am
Did you follow the instructions in the Microsoft KB Article?
If so, are you saying they are still having problems? What sort of errors are they getting?
January 29, 2007 at 4:44 am
This article should help you out. There are additional permissions on the Server OS that you have to grant in order for non-sysadmin users to launch SSIS.
January 26, 2007 at 6:54 am
For the most current stuff you need to bag the job, you should look carefully at the job description. Depending on the company, DBA duties can be partitioned out (Production/Maintenance...
January 25, 2007 at 5:17 am
It might be a domain replication issue.
If the domain controller that is handling the account with the just-changed password hasn't replicated the password change to the domain controller that is...
January 23, 2007 at 10:29 am
NP. Let us know if you need any more help.
January 18, 2007 at 5:17 am
Well said! And thank you for the perspective. I know I'm not going to get everything I want, but at least I can warn them. Then, if they don't listen...
January 18, 2007 at 4:53 am
I think Microsoft stuck the XML stuff in SQL 2k5 because so many people were using it, not because they wanted to. Yes, there's a lot of nifty stuff, but...
January 18, 2007 at 4:49 am
I almost forgot...
You should be able to use a Script task in an SSIS package to move the XML file over to your server from the website.
January 17, 2007 at 4:53 am
Am I reading your code right? You actually had to join the document to itself to get it in SQL Server properly?
January 17, 2007 at 4:52 am
Steve,
You da Bomb! @=)
Darren, do a PatIndex search on the char(13) that Steve recommends and that will get you started. I recommending creating your multiple columns in a Temp table...
January 16, 2007 at 12:17 pm
Steve,
I appreciate the reply. My main problem in checking load is that I don't currently have a DW side to check the load against. I will, however, check the load against...
January 16, 2007 at 12:15 pm
There is a TON of data in Books Online about XML under the heading "XML". The very first thing I thought of when I saw your post was mapping the...
January 16, 2007 at 10:43 am
Absolutely. The key is knowing what the carriage return character looks like (which I, unfortunately, don't).
You can do this one of two ways. 1) Use an SSIS package to pull the...
January 16, 2007 at 10:31 am
I think you should test this. Create a job that does a few daily backups via the traditional SQL Server method, but backs up to the SAN drive. Tack on...
January 2, 2007 at 8:04 am
Viewing 15 posts - 9,646 through 9,660 (of 9,720 total)