Viewing 15 posts - 2,131 through 2,145 (of 2,651 total)
November 24, 2018 at 4:23 am
That is normal - when on visual studio all models created on a server have that name format.
should you deploy the model to the server then it will...
November 22, 2018 at 3:41 pm
Bit curious - there may be underlying problems not mentioned.
re: it is not instant file initialization enabled - very few cases where this should not be enabled -...
November 22, 2018 at 2:52 pm
November 21, 2018 at 3:05 pm
November 21, 2018 at 7:19 am
So much learning here!!. Thanks in advance for answering my questions.
I have 2 tables in...
November 20, 2018 at 4:01 pm
just to make it clearer
Publisher
------> Distributor
---------------> subscriber 1
---------------> subscriber 2
---------------> ....
---------------> subscriber N
the above can be any server - they could...
November 20, 2018 at 12:49 pm
November 20, 2018 at 12:43 pm
why not just convert the date to a string on the source select - converting to a format that SSIS knows well will then make the conversion to date straightforward.
November 19, 2018 at 5:11 pm
So I created a series of tables, and all of them looked something like...
November 19, 2018 at 5:01 pm
Using a linked server can also be done through synonyms - so they do fall under the same as a hard-coded db other than the code that is referencing them.
November 19, 2018 at 4:57 pm
A few comments on your code.
Do not as a standard store user functions on master -- master.dbo.ufnStringToPbase should be on any db other than system db's
Do not...
November 19, 2018 at 2:22 pm
November 19, 2018 at 6:55 am
November 19, 2018 at 6:24 am
Viewing 15 posts - 2,131 through 2,145 (of 2,651 total)