Viewing 15 posts - 16 through 30 (of 3,666 total)
You could try adding a single quote, as the first character, to each value exported. When Excel sees a single quote as the first character of a cell it treats...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 4, 2016 at 12:16 pm
Phil's suggestion also makes it much easier to update just one table, or a subset of tables.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 22, 2016 at 10:58 am
Jerid421 (9/22/2016)
Thanks for the response! Wouldn't running a task be a one-time thing though? I want to run this package daily to make sure that the data in...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 22, 2016 at 10:41 am
Take a look at the "Transfer SQL Server Objects Task" task. If it works for you, it could save you a lot of work.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 22, 2016 at 10:29 am
Jeff Moden (9/21/2016)
A "SendDate" as an NVARCHAR(4000)? Now that's a table that probably needs to be redesigned a bit. 😉
Well, depends on how far in the future SendDate might...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 21, 2016 at 2:59 pm
mcfarlandparkway (9/20/2016)
Do we need to specify table name here?
CREATE PROCEDURE [dbo].[sampleLog_Insert]
@table varchar(30),
@date ...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 20, 2016 at 9:33 am
Looks like you have lots to learn about indexing, but I'm not the right person to do the teaching.
... I know technically a table without a clustered index is considered...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 20, 2016 at 8:24 am
BrainDonor (9/19/2016)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 19, 2016 at 12:26 pm
BrainDonor (9/19/2016)
Alvin Ramard (9/19/2016)
BrainDonor (9/19/2016)
Where dates are concerned...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 19, 2016 at 9:20 am
BrainDonor (9/19/2016)
Where dates are concerned it is probably...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 19, 2016 at 7:54 am
GilaMonster (9/9/2016)
...Personally I rather avoid merge.
Really? I now feel better about avoiding merge too. 🙂
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 9, 2016 at 7:32 am
What happened when you tried it?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 8, 2016 at 10:30 am
Keep in mind that if you have a data warehouse with a date dimension, you may already have a useful calendar table.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 8, 2016 at 7:49 am
I think your first priority should be dealing with what's causing the error messages, not the growing of the error log.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 8, 2016 at 7:44 am
Koen Verbeeck (9/7/2016)
You could also just write an expression on the flat file connection manager.
This is how I normally do it.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 7, 2016 at 8:05 am
Viewing 15 posts - 16 through 30 (of 3,666 total)