Viewing 15 posts - 1,066 through 1,080 (of 3,666 total)
...
Is there a way using SSIS, to get the data to copy from the source to the target exactly as the data exists?
...
In my opinion, this is not the question...
July 29, 2013 at 2:53 pm
SQLRNNR (7/26/2013)
Revenant (7/26/2013)
SQLRNNR (7/26/2013)
select * from closeby_restaurants where cuisine = 'chinese' and distance_from_home <= 2 miles and deliciousness...
July 26, 2013 at 2:37 pm
What's so funny? Isn't that how we all live? 😎
July 26, 2013 at 7:42 am
Try running Profiler during the hours that the tables get filled.
July 23, 2013 at 1:15 pm
You should try the last backup from before you started having problems, assuming you have a backup from before the problems started.
July 19, 2013 at 1:22 pm
Molap (7/18/2013)
you could also do something like WHERE left(TableA.city,2) = TableB.city and TableA.city = 'Boston'
That will only work if the 2 letter code for each city is the first 2...
July 18, 2013 at 11:58 am
Have you tried setting the database to Single_User mode?
July 18, 2013 at 9:57 am
You can query msdb.dbo.sysjobsteps and look for those procedures in the command column.
July 9, 2013 at 9:28 am
The Matrix got rebooted?
Did anyone run DBCC_TimeWarp when it came back up? 😀
May 30, 2013 at 8:43 am
Thanks Wayne.
I was really away. I just started a new contract and I'm happy to be back in the SQL world. I did a search for something yesterday and...
May 30, 2013 at 8:16 am
Yep, still alive. Well, I think I am. 😀
I was away from the SQL world for a while and I'm glad to be back!
May 30, 2013 at 8:13 am
OMG!!!!!
Don't you have anything better to do than wasting your time in here?
😎
May 29, 2013 at 10:55 am
The question referred to the the Data Flow. There's no precedence constraints in the data flows.
Executing these as separate data flows would allow to run use precedence constraints to solve...
February 10, 2012 at 1:12 pm
Brandie Tarvin (5/13/2011)
Alvin Ramard (5/13/2011)
Had to laugh when Grant mentioned DBCC TimeWarp in a presentation. 😀Oh, you have to share. In what context did he mention it?
Wait for the video....
May 13, 2011 at 6:12 am
Viewing 15 posts - 1,066 through 1,080 (of 3,666 total)