Viewing 15 posts - 1,111 through 1,125 (of 7,191 total)
November 9, 2017 at 2:40 am
When you run a package in Visual Studio, it runs under the account you're logged in as. When you run it on the server, assuming you're running it as a...
November 9, 2017 at 2:36 am
November 9, 2017 at 2:18 am
The command that I am trying is this:
November 8, 2017 at 9:45 am
November 8, 2017 at 9:27 am
No, just make it the length it needs to be and no more, otherwise you'll get inaccurate memory grants and other such nasties when you start to run queries.
November 8, 2017 at 8:36 am
There's nothing to stop you trying these things out... but yes, it will.
John
November 8, 2017 at 7:46 am
Are you saying that the data flow task goes green, but the source and destination don't? Is there anything in the package log that shows the data flow task starting...
November 8, 2017 at 4:02 am
November 8, 2017 at 3:54 am
November 8, 2017 at 2:12 am
I guess I have two questions. I'm trying to make it...
November 7, 2017 at 3:54 am
snomadj - Tuesday, November 7, 2017 2:44 AMHow can I log WHICH field/s have been changed?
It would be easier for us to...
November 7, 2017 at 2:55 am
If you try to summarise for each TaskCode, then you'll lose some detail - in this case, the individual values of StockDescription. Please will you show us what the whole...
November 7, 2017 at 2:32 am
As for the restore part, yes, it's been done before, but it's only a few lines of code. Just query the backupset and backupmediafamily tables on the source server to...
November 7, 2017 at 2:23 am
Is the WAITFOR statement part of a transaction, either explicitly in the code or in the way the task is configured in the package?
John
November 6, 2017 at 7:36 am
Viewing 15 posts - 1,111 through 1,125 (of 7,191 total)