Viewing 15 posts - 10,471 through 10,485 (of 11,676 total)
brian.willis (1/13/2011)
January 14, 2011 at 12:51 am
Grant Fritchey (1/13/2011)
Does a heck of a lot more than just format the code too.
That sounds like: it does also your dishes, the laundry and it unclogs your toilet 😀
January 14, 2011 at 12:14 am
johnzabroski (1/13/2011)
"By the time that SQL Server 2000 was released,...
January 14, 2011 at 12:04 am
Stefan Krzywicki (1/13/2011)
Is the INTO just there to make it compatible with ANSI standards?
They threw it in so Celko would be happy.
January 13, 2011 at 11:43 pm
bruce.b.allen (1/13/2011)
steveb. (1/13/2011)
or you could put the data as is in a...
January 13, 2011 at 9:33 am
You can force the execution result of the data flow to succeed, so your loop would always continue.
However, this raises another problem: how to detect failure? If you can do...
January 13, 2011 at 9:30 am
Paul Brewer (1/13/2011)
For SSIS jobs there's an 'Execution Options' tab iwhere you can specify 'Use 32 bit runtime' , no need to write batch files.Regards
That is unfortunately only possible from...
January 13, 2011 at 8:59 am
MARKDSQL (1/13/2011)
That sorted it, thanks very much.
No problem, glad to help and that it worked out.
January 13, 2011 at 8:54 am
dkschill (1/13/2011)
I was trying to demonstrate the EXISTS syntax as a replacement for IN.
That will only work if you are looking for the existence of rows that have a particular...
January 13, 2011 at 8:52 am
Jan Van der Eecken (1/13/2011)
Ray K (1/13/2011)
Thank you, fellow Threadizens, for coming to my rescue -- and I'm not just talking about getting my simple question answered.I've been Celkoed again.
In...
January 13, 2011 at 8:46 am
Toreador (1/13/2011)
You mean I was supposed to read all the words in your reply?!
For the one time Hugo has fairly short reply 😀
January 13, 2011 at 7:45 am
MARKDSQL (1/13/2011)
Can i specify wether to use, or not use...
January 13, 2011 at 7:42 am
dkschill (1/12/2011)
You could use the EXISTS statement:DELETE FROM TableA WHERE EXISTS (SELECT 1 FROM TableB WHERE TableA.Key = TableB.Key)
This is just plain wrong. If TableA and TableB are the same...
January 13, 2011 at 6:39 am
Are you running the package from BIDS?
Make sure the Run64BitRuntime property is set to False.
(right-click on project, select properties, look in the debugging pane)
January 13, 2011 at 6:32 am
Viewing 15 posts - 10,471 through 10,485 (of 11,676 total)