Viewing 15 posts - 9,016 through 9,030 (of 9,641 total)
Do you have full version of SQL server or only express? SSIS is designed for exactly this purpose. Look in BOL on how to use it.
March 13, 2008 at 9:30 am
I would assume it is possible, although I do not know if you can add then to the sys sheba. I have added custom SPs to master for the same...
March 13, 2008 at 9:19 am
Nice article. I like the fact that is clearly takes you from start to finish and offers a solution to a commonly encountered problem.
March 13, 2008 at 6:35 am
The server had to go to disk to get the data in your first query and the second query the data was all cached in memory. Thus your IO...
March 12, 2008 at 8:00 pm
Is your database really on a linked server connected to your local machine? I did not know that you could do that. Why are you not...
March 12, 2008 at 7:55 pm
I am not real familar with the backup software out there, but I have heard horror stories of these backup agents having problems and not being able to do restores....
March 12, 2008 at 1:25 pm
SQL Server configuration manager for services and features will show whatever was installed. Also if you installed either ssis or ssrs bids will be installed and you will have ssis...
March 12, 2008 at 1:19 pm
Are you sure the file is tab delimited? Have you previewed the source in ssis to verify you are getting the columns? Have you manually mapped the columns in...
March 12, 2008 at 1:16 pm
Are all the updates running as one transaction? You may want to try wrapping each update in a begin-commit block.
March 12, 2008 at 1:11 pm
Don't know why it was affect a linked server query, but the only difference I see (other that Standard vs. Enterprise) is that is works on Windows SP1 and not...
March 12, 2008 at 8:06 am
Matt Miller (3/12/2008)
March 12, 2008 at 7:56 am
Adam Bean (3/12/2008)
Andrew Watson (3/12/2008)
Try here : http://technet.microsoft.com/en-us/library/ms178085.aspx(Good luck - it's a bit of a monster calculation, although the one for non-clustered is even worse).
Nice find. Wonder if anyone has...
March 12, 2008 at 7:40 am
All right, just relax. So you upgraded from SQL 2000 to 2005, an in place upgrade, but the RS database stayed in 8.0 or 2000 mode and this worked...
March 11, 2008 at 8:29 pm
This sounds like a good candidate for a fuzzy lookup or fuzzy grouping transformation. You would set it up for an exact match on Last Name and a fuzzy...
March 11, 2008 at 7:42 pm
I suggest configuring the error output to redirect row and outputting the data to a table or file so you can see what row(s) are being rejected. You are...
March 11, 2008 at 7:35 pm
Viewing 15 posts - 9,016 through 9,030 (of 9,641 total)